Steve Clark <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] "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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to