linux postgres服务重启,linux postgresql无法启动（解决）

本帖最后由 dwm123 于 2010-12-10 16:20 编辑

* /data 作为postgresql的安装目录

# chown postgres:postgres /data

# su - postgres

* PGDATA 环境变更

$ vi ~/.bash_profile

PGDATA=/data

export PGDATA

$ source ~/.bash_profile

$ initdb --encoding=UTF-8 --no-locale -D /data

$ mkdir /data/archive

postgresql.conf

# vi /data/postgresql.conf  默认值

pg_hba.conf

LAN(192.168.11.0/24 )

# vi /data/pg_hba.conf

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

host    all         all         192.168.11.0/24       password

↑

# vi /etc/init.d/postgresql

PGDATA=/data

PGLOG=/data/pgstartup.log

# /etc/init.d/postgresql start

postgresql                               [  OK  ]

－－－－－－－－－

以上启动没有问题，

但是我现在想把数据存放的位置换一下， 放到 /DB_data里面

mkdir -p /DB_data

chown postgres:postgres /DB_data

service postgresql stop

mv -f /data /DB_data

ln -s /DB_data  /data

service postgresql stop

停止 postgresql 服务：                                     [失败]

不知道什么原因，看了看/var/log/messages 没有没有error

[root@linux-server data]# cd pg_log/

[root@linux-server pg_log]# ls

postgresql-Fri.log  postgresql-Thu.log

[root@linux-server pg_log]# cat postgresql-Fri.log

LOG:  database system was shut down at 2010-12-09 15:57:48 CST

LOG:  autovacuum launcher started

LOG:  database system is ready to accept connections

LOG:  received fast shutdown request

LOG:  aborting any active transactions

LOG:  autovacuum launcher shutting down

LOG:  shutting down

LOG:  database system is shut down

[root@linux-server pg_log]# cat postgresql-Thu.log

LOG:  database system was shut down at 2010-12-09 13:51:11 CST

LOG:  autovacuum launcher started

LOG:  database system is ready to accept connections

LOG:  received fast shutdown request

LOG:  aborting any active transactions

LOG:  autovacuum launcher shutting down

LOG:  shutting down

LOG:  database system is shut down

LOG:  database system was shut down at 2010-12-09 14:40:22 CST

LOG:  autovacuum launcher started

LOG:  database system is ready to accept connections

LOG:  received fast shutdown request

LOG:  aborting any active transactions

LOG:  autovacuum launcher shutting down

LOG:  shutting down

LOG:  database system is shut down

也没有设么错误信息

我记得mysql 所可以的，

mv -f /var/lib/mysql /drbddata/mysql_data

ln -s /drbddata/mysql_data  /var/lib/mysql

所可以启动mysql的

lrwxrwxrwx   1 root     root            13 12-10 08:26 data -> /DB_data/data

下午就自动好了，其实我只所在原来的上面，改变了一下目录，建立了一个软连接而已，

现在可以在root帐号下，启动postgresql了