Search Postgresql Archives

Re: recovery.conf and archive files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



is the archive command even needed? I can see my standby fully synced. 

On Fri, Oct 14, 2022 at 5:27 AM Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:
Le jeu. 13 oct. 2022 à 12:42, Rita <rmorgan466@xxxxxxxxx> a écrit :
The primary's recovery.conf looks like this

listen_address='*'
wal_level=replica
synchronous_commit=local
archive_move = on
archive_command = 'cp %p /var/lib/pgsql/11/data/archive/%f'
max_wal_senders = 10
wal_keep_segments=10
synchronous_standby_names='standby0'
wal_log_hints=on


The archive command stores the WAL in a local directory. That's what I said earlier.
 

On Sun, Oct 9, 2022 at 8:45 AM Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:
Hi,

Le dim. 9 oct. 2022 à 13:54, Rita <rmorgan466@xxxxxxxxx> a écrit :
I have primary and standby replication setup.

On my primary the archive directory is rather large (30GB) and growing. On my standby I have recovery.conf which has 
archive_cleanup_command = 'pg_archivecleanup -d /var/lib/pgsql/11/data/archive %r'

I was under the impression this line would remove data from my primary AND standby. Is that not the case?


pg_archivecleanup will clean up the *local* directory. It won't clean up the archive directory if it's stored on the primary.

If I misunderstood your issue, it would be great to send us the postgresql.conf file from your primary.


--
Guillaume.


--
--- Get your facts first, then you can distort them as you please.--


--
Guillaume.


--
--- Get your facts first, then you can distort them as you please.--

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux