-----Original Message-----
From: Reshat Sabiq [mailto:sabiq(at)purdue(dot)edu]
Sent: 22 December 2002 01:51
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Can't connect on Windows
I installed cygwin-based postgreSQL. I have not been able yet to
start it as a service (net start postmaster), apparently because of
permissions problems. I'm waiting on some suggestions, hopefully, about
that.
I can connect to the DB w/o starting a service from the cygwin
command line, however, in that case I only have 1 user (myself), no
postgres user is there yet. This way, I cannot connect to the DB from
pgAdmin (localhost), it says "Could not connect to the server", "Could
not connect to remote socket".
The 'postgres' user is whoever ran initdb.
Do I get it right that to connect on localhost with pgAdmin, I
have to have postmaster running as a service? I think adding postgres
user and running w/o net start postmaster will not make any difference.
Is that right?
Yes, that's right - you don't need to run as a service. In fact, on my
dev laptop I prefer it that way as I can start/stop PG in a bash windows
when I like so I'm not wasting cycles when I'm doing other things.
Regards, Dave.