Re: Archiving

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux