Обсуждение: Master Archiving and replica

Поиск
Список
Период
Сортировка

Master Archiving and replica

От
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.


Re: Master Archiving and replica

От
Jov
Дата:

yes,and there  is   an offical tool to safely clean them:
http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html

在 2013-1-3 下午9:16,"Viktor" <viktor@okservers.eu>写道:
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-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Master Archiving and replica

От
Jov
Дата:

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

在 2013-1-3 下午10:48,"Viktor" <viktor@okservers.eu>写道:
On 1/3/2013 4:26 PM, Jov wrote:

yes,and there  is   an offical tool to safely clean them:
http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html

在 2013-1-3 下午9:16,"Viktor" <viktor@okservers.eu> 写道:
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-admin@postgresql.org)
To make changes to your subscription:
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 ?