Thread: "pg_ctl promote" exit status

"pg_ctl promote" exit status

From
Dhruv Ahuja
Date:
Hello

The "pg_ctl promote" command returns an exit code of 1 when the server
is not in standby mode, and the same exit code of 1 when the server
isn't started at all. The only difference at the time being is the
string output at the time, which FYI are...

pg_ctl: cannot promote server; server is not in standby mode

...and...

pg_ctl: PID file "/var/lib/pgsql/9.1/data/postmaster.pid" does not exist
Is server running?

...respectively.

I am in the process of developing a clustering solution around luci
and rgmanager (in Red Hat EL 6) and for the time being, am basing it
off the string output. Maybe each different exit reason should have a
unique exit code, whatever my logic and approach to solving this
problem be?


Thanks
Dhruv


Re: "pg_ctl promote" exit status

From
Robert Haas
Date:
On Wed, Oct 17, 2012 at 5:33 AM, Dhruv Ahuja <dhruvahuja@gmail.com> wrote:
> Hello
>
> The "pg_ctl promote" command returns an exit code of 1 when the server
> is not in standby mode, and the same exit code of 1 when the server
> isn't started at all. The only difference at the time being is the
> string output at the time, which FYI are...
>
> pg_ctl: cannot promote server; server is not in standby mode
>
> ...and...
>
> pg_ctl: PID file "/var/lib/pgsql/9.1/data/postmaster.pid" does not exist
> Is server running?
>
> ...respectively.
>
> I am in the process of developing a clustering solution around luci
> and rgmanager (in Red Hat EL 6) and for the time being, am basing it
> off the string output. Maybe each different exit reason should have a
> unique exit code, whatever my logic and approach to solving this
> problem be?

I suggest reposting this on pgsql-hackers.  This mailing list is mostly dead.[1]

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

[1] with apologies to S. Morgenstern