[pgsql-jp: 33481] 再度install, 起動2回成功後、 単純ミス

Yasuharu Ninomiya ninomii @ fml.nirs.go.jp
2004年 7月 2日 (金) 20:32:40 JST


単純ミスで大騒ぎし、ご迷惑をおかけしました。
すみません。

まだ、postmasterは終了していないと思われるので次のように施行してみましたが、
やはり終了しません。
ast login: Fri Jul  2 20:01:01 on ttyp1
Welcome to Darwin!
g4almi:~ ninomiya$ su -l postgresql
Password:
g4almi:~ postgresql$ export PATH=$PATH:/usr/local/pgsql
g4almi:~ postgresql$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
logfile start
pg_ctl: Another postmaster may be running.  Trying to start postmaster
anyway.
pg_ctl: cannot start postmaster
Examine the log output.
g4almi:~ postgresql$ pg_ctl stop
-su: pg_ctl: command not found
g4almi:~ postgresql$ Pg_ctl stop -W -m fast
-su: Pg_ctl: command not found
g4almi:~ postgresql$

pg_ctlのoptionは下記の記載からすると
Pg_ctl stop -W -m fast
でいいと思いますが、間違えているのでしょうか。
g4almi:~ postgresql$ pg_ctl --help
pg_ctl is a utility to start, stop, restart, reload configuration files,
or 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 reload  [-D DATADIR] [-s]
  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
  --help       show this help, then exit
  --version    output version information, then exit
(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 on
restart

directoryは
.bashrcに
PATH=$PATH:/usr/local/pgsql/bin
POSTGRES_HOME=/usr/local/pgsql
PGLIB=$POSTGRES_HOME/lib
PGDATA=$POSTGRES_HOME/data
MANPATH="$MANPATH":$POSTGRES_HOME/man
LD_LIBRARY_PATH="$LD_LIBRARY_PATH":"$PGLIB"
と書いてあるので問題ないと思うのですが。

一応、念の為、一度やったので、毎回施行しなくよいと思われる
g4almi:~ postgresql$  source ~/.bashrc
を施行してもう一度やってみました。
g4almi:~ postgresql$  source ~/.bashrc
g4almi:~ postgresql$ usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
logfile start
-su: usr/local/pgsql/bin/pg_ctl: No such file or directory
g4almi:~ postgresql$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
logfile start
pg_ctl: Another postmaster may be running.  Trying to start postmaster
anyway.
pg_ctl: cannot start postmaster
Examine the log output.
g4almi:~ postgresql$ pg_ctl stop
pg_ctl: no database directory specified and environment variable PGDATA
unset
Try "pg_ctl --help" for more information.
g4almi:~ postgresql$ pg_ctl stop -W -m fast
pg_ctl: no database directory specified and environment variable PGDATA
unset
Try "pg_ctl --help" for more information.
g4almi:~ postgresql$

.bashrcのPGDATAのdirectoryは認識されてないのでしょうか?

何かお気づきの点がございましたらお教え頂けないでしょうか。

二宮




pgsql-jp メーリングリストの案内