Thanks alot. -----Ursprüngliche Nachricht----- Von: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] Im Auftrag von Devrim GÜNDÜZ Gesendet: Dienstag, 6. September 2011 14:40 An: Al-Salami, Adel Cc: pgsql-admin@xxxxxxxxxxxxxx Betreff: Re: 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
