CentOS 6.5에서 Postgres를 어떻게 시작합니까?

CentOS 6.5에서 Postgres를 어떻게 시작합니까?

Postgres를 시작하려고 할 때마다 오류가 발생합니다. 문제가 있는 디렉토리를 제거하더라도 여전히 실패합니다.

[root@ip-172-31-15-65 init.d]# service postgresql start

/var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.
                                                           [FAILED]
[root@ip-172-31-15-65 init.d]# service postgresql initdb
Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
                                                           [FAILED]
[root@ip-172-31-15-65 init.d]# rmdir /var/lib/pgsql/data/pg_log
[root@ip-172-31-15-65 init.d]# service postgresql start

/var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.
                                                           [FAILED]
[root@ip-172-31-15-65 init.d]# service postgresql initdb
Initializing database:                                     [FAILED]

[root@ip-172-31-15-65 init.d]# service postgresql initdb
Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
                                                           [FAILED]

버전: postgresql-server-8.4.20-1.el6_5.x86_64

답변1

이것은 효과가 있었습니다.

rpm -Uvh http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

yum install postgresql93-server postgresql93-contrib
service postgresql-9.3 initdb

/etc/init.d/postgresql-9.3 start
chkconfig postgresql-9.3 on

이것은 또한 작동할 수 있습니다:

yum install pgdg-centos93.noarch # in place of rpm
service postgres-9.3 start # in place of init.d

관련 정보