[GENERAL] 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Help, How to start the server??
2013/5/24 YuChi : > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Help, How to start the server??
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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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 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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Help, How to start the server??
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general