Re: [GENERAL] Monitoring streaming replication from standby on Windows

2012-12-14 Thread Yamen LA
] Monitoring streaming replication from standby on Windows On 12/13/2012 7:36 PM, Yamen LA wrote: Hello, I would like to know how to check the status of the streaming replication from standby server on Windows. Apparently from the

[GENERAL] Monitoring streaming replication from standby on Windows

2012-12-13 Thread Yamen LA
Hello, I would like to know how to check the status of the streaming replication from standby server on Windows. Apparently from the master I can use the pg table "pg_stat_replication". This table is, however, empty on the standby since it contains information about WAL sender processes and no

Re: [GENERAL] Deleting WAL archives and pg_xlog when there is not a shared drive

2012-12-12 Thread Yamen LA
Thanks for the input Jeff. The purpose is primarily automating failover (high-availability). There is no intention of using PITR. We decided to actually keep the WAL logs in the archive directory (until they start to pose a storage problem) and delete what's under pg_xlog (in the situation I a

Re: [GENERAL] Deleting WAL archives and pg_xlog when there is not a shared drive

2012-12-12 Thread Yamen LA
Thank you for your input. > From: gray...@gmail.com > Date: Tue, 11 Dec 2012 14:06:32 -0800 > Subject: Re: [GENERAL] Deleting WAL archives and pg_xlog when there is not a > shared drive > To: iya...@live.com > CC: pgsql-general@postgresql.org > > On Tue, Dec 11, 2012 at 9:37 AM, Eng. AlSamman