Re: Archiving

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.ranjalkar@gmail.com

Skype:prashanth.ranjalkar

Cell: +91 932 568 2271

On Fri, Jan 25, 2013 at 8:31 PM, Viktor <viktor@okservers.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin