Re: How to startup the database server? - Mailing list pgsql-general

On 12/19/2012 06:06 AM, Jason Ma wrote:

Hi all,
    I am a freshman of PostgreSQL, My env: PG 8.4 on CentOS,I follow the
document in the offical site to startup the db server. Here's what I do
below, the database cluster is ready, but I can't start the database server.

[root@testbox ~]# service postgresql initdb
Data directory is not empty!                               [FAILED]

Well this means there already something in the data directory, most likely the result of a previous initdb.
Is that indeed the case?

[root@testbox ~]# service postgresql start
Starting postgresql service:                               [FAILED]

-bash-4.1$ postgres -D /var/lib/pgsql/data
-bash-4.1$ ps -ef |grep postgres
root      2710  2585  0 21:52 pts/1    00:00:00 su - postgres
postgres  2711  2710  0 21:52 pts/1    00:00:00 -bash
postgres  2752  2711  0 21:55 pts/1    00:00:00 ps -ef
postgres  2753  2711  0 21:55 pts/1    00:00:00 grep postgres

-bash-4.1$ postgres -D /var/lib/pgsql/data > binlog 2>&1 &
-bash-4.1$ ps -ef |grep postgres
root      2710  2585  0 21:52 pts/1    00:00:00 su - postgres
postgres  2711  2710  0 21:52 pts/1    00:00:00 -bash
postgres  2768  2711  1 21:59 pts/1    00:00:00 ps -ef
postgres  2769  2711  0 21:59 pts/1    00:00:00 grep postgres

I wonder why I can't start the database? Do I have some place to see the
log file. Hope anybody can help me. Thanks.

I do not use CentOS/RH so I am of limited use here. For some pointers see:

http://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux

From there the log would seem to be in /var/lib/pgsql

--
Best wishes,

Jason Ma

--
Adrian Klaver
adrian.klaver@gmail.com