Greetings,
* Phil Endecott (spam_from_pgsql_li...@chezphil.org) wrote:
> Dear Experts,
Since you're asking ...
> I recently set up replication for the first time. It seemed to be
> working OK in my initial tests, but didn't cope when the slave was
> down for a longer period. This is all
On 08/11/2018 12:42 PM, Phil Endecott wrote:
Hi Adrian,
Adrian Klaver wrote:
Looks like the master recycled the WAL's while the slave could not
connect.
Yes but... why is that a problem? The master is copying the WALs to
the backup server using scp, where they remain forever. The slave
Hi Adrian,
Adrian Klaver wrote:
Looks like the master recycled the WAL's while the slave could not connect.
Yes but... why is that a problem? The master is copying the WALs to
the backup server using scp, where they remain forever. The slave gets
them from there before it starts streaming.
Hi there,
I am trying to build an application which reads messages off of a
replication slot and does some processing with them. I want to guarantee
that every event gets processed exactly once. Unfortunately, I've been
unable to find a guide to the correct way to read this data. I've been
Hi everonye,
I don’t know if this is still a topic for anyone. But here is a query that I
came up with to do the sorting. It will currently probably not make use of the
ltree indexing, so it might be worth to further adapt the query.
The table (example_table) would be something like
Hi
2018-08-10 21:00 GMT+02:00 Bruce Momjian :
> On Fri, Jul 20, 2018 at 05:31:40PM -0700, Adrian Klaver wrote:
> > JD sit down, I am going to agree with you:) The documentation as it
> stands
> > is very good, though it requires some fore knowledge to successfully
> > navigate. On pages with a