Обсуждение: "pg_ctl restart" in 7.1.2

"pg_ctl restart" seems to not work as documented in postgresql 7.1.2.

bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast
waiting for postmaster to shut down......done
postmaster successfully shut down
/usr/bin/postmaster: invalid argument -- '-D'
Try '/usr/bin/postmaster --help' for more information.
waiting for postmaster to
start................................................................failed
pg_ctl: postmaster does not start
bash-2.04$

(it was ctrl-C'ed after taking forever in "start...")

The documentation says this is a valid combination, or am I missing something?

[root@xyzzy2 data]# pg_ctl --help
pg_ctl is a utility to start, stop, restart, and report the status
of a PostgreSQL server.

Usage:
  pg_ctl start   [-w] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]
  pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
  pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o "OPTIONS"]
  pg_ctl status  [-D DATADIR]

Common options:
  -D DATADIR            Location of the database storage area
  -s                    Only print errors, no informational messages
  -w                    Wait until operation completes
  -W                    Do not wait until operation completes
(The default is to wait for shutdown, but not for start or restart.)

If the -D option is omitted, the environment variable PGDATA is used.

Options for start or restart:
  -l FILENAME           Write (or append) server log to FILENAME.  The
                        use of this option is highly recommended.
  -o OPTIONS            Command line options to pass to the postmaster
                        (PostgreSQL server executable)
  -p PATH-TO-POSTMASTER Normally not necessary

Options for stop or restart:
  -m SHUTDOWN-MODE      May be 'smart', 'fast', or 'immediate'

Shutdown modes are:
  smart                 Quit after all clients have disconnected
  fast                  Quit directly, with proper shutdown
  immediate             Quit without complete shutdown; will lead
                        to recovery run on restart

Report bugs to <pgsql-bugs@postgresql.org>.
[root@xyzzy2 data]#
--
Trond Eivind Glomsrød
Red Hat, Inc.

Trond Eivind Glomsrød writes:

> "pg_ctl restart" seems to not work as documented in postgresql 7.1.2.
>
> bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast
> waiting for postmaster to shut down......done
> postmaster successfully shut down
> /usr/bin/postmaster: invalid argument -- '-D'
> Try '/usr/bin/postmaster --help' for more information.
> waiting for postmaster to
> start................................................................failed
> pg_ctl: postmaster does not start
> bash-2.04$

There was a bug related to this fixed in 7.1.2.  I think you are trying to
restart with 7.1.2 pg_ctl an installation that was initially started with
7.1.1 or earlier, or vice versa.  I guess that doesn't work.  :-(

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Peter Eisentraut <peter_e@gmx.net> writes:

> Trond Eivind Glomsrød writes:
>
> > "pg_ctl restart" seems to not work as documented in postgresql 7.1.2.
> >
> > bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast
> > waiting for postmaster to shut down......done
> > postmaster successfully shut down
> > /usr/bin/postmaster: invalid argument -- '-D'
> > Try '/usr/bin/postmaster --help' for more information.
> > waiting for postmaster to
> > start................................................................failed
> > pg_ctl: postmaster does not start
> > bash-2.04$
>
> There was a bug related to this fixed in 7.1.2.  I think you are trying to
> restart with 7.1.2 pg_ctl an installation that was initially started with
> 7.1.1 or earlier, or vice versa.  I guess that doesn't work.  :-(

No, this is 7.1.2 fresh install. I'm working with the initscripts in
the rpm dist to make it work with locales properly, as the current 7.1
way of setting "C" gives invalid results for Norwegian and others.

--
Trond Eivind Glomsrød
Red Hat, Inc.