Re: pg_upgrade

[Ian Harding <harding.ian@xxxxxxxxx>]

This is interesting, although I'm not sure it's relevant.  From pg_ctl source.

 

00477                     write_stderr(_("\n%s: -w option is not supported when starting a pre-9.1 server\n"),

On Fri, Feb 15, 2013 at 9:45 AM, Ian Harding <harding.ian@xxxxxxxxx> wrote:

-----------------------------------------------------------------
  pg_upgrade run on Fri Feb 15 05:09:34 2013
-----------------------------------------------------------------

command: "/usr/lib/postgresql/8.4/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/postgresql/8.4/main/" -o "-p 50432 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000 -c listen_addresses='' -c unix_socket_permissions=0700" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start...............................................................could not start server

 

The funny thing is, the server starts instantly. 

On Fri, Feb 15, 2013 at 9:19 AM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:

On Fri, Feb 15, 2013 at 4:54 AM, Ian Harding <harding.ian@xxxxxxxxx> wrote:
> I don't think it would get any further...  It fails and --retain says
> "Retain sql and log files after success"  I can look at that log file and
> all it indicates is failure to start the server.
>
> Maybe I should rephrase the question:  pg_ctl returns failure, even though
> it starts the server, when run with the -w flag.

How long does the server take to start?

If it takes the server more than 1 minute to start, then what you
describe is expected.

Cheers,

Jeff