From: Viktor <viktor@okservers.eu>
To: Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Archiving
Date: Fri, 25 Jan 2013 17:16:35 +0200
Message-ID: <5102A1D3.6090104@okservers.eu> (raw)
In-Reply-To: <CAMBytESo+i1P9Mov4h7w5rda3d5faAQftSkMVzW-Ym=RkjpzYg@mail.gmail.com>
References: <51029E3C.4040504@okservers.eu>
<CAMBytESo+i1P9Mov4h7w5rda3d5faAQftSkMVzW-Ym=RkjpzYg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.ranjalkar@gmail.com*
> <mailto:Email%3Aprashant.ranjalkar@gmail.com>/
> /*Skype:prashanth.ranjalkar*/
> /*Cell: +91 932 568 2271*/
>
>
> On Fri, Jan 25, 2013 at 8:31 PM, Viktor <viktor@okservers.eu
> <mailto: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
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: viktor@okservers.eu, prashant.ranjalkar@gmail.com
Subject: Re: Archiving
In-Reply-To: <5102A1D3.6090104@okservers.eu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox