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.