Discussion:
Master Archiving and replica
(too old to reply)
Viktor
2013-01-03 13:15:26 UTC
Permalink
Hello,

I have running postgresql maste-slave replication with activated
archiving-mode on the master.

Question: is it safe to clean older archived logs or it may corrupt the
slave replication ? And what is the best way to clean them (by making
snapshots)?


--
Regards.
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jov
2013-01-03 14:26:34 UTC
Permalink
yes,and there is an offical tool to safely clean them:
http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html
Post by Viktor
Hello,
I have running postgresql maste-slave replication with activated
archiving-mode on the master.
Question: is it safe to clean older archived logs or it may corrupt the
slave replication ? And what is the best way to clean them (by making
snapshots)?
--
Regards.
--
http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
Jov
2013-01-03 15:21:30 UTC
Permalink
the standby can not reach the archieved wals? what the wal archieve used
for? turn off it or archieve to nfs/scp to make standby can use the wals.

please cc the mail list
Post by Jov
http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html
Post by Viktor
Hello,
I have running postgresql maste-slave replication with activated
archiving-mode on the master.
Question: is it safe to clean older archived logs or it may corrupt the
slave replication ? And what is the best way to clean them (by making
snapshots)?
--
Regards.
--
http://www.postgresql.org/mailpref/pgsql-admin
Thanks for the link. The topic tells about to clean up WAL file archives
when running as a *standby* server, but I am running archiving just on
the *master* and not on the standby (slave). And I dont have
recovery.conf on the master.
What about cleaning archived wals on the master server ?
Loading...