From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Steve Clark <sclark(at)netwolves(dot)com> |
Cc: | Hal Black <black(at)ieee(dot)org>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4435: pg_ctl start doesn't detach when run via SSH |
Date: | 2008-09-24 03:16:44 |
Message-ID: | 17905.1222226204@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Steve Clark <sclark(at)netwolves(dot)com> writes:
> Hal Black wrote:
>> When I run "pg_ctl start" via SSH, the database service starts, but it never
>> returns control to the shell. If I run the same command from an interactive
>> 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 -D
>> /home/appuser/postgresql_data' postgres"
> try using ssh -t ...
Actually I suspect the main problem is having failed to redirect the
postmaster's stdout/stderr away from the terminal. Consider using
pg_ctl's "-l logfile" option.
Another point is that su's -l option might be a good idea. I'm
unconvinced that you're setting up a desirable environment for the
postmaster here --- it's going to be mostly root's environment.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-09-24 04:38:49 | Re: BUG #4434: Error inserting into view - unrecognized node type: 313 |
Previous Message | Tom Lane | 2008-09-24 02:36:09 | Re: [HACKERS] 0x1A in control file on Windows |