Search Postgresql Archives

Re: How to startup the database server?

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

 



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

Seems the database cluster was initialized. Sort of concerned by the runuser error. What user did you run the initdb as?



I tried this:

-bash-4.1$ /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
server starting

Nothing in the logfile?


-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.

I am not seeing the server running in the above. You might want to retry the ps with post as the grep _expression_.


Regards,
Jason



--
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