Thread: Warm standby Service doesn't startup

Warm standby Service doesn't startup

From
"Al-Salami, Adel"
Date:

 

 

Hello everybody,

 

am new to postgre, and I hope I finde som help in this mailing list.

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.

 

Any help will be highly appreciated.

 

Adel



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.

Re: Warm standby Service doesn't startup

From
Devrim GÜNDÜZ
Date:
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

Attachment

Re: Warm standby Service doesn't startup

From
"Al-Salami, Adel"
Date:

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
CertifiedEngineer
 
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
sindoder 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
receivedthis e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying,
disclosureor distribution of the material in this e-mail is strictly forbidden.