Re: Problem with PostgreSQL: unable to connect to database - Mailing list pgsql-cygwin

From Igor Georgiev
Subject Re: Problem with PostgreSQL: unable to connect to database
Date
Msg-id 001801c2c2c1$40d9fde0$0b0546c0@alpha.bg
Whole thread Raw
In response to Problem with PostgreSQL: unable to connect to database  ("Cheah Ai Meng" <aimeng.cheah@nus.edu.sg>)
List pgsql-cygwin
 
I'm having problems in connecting my PostgreSQL database to the server.  I’m using PostgreSQL 7.3 and pgAdmin II 1.4.  This is the situation:

 

1.  At the Cygwin window,

           

eng91066@ENG91066 ~

$ initdb -D /usr/local/pgsql/data

The files belonging to this database system will be owned by user "eng91066".

This user must also own the server process.

 

The database cluster will be initialized with locale C.

 

initdb: The directory /usr/local/pgsql/data exists but is not empty.

If you want to create a new database system, either remove or empty the directory /usr/local/pgsql/data or run initdb with an argument other than /usr/local/pgsql/data.

 

eng91066@ENG91066 ~

$ /usr/bin/pg_ctl -D /usr/local/pgsql/data -o -i -l logfile start

postmaster successfully started

try this
/usr/bin/pg_ctl start -D /usr/local/pgsql/data  -l logfile  -o "-i"

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: Postgres 7.3.1 on Windows XP Home / Professional
Next
From: "Igor Georgiev"
Date:
Subject: Re: Problem with PostgreSQL: unable to connect to database