pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMaster Archiving and replica
3+ messages / 2 participants
[nested] [flat]
* Master Archiving and replica
@ 2013-01-03 13:15 Viktor <viktor@okservers.eu>
2013-01-03 14:26 ` Re: Master Archiving and replica Jov <zhao6014@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Viktor @ 2013-01-03 13:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Master Archiving and replica
2013-01-03 13:15 Master Archiving and replica Viktor <viktor@okservers.eu>
@ 2013-01-03 14:26 ` Jov <zhao6014@gmail.com>
2013-01-03 15:21 ` Re: Master Archiving and replica Jov <zhao6014@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jov @ 2013-01-03 14:26 UTC (permalink / raw)
To: Viktor <viktor@okservers.eu>; +Cc: pgsql-admin
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<http://www.postgresql.org/mailpref/pgsql-admin;
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Master Archiving and replica
2013-01-03 13:15 Master Archiving and replica Viktor <viktor@okservers.eu>
2013-01-03 14:26 ` Re: Master Archiving and replica Jov <zhao6014@gmail.com>
@ 2013-01-03 15:21 ` Jov <zhao6014@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jov @ 2013-01-03 15:21 UTC (permalink / raw)
To: Viktor <viktor@okservers.eu>; +Cc: pgsql-admin
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 ?
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-01-03 15:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-03 13:15 Master Archiving and replica Viktor <viktor@okservers.eu>
2013-01-03 14:26 ` Jov <zhao6014@gmail.com>
2013-01-03 15:21 ` Jov <zhao6014@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox