From: Al-Salami, Adel <saa@klinkhammer.com>
To: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Warm standby Service doesn't startup
Date: Tue, 6 Sep 2011 15:25:54 +0200
Message-ID: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD117F@w2k8n202> (raw)
In-Reply-To: <1315312833.30560.87.camel@lenovo01-laptop03.gunduz.org>
References: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202>
<1315312833.30560.87.camel@lenovo01-laptop03.gunduz.org>
Thanks alot.
-----Ursprüngliche Nachricht-----
Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von Devrim GÜNDÜZ
Gesendet: Dienstag, 6. September 2011 14:40
An: Al-Salami, Adel
Cc: pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] Warm standby Service doesn't startup
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
A. Klinkhammer Förderanlagen Kreative Lager- und Produktionslogistik GmbH
Sitz der Gesellschaft: Nürnberg • Registergericht: Amtsgericht Nürnberg, HRB 15958
Geschäftsführer: Frank Klinkhammer, Gerald Schulz
USt ID: DE 198 660 907 • Steuer Nr.: 241/115/83087
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: saa@klinkhammer.com, devrim@gunduz.org
Subject: Re: Warm standby Service doesn't startup
In-Reply-To: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD117F@w2k8n202>
References: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202> <1315312833.30560.87.camel@lenovo01-laptop03.gunduz.org> <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD117F@w2k8n202>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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