Re: Master Archiving and replica

From: Jov <zhao6014(at)gmail(dot)com>
To: Viktor <viktor(at)okservers(dot)eu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Master Archiving and replica
Date: 2013-01-03 15:21:30
Message-ID: CADyrUxOWBq=j47E04B3BD54Z9RDjMiswHYx14hE0Rd9vVAdOYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)okservers(dot)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(at)okservers(dot)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(at)postgresql(dot)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 ?
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alcívar Arcos 2013-01-03 16:24:17 Migración
Previous Message Campbell, Lance 2013-01-03 15:17:26 How to view full queries not partial queries