Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tyl1R-0002tx-I6 for pgsql-admin@arkaria.postgresql.org; Fri, 25 Jan 2013 15:16:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tyl1R-0007YV-1O for pgsql-admin@arkaria.postgresql.org; Fri, 25 Jan 2013 15:16:53 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tyl1P-0007Xp-Ie for pgsql-admin@postgresql.org; Fri, 25 Jan 2013 15:16:51 +0000 Received: from a10.virtuaal.com ([195.222.15.97]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tyl1N-0002nw-Ec for pgsql-admin@postgresql.org; Fri, 25 Jan 2013 15:16:50 +0000 Received: from [195.222.11.180] (port=52398 helo=[10.0.1.204]) by a10.virtuaal.com with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.80) (envelope-from ) id 1Tyl1I-002Qnd-JX; Fri, 25 Jan 2013 17:16:44 +0200 Message-ID: <5102A1D3.6090104@okservers.eu> Date: Fri, 25 Jan 2013 17:16:35 +0200 From: Viktor User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130107 Thunderbird/17.0.2 MIME-Version: 1.0 To: Prashanth Ranjalkar CC: "pgsql-admin@postgresql.org" Subject: Re: Archiving References: <51029E3C.4040504@okservers.eu> In-Reply-To: Content-Type: multipart/alternative; boundary="------------050701020406050600050803" X-Virtuaalcom-MailScanner-Information: Please contact the ISP for more information X-Virtuaalcom-MailScanner-ID: 1Tyl1I-002Qnd-JX X-Virtuaalcom-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-Virtuaalcom-MailScanner-SpamCheck: X-Virtuaalcom-MailScanner-From: viktor@okservers.eu X-Spam-Status: No X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a10.virtuaal.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - okservers.eu X-Get-Message-Sender-Via: a10.virtuaal.com: authenticated_id: viktor@okservers.eu X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------050701020406050600050803 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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* > / > /*Skype:prashanth.ranjalkar*/ > /*Cell: +91 932 568 2271*/ > > > On Fri, Jan 25, 2013 at 8:31 PM, Viktor > 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 > > --------------050701020406050600050803 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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


--------------050701020406050600050803--