Thanks, adrian, but I have check the pgstartup.log, I got the following messages:
.....
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
Success. You can now start the database server using:
/usr/bin/postgres -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
runuser: cannot set groups: Operation not permitted
I tried this:
-bash-4.1$ /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
server starting
-bash-4.1$ ps -ef |grep postgres
root 2904 2585 0 22:59 pts/1 00:00:00 su - postgres
postgres 2905 2904 0 22:59 pts/1 00:00:00 -bash
postgres 2946 2905 7 23:00 pts/1 00:00:00 ps -ef
postgres 2947 2905 0 23:00 pts/1 00:00:00 grep postgres
It reported that I have started the server but that doesn't work, I think there must be somebody has the same problem with me. Any suggestions.
Regards,
Jason
2012/12/19 Adrian Klaver <adrian.klaver@xxxxxxxxx>
On 12/19/2012 06:06 AM, Jason Ma wrote:Well this means there already something in the data directory, most likely the result of a previous initdb.
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]
Is that indeed the case?I do not use CentOS/RH so I am of limited use here. For some pointers see:
[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.
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@xxxxxxxxx
Best wishes,
Jason Ma
