That works, but interestingly, I still get a SIGHUP reload sometimes:
LOG: received SIGHUP, reloading configuration files
On Tue, Sep 23, 2008 at 1:54 PM, Steve Clark <sclark(at)netwolves(dot)com> wrote:
> Hal Black wrote:
>> The following bug has been logged online:
>> Bug reference: 4435
>> Logged by: Hal Black
>> Email address: black(at)ieee(dot)org
>> PostgreSQL version: 8.3.3
>> Operating system: Ubuntu Hardy 8.04.1 LTS
>> Description: pg_ctl start doesn't detach when run via SSH
>> When I run "pg_ctl start" via SSH, the database service starts, but it
>> returns control to the shell. If I run the same command from an
>> shell, it works as expected.
>> This is with or without the -w option. Here's an example commandline.
>> ssh root(at)example(dot)com "su -c '/home/appuser/local/bin/pg_ctl start -w -s
>> /home/appuser/postgresql_data' postgres"
>> This problem exists both when installed from source and when using the
>> postgresql installed via the debian package manager (of course using a
>> different path to the pg_ctl binary)
>> try using ssh -t ...
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2008-09-23 21:24:31|
|Subject: Re: [HACKERS] 0x1A in control file on Windows|
|Previous:||From: Steve Clark||Date: 2008-09-23 17:54:07|
|Subject: Re: BUG #4435: pg_ctl start doesn't detach when run via SSH|