Обсуждение: Archiving

Поиск
Список
Период
Сортировка

Archiving

От
Viktor
Дата:
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.

Re: Archiving

От
Viktor
Дата:
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@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