Re: Archiving

Got it, thank you!

On 1/25/2013 5:14 PM, Prashanth Ranjalkar wrote:
> Hello,
> //The pg_xlog partition start accumulating WALs and archive_status
> directory will shows .ready status when WAL partition gets 100% full
> or NFS is not available. Once pg_xlogs also fills to 100%, database
> will shutdown till the issue get resolved.
> /*Thanks & Regards,*/
> //**
> /*Prashanth Ranjalkar*/
> /*Database Consultant & Architect*/
> /*Email:prashant(dot)ranjalkar(at)gmail(dot)com*
> <mailto:Email%3Aprashant(dot)ranjalkar(at)gmail(dot)com>/
> /*Skype:prashanth.ranjalkar*/
> /*Cell: +91 932 568 2271*/
>
>
> On Fri, Jan 25, 2013 at 8:31 PM, Viktor <viktor(at)okservers(dot)eu
> <mailto:viktor(at)okservers(dot)eu>> wrote:
>
> Hello,
>
> I have "archive_mode = on" in my configuration and wals are sent
> via NFS to another server.
>
> Could you please explain what will happen if the partition where
> are wals kept gets full or the NFS server goes down ? Can it
> cause the database disfunction ?
>
> Command is:
>
> archive_command = 'test ! -f /mnt/wal/current/%f && cp %p
> /mnt/wal/current/%f'
>
>
>
> --
> Best regards.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org
> <mailto:pgsql-admin(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>