Thread: Help, How to start the server??
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? thank you -- View this message in context: http://postgresql.1045698.n5.nabble.com/Help-How-to-start-the-server-tp5756725.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
2013/5/24 YuChi <tp6m4fu6250071@yahoo.com.tw>: > 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? That's perfectly normal log output after a server start. Have you tried connecting with psql? Ian Barwick
On 05/24/2013 12:35 AM, 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 The above is the previous shut down. > LOG: database system is ready to accept connections > LOG: autovacuum launcher started* The database is now up. > > 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? Start a client connection to test. > > thank you > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Help-How-to-start-the-server-tp5756725.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- Adrian Klaver adrian.klaver@gmail.com
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
wooo, thanks for all of your advice it seems to be ok now! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Help-How-to-start-the-server-tp5756725p5757271.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.