Search Postgresql Archives

Re: How to startup the database server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:
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@xxxxxxxxx



--
Best wishes,

Jason Ma

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux