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 with
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 gets
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.
On 08/11/2018 08:18 AM, Phil Endecott wrote:
Dear Experts,
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 with the Debian stable
packages of PostgreSQL 9.6. My replicati
Dear Experts,
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 with the Debian stable
packages of PostgreSQL 9.6. My replication setup involves a third
server, "backup",
Hi,
On Fri, 2018-08-10 at 21:49 +0200, Christoph Berg wrote:
> plv8 will work for anyone willing to go through that. It's just not
> feasible to support it from a packager perspective.
+1 from me.
Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red
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
expe
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
path|ordin
