Re: pg_ctl won't start postgres, but postmaster will?! - Mailing list pgsql-admin

From Steve Santacroce
Subject Re: pg_ctl won't start postgres, but postmaster will?!
Date
Msg-id 001101c36b4d$cb8fab30$b20c2541@lister
Whole thread Raw
In response to Re: pg_ctl won't start postgres, but postmaster will?!  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: pg_ctl won't start postgres, but postmaster will?!  (Yuji Shinozaki <ys2n@virginia.edu>)
List pgsql-admin
> >     chmod 600 ${logfile}
> >     chown pgsql:pgsql ${logfile}
> >     [ -x ${PGBIN}/pg_ctl ] && {
> >         su -l pgsql -c \
> >             "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl
start -s -w -l
> > ${logfile}"
> >         echo -n ' pgsql'
> >
> > No errors, no messages, nothing. Then I tried to start pg_ctl by hand. I
> > su'd to pgsql, and typed:
> >
> > /usr/local/bin/pg_ctl -D /pgdata -l /var/log/pgsql
>
> This command is invalid.  You need to add "start" somewhere.
>
Sorry, forgot to write that. It was in the line. The wierd thing is that I
can type:
/usr/local/bin/pg_ctl -D /pgdata -l /var/log/pgsql start

and it will start, but if I use:

su -l pgsql -c exec "/usr/local/bin/pg_ctl -D /pgdata -l /var/log/pgsql
start"

it doesn't work! And I'm still confused as to why the script doesn't work.

> The message "postmaster started successfully" comes from pg_ctl.  That
> would mean pg_ctl is still running by the time you type this.
>
> Please check that what you are writing here corresponds exactly to what
> you are typing on the console.
>

Sorry about that. I should have just copied and pasted. Thanks for pointing
out my error!


pgsql-admin by date:

Previous
From: Chris Miles
Date:
Subject: postgresql and replication
Next
From: Chris Miles
Date:
Subject: Re: Automated backup problems - pg_dump