Re: Wal streaming

2025-11-25 Thread Andrew
Hi, I’m using Postgres 17 and the latest versions of repmgr and barman 1. I’m replicating my database to another node using streaming replication. wal_level=replica, hot_standby=on. 2. I’ve got barman running on the primary node locally and have setup the barman config for streaming replicatio

Re: Wal streaming

2025-11-25 Thread Adrian Klaver
On 11/25/25 05:46, Andrew wrote: Hi, New to the list. If I’m Using streaming archiving with repmgr, and streaming archiving with barman, do I still need to maintain my archive command, and have processes in place to delete archived wals periodically? Or are they in effect defunct due to wal

Wal streaming

2025-11-25 Thread Andrew
Hi, New to the list. If I’m Using streaming archiving with repmgr, and streaming archiving with barman, do I still need to maintain my archive command, and have processes in place to delete archived wals periodically? Or are they in effect defunct due to wal retention policies within Postgres?

Re: WAL streaming and dropping a large table

2021-10-23 Thread Mladen Gogala
On 10/21/21 16:23, Rory Falloon wrote: Hi, My postgres server setup is thus: a production database, which is using WAL streaming (hot standby) to four other hosts of various latencies. I Have a table that is ~200GB which has been backed up, and now I Want to remove it. The table is not in

WAL streaming and dropping a large table

2021-10-21 Thread Rory Falloon
Hi, My postgres server setup is thus: a production database, which is using WAL streaming (hot standby) to four other hosts of various latencies. I Have a table that is ~200GB which has been backed up, and now I Want to remove it. The table is not in use, it is a child table to a parent table

Re: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-28 Thread Guillaume Lelarge
Atul Kumar a écrit : > >> As per your error, it seems replication slot has been dropped. >> >> On Saturday, March 27, 2021, FOUTE K. Jaurès >> wrote: >> >>> Hello EveryOne, >>> >>> How can I solve Issue. ??? >>> >>> >>

Re: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-28 Thread FOUTE K . Jaurès
?? >> >> >> >> *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" >> does not exist2021-03-27 11:48:33.012 WAT [1090] LOG: background worker >> "logical replication worker" (PID 8458) exited with exit code 12021-03-27 >&

Re: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-27 Thread Atul Kumar
As per your error, it seems replication slot has been dropped. On Saturday, March 27, 2021, FOUTE K. Jaurès wrote: > Hello EveryOne, > > How can I solve Issue. ??? > > > > *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" > does not exis

ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-27 Thread FOUTE K . Jaurès
Hello EveryOne, How can I solve Issue. ??? *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist2021-03-27 11:48:33.012 WAT [1090] LOG: background worker "logical replication worker" (PID 8458) exited with exit code 12021-03-27 11:48:3