Re: Help, How to start the server??

On 24/05/2013 08:35, YuChi wrote:
> i use postgresql-9.2.4 install on ubuntu11.04(natty)
> and i use the command:
>
> *postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data*
>
> or use
>
> *postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D
> /usr/local/pgsql/data*
>
> to start the server
> but it's stopping at the message:
>
> *LOG:  database system was shut down at 2013-05-24 15:07:34 CST
> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started*
>
> for a long time
> it seems never continue again
> and i don't know how to do next...
> can anyone tell me is there anything wrong? or how to do next?

It's just waiting for connections. Try opening a different console
window, and connect to it from there:

  psql -U <my user> <database name>

However, you probably want it to run as a daemon; I don't know about
Ubuntu, but on debian it's set up for you already, if you install using
apt-get:

  /etc/init.d/postgresql start

In fact, it's probably already running after being installed:

  ps ax | grep postgres

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie