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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general