Re: 7.3 pg_ctl anomaly - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3 pg_ctl anomaly
Date
Msg-id 13936.1039012445@sss.pgh.pa.us
Whole thread Raw
In response to 7.3 pg_ctl anomaly  (Ed L. <pggeneral@bluepolka.net>)
List pgsql-general
"Ed L." <pggeneral@bluepolka.net> writes:
> When I run this command in 7.3,
>     pg_ctl -w -o "-p 15432" start
> it successfully starts the database, but the -w flag doesn't seem to
> notice the successful start and continues to wait until finally
> saying "postmaster does not start" and giving up.

I believe the issue is that pg_ctl doesn't understand that you're
starting the postmaster on a nonstandard port.  Its method of detecting
postmaster startup is to try to log in with psql, so if it's trying
the wrong port this is exactly what will happen.

I have not tried it, but I think it'd work to do this instead:

    export PGPORT=15432
    pg_ctl start

Making your example work as given would mean teaching the pg_ctl
script to parse postmaster options, which seems like way more
trouble than it's worth ...

            regards, tom lane

pgsql-general by date:

Previous
From: Diogo Biazus
Date:
Subject: mod_auth_pgsql
Next
From: Matthew Gabeler-Lee
Date:
Subject: Re: 7.3 no longer using indexes for LIKE queries