Re: Help, How to start the server?? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Help, How to start the server??
Date
Msg-id 519F74A1.4010302@iol.ie
Whole thread Raw
In response to Help, How to start the server??  (YuChi <tp6m4fu6250071@yahoo.com.tw>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Help, How to start the server??
Next
From: Chris Angelico
Date:
Subject: Re: Success stories of PostgreSQL implementations in different companies