From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | "Al-Salami, Adel" <saa(at)klinkhammer(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Warm standby Service doesn't startup |
Date: | 2011-09-06 12:40:17 |
Message-ID: | 1315312833.30560.87.camel@lenovo01-laptop03.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 2011-09-06 at 14:12 +0200, Al-Salami, Adel wrote:
> I have created a warm standby successfully, everything work fine also
> the applying of the archive from primary, my problem is that the
> Service under windows 2008r2 doesn't start if the standby is running
> (I get a start service timeout).
> If I use the pg_ctl start -D D:\<my data> it will succeed however the
> windows service wont start.
> Using the net start to the start the service will hang and the log
> file keeps on writing;
>
> 2011-09-06 13:52:57 CEST FATAL: the database system is starting up
>
> Is it normal that the Warm Standby doesn't let the service to start
> under windows?
> Am not sure to go live with this standby as I cannot start the
> service.
*Warm* standby servers don't accept connections / queries, so the
message above is quite ok. If you move to PostgreSQL 9.0+, there is "hot
standby" option, which lets you run read-only queries on standby server.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
From | Date | Subject | |
---|---|---|---|
Next Message | Al-Salami, Adel | 2011-09-06 13:25:54 | Re: Warm standby Service doesn't startup |
Previous Message | Al-Salami, Adel | 2011-09-06 12:12:07 | Warm standby Service doesn't startup |