Greetings,
* Zachary Hanson-Hart (zac...@temple.edu) wrote:
>I know that the requirement for replication is that a user be allowed to
> connect to the "replication" database. My question is how to configure the
> streaming replication client to use a particular authentication method. I
> hav
On Tue, Feb 19, 2019 at 5:31 PM Thomas Munro wrote:
> On Tue, Feb 19, 2019 at 5:16 PM James Sewell
> wrote:
> >> Here's a starter patch that shows one of the approaches discussed. It
> >> gets WSL users to a better place than they were before, by suppressing
> >> further warnings after the firs
Hi Melvin,
Unfortunately I was not able to use it because I was not able to access
pg_authid in RDS.
Thanks.
Tiff
On Thu, Feb 21, 2019 at 6:09 PM Melvin Davidson
wrote:
> Tiffany, have you tried the clone_schema function? It seems to me it does
> exactly what you need, no dumping or restoring.
forgot to cc pgsql-general list
De : legrand legrand
Envoyé : vendredi 22 février 2019 20:26
À : Bruce Momjian
Objet : RE: pg_stat_statements doesn't track commit from pl/pgsql blocks
Hello Bruce,
thank you for taking time to answer.
yes, I was expecting someth
I started trying to debug backup with minimal WALs for achieve consistency, it
is from 'server 2'
and it only needs 20 WAL files.
It error was:
ERROR: xlog flush request 44B/7E5DAB28 is not satisfied --- flushed only to
44B/7305B560
CONTEXT: writing block 0 of relation base/16506/16891_vm
===
On Fri, Feb 22, 2019 at 2:03 AM Tom Lane wrote:
> Bruce Momjian writes:
> > On Thu, Feb 21, 2019 at 09:31:32PM -0500, Stephen Frost wrote:
> >> * Bruce Momjian (br...@momjian.us) wrote:
> >>> There was too much concern that users would accidentally start the old
> >>> server at some later point,
Hi pgsql-general,
I know that the requirement for replication is that a user be allowed to
connect to the "replication" database. My question is how to configure the
streaming replication client to use a particular authentication method. I
haven't been able to find examples of streaming repli
On 2/22/19 4:46 AM, github kran wrote:
On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos
mailto:arcano...@gmail.com>> wrote:
Just adding that my case it's not a Amazon RDS, it's common server,
if I can say like that...
Aplologies I missed the point to mention that this is a que
I've set up 2 instances of PostgreSQL 11. On instance A, I created a table
with 2 local partitions and 2 partitions on instance B using foreign data
wrappers, following https://pgdash.io/blog/postgres-11-sharding.html.
Inserting rows into this table works as expected, with rows ending up in
the app
Hi Everyone,
I have a partitioned by period table scenario here where I need to
execute a query with a function in where clause.
I'm not sure if this is the best approach to do that, but when I use the
functions, it scans all the tables instead only the desired one. If I put
the parameter hard
On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos
wrote:
> Just adding that my case it's not a Amazon RDS, it's common server, if I
> can say like that...
>
Aplologies I missed the point to mention that this is a question to
PostgreSQL community. We are currently using PostgreSQL. ( Aurora
Just adding that my case it's not a Amazon RDS, it's common server, if I
can say like that...
Thanks Got it
Regards,
Jitendra
On Fri 22 Feb, 2019, 4:03 PM mariusz On Fri, 22 Feb 2019 13:23:11 +0530
> Jitendra Loyal wrote:
>
> > I find that the RECURSIVE can be used only once in a CTE.
> >
> > I have the following use-case where there is a hierarchy of
> > store_groups, and then ther
Hi all.
Taking advantage of the topic I would like to know the recommendations
about how to update to a newer Postgres version having all that amount of
data.
Anyone one could share your experience about?
Thanks in advance.
Regards,
Samuel
Thanks Andrew
I will try this and revert; I was specifying RECURSIVE for the second CTE
as well.
Regards,
Jitendra
On Fri, 22 Feb 2019 13:23:11 +0530
Jitendra Loyal wrote:
> I find that the RECURSIVE can be used only once in a CTE.
>
> I have the following use-case where there is a hierarchy of
> store_groups, and then there are stores associated with a
> store_group. Requirement is to ensure that a store ca
> "Jitendra" == Jitendra Loyal writes:
Jitendra> I find that the RECURSIVE can be used only once in a CTE.
RECURSIVE can be specified only once, but it applies to all CTEs at that
level. That is to say, RECURSIVE qualifies the preceding WITH, _not_ the
following CTE.
Note that just specify
I find that the RECURSIVE can be used only once in a CTE.
I have the following use-case where there is a hierarchy of store_groups,
and then there are stores associated with a store_group. Requirement is to
ensure that a store can be used only once in a store group hierarchy.
Following definitions
18 matches
Mail list logo
