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