循序渐进PostgreSQL:实现PostgreSQL自启动
在手动安装（针对源码编译PG或者是解压缩版安装PG的情形）情况下，PG并不是在开机的情况下自动启动，在关机的情况下自动停止，作为DBA人员来说，显然这样的情形是无法接受的。
www.zzzyk.com
1. windows下的服务自启动
在Windows下， 可以使用pg_ctl命令生成PostgreSQL服务，并让它自启动。实际上，安装版本也是这么做的。 我们不妨看看pg_ctl命令的详细帮助先：
D:\pg921>pg_ctl --help
pg_ctl is a utility to initialize, start, stop, or control a PostgreSQL server.
Usage:
pg_ctl init[db] [-D DATADIR] [-s] [-o "OPTIONS"]
pg_ctl start [-w] [-t SECS] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]
pg_ctl stop [-W] [-t SECS] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
pg_ctl restart [-w] [-t SECS] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
[-o "OPTIONS"]
pg_ctl reload [-D DATADIR] [-s]
pg_ctl status [-D DATADIR]
pg_ctl promote [-D DATADIR] [-s]
pg_ctl kill SIGNALNAME PID
<strong> pg_ctl register [-N SERVICENAME] [-U USERNAME] [-P PASSWORD] [-D DATADIR]
[-S START-TYPE] [-w] [-t SECS] [-o "OPTIONS"]
pg_ctl unregister [-N SERVICENAME]</strong>
Common options:
-D, --pgdata=DATADIR location of the database storage area
-s, --silent only print errors, no informational messages
-t, --timeout=SECS seconds to wait when using -w option
-V, --version output version information, then exit
-w wait until operation completes
-W do not wait until operation completes
-?, --help show this help, 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:
-c, --core-files not applicable on this platform
-l, --log=FILENAME write (or append) server log to FILENAME
-o OPTIONS command line options to pass to postgres
(PostgreSQL server executable) or initdb
-p PATH-TO-POSTGRES normally not necessary
Options for stop or restart:
-m, --mode=MODE MODE can 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
Allowed signal names for kill:
ABRT HUP INT QUIT TERM USR1 USR2
Options for register and unregister:
-N SERVICENAME service name with which to register PostgreSQL server
-P PASSWORD password of account to register PostgreSQL server
-U USERNAME user name of account to register PostgreSQL server
-S START-TYPE service start type to register PostgreSQL server
Start types are:
auto start service automatically during system startup (default)
demand start service on demand
Report bugs to <pgsql-bugs@postgresql.org>.
从上边可以看出，pg_ctl register用于生成服务，而pg_ctl unregister -N <服务名>用于删除一个服务。
如：
D:\pg921>pg_ctl register -N pg921 -D d:\pg921\data -S auto -w -t 10 -l d:/pg921/log/pg921.log -o "-p 5433"
此命令，即是要生成一个服务：pg921, 启动方式： -S auto, 自启动，如果想生成手动启动，就用-S demand来指定。
-t 10，意指等待10秒钟, 实际上可以设定的长一些(在生产环境中).
-l d:/pg921/log/pg921.log， 指定生成的日志文件的位置。
-o "-p 5433", 将服务端口号改为5433。
验证一下上述命令生成的效果：
D:\pg921>net start pg921
The pg921 service is starting.
The pg921 service was started successfully.
D:\pg921>psql -p 5433 iihero
psql (9.2.1)
Type "help" for help.
iihero=# \q
2. Linux下的服务自启动
在Linux下，我们需要写一个自启动的脚本，至少支持两个命令选项： start 和 stop，并将这个脚本建立适当的链接。我们就以Ubuntu10为例，
先看看系统有没有chkconfig命令工具： www.zzzyk.com
xionghe@seanlinux2:~$ chkconfig
程序“chkconfig”尚未安装。 您可以使用以下命令安装：
sudo apt-get install chkconfig
xionghe@seanlinux2:~$ sudo apt-get install chkconfig
脚本内容如下： 放入目录/etc/init.d目录下边
#! /bin/sh
# Installation prefix
prefix=/home/xionghe/pgsql
# Data directory
PGDATA="/home/xionghe/pgsql/data"
# Who to run the postmaster as, usually "postgres". (NOT "root")
PGUSER=xionghe
# Where to keep a log file
PGLOG="$PGDATA/serverlog"
# It's often a good idea to protect the postmaster from being killed by the
# OOM killer (which will tend to preferentially kill the postmaster because
# of the way it accounts for shared memory). Setting the OOM_ADJ value to
# -17 will disable OOM kill altogether. If you enable this, you probably want
# to compile PostgreSQL with "-DLINUX_OOM_ADJ=0", so that individual backends
# can still be killed by the OOM killer.
#OOM_ADJ=-17
## STOP EDITING HERE
# The path that is to be used for the script
PATH=/home/xionghe/pgsql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
