pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedArchiving
2+ messages / 1 participants
[nested] [flat]
* Archiving
@ 2013-01-25 15:01 Viktor <viktor@okservers.eu>
0 siblings, 1 reply; 2+ messages in thread
From: Viktor @ 2013-01-25 15:01 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Archiving
@ 2013-01-25 15:16 Viktor <viktor@okservers.eu>
parent: Viktor <viktor@okservers.eu>
0 siblings, 0 replies; 2+ messages in thread
From: Viktor @ 2013-01-25 15:16 UTC (permalink / raw)
To: Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>; +Cc: pgsql-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
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-01-25 15:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-25 15:01 Archiving Viktor <viktor@okservers.eu>
2013-01-25 15:16 ` Viktor <viktor@okservers.eu>
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