pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Al-Salami, Adel <saa@klinkhammer.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Warm standby Service doesn't startup
Date: Tue, 6 Sep 2011 14:12:07 +0200
Message-ID: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202> (raw)



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.

view thread (3+ messages)  latest in thread

Message-ID: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202>
Permalink:  ../A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202/
Also on:    postgresql.org/message-id/A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202

 · 

reply

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
  Subject: Re: Warm standby Service doesn't startup
  In-Reply-To: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@w2k8n202>
  References: <A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1172@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