Re: Problem with PostgreSQL: unable to connect to database

From: "Igor Georgiev" <gory(at)alphasoft-bg(dot)com>
To: "Cheah Ai Meng" <aimeng(dot)cheah(at)nus(dot)edu(dot)sg>, "Pgsql-Cygwin" <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Problem with PostgreSQL: unable to connect to database
Date: 2003-01-23 09:24:31
Message-ID: 001801c2c2c1$40d9fde0$0b0546c0@alpha.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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"

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Igor Georgiev 2003-01-23 09:38:20 Re: Problem with PostgreSQL: unable to connect to database
Previous Message Cheah Ai Meng 2003-01-23 08:38:05 Re: Problem with PostgreSQL: unable to connect to database