Re: pg_upgrade

Maybe this is it. 8.4 pg_ctl docs say it uses "psql -l" to see if it's
finished when you use -w. It also says

PGPORT

Default port for
psql<http://www.postgresql.org/docs/8.4/static/app-psql.html>(used by
the -w option).
And since pg_upgrade uses a funky port, it might miss unless the PGPORT
environment variable is set to match.

I'll try that tonight.

On Fri, Feb 15, 2013 at 10:09 AM, Ian Harding <harding(dot)ian(at)gmail(dot)com> wrote:

> This is interesting, although I'm not sure it's relevant. From pg_ctl
> source.
>
>
> 00477 write_stderr<http://doxygen.postgresql.org/bin_2psql_2common_8c.html#aeca3eef79cc2b37affc8d760c33e1de8>
> (_<http://doxygen.postgresql.org/elog_8c.html#af20b8d139279b360b0fdeae71f8f43bc>
> ("\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(dot)ian(at)gmail(dot)com>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(dot)janes(at)gmail(dot)com> wrote:
>>
>>> On Fri, Feb 15, 2013 at 4:54 AM, Ian Harding <harding(dot)ian(at)gmail(dot)com>
>>> 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
>>>
>>
>>
>