Обсуждение: Error in installation...
Hi.. I've this problem in installation...I installed the postgresql-8.3 version without the service...Then to initialize I gave the command initdb -D path\ in the command prompt...It showed some notifications and it finally said to start the database server I needed to enter the command C:\Program Files\PostgreSQL\8.3\bin> postgres -D C:\path\to\pgsqldata when I entered the command I got the following notification.. LOG: database system was shut down at 2008-11-02 18:17:13 IST LOG: database system is ready to accept connections LOG: autovacuum launcher started After this nothing happens..The command prompt does not appear..As if the cursor is waiting for some input or something like that.. Please let me know if I missed something in installation process..What might be the problem ???
On 02/11/2008 19:15, Shashank Mujumdar wrote: > C:\Program Files\PostgreSQL\8.3\bin> postgres -D C:\path\to\pgsqldata > > when I entered the command I got the following notification.. > > LOG: database system was shut down at 2008-11-02 18:17:13 IST > LOG: database system is ready to accept connections > LOG: autovacuum launcher started > > After this nothing happens..The command prompt does not appear..As if > the cursor is waiting for some input or something like that.. > Please let me know if I missed something in installation process..What > might be the problem ??? That's all fine - what you've done is to start the database server process, which is listening for connections on port 5432 (if you accepted the default). Nothing else will happen in that window until you or someone else connects to this process. Open another terminal window, and connect to it with psql: C:\Program Files\PostgreSQL\8.3\bin\psql -U postgres postgres This will connect you to the database "postgres" as user "postgres". You'll probably see some more logging stuff appear in the original window, depending on how high your logging levels are set. HTH, Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On 02/11/2008 19:15, Shashank Mujumdar wrote: > After this nothing happens..The command prompt does not appear..As if > the cursor is waiting for some input or something like that.. > Please let me know if I missed something in installation process..What > might be the problem ??? I meant to add that you're not seeing a command prompt coming back because Windows does not have an "execute in the background" command like Linux, etc. - so the postgres process will continue to run in the window from which you started it until you tell it to stop by pressing Ctrl-C or some such. You'll get your command prompt back then. If you're going to be running PG a lot on this machine, or running it on a production server, the better way really is to install it as a service, so that it can continue to run even when nobody is logged in. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------