Hi,
The ps output is after the server start, I don't know why I can't see any process after start the server. And of course I use root to initial db, 'cause we have to run this command in CentOS which you need the privilege of root.
service postgresql start
Regards,
Jason
2012/12/19 Adrian Klaver <adrian.klaver@xxxxxxxxx>
On 12/19/2012 07:07 AM, Jason Ma wrote:Seems the database cluster was initialized. Sort of concerned by the runuser error. What user did you run the initdb as?
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
Nothing in the logfile?
I tried this:
-bash-4.1$ /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
server starting
I am not seeing the server running in the above. You might want to retry the ps with post as the grep _expression_.
-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
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
Best wishes,
Jason Ma