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