Re: [ADMIN] Postgres service won't start, doesn't log any errors

2010-10-19 Thread Joe Carr
Hi Thomas, Thanks for your reply. pg_ctrl has given me some more information, but I'm not quite there yet. I have verified that the postgres user has "full control" access to the data directory. When I take the commandline from the service definition and execute it, I get the following: C:\Progr

Re: [ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

2010-10-19 Thread Isabella Ghiurea
Fujii Masao wrote: On Tue, Oct 19, 2010 at 2:48 AM, Isabella Ghiurea wrote: I have some questions regarding hot standby + streaming replication (PG 9.0) : what is master/primary server behavior if archive_command fails due to archive directory off line/unavailable? Unarchived

Re: [ADMIN] WAL log shipping + Streaming replication PG 9.0 questions

2010-10-19 Thread Fujii Masao
On Tue, Oct 19, 2010 at 11:46 PM, Isabella Ghiurea wrote: > For the last question I ' m still a bit confused: if master_archive off line > ( no archived WAL's available) what will be state of  standby server ? > Basically we are trying to design a solution where WAL archived directory is > not a "