The problem in connecting as myself was conf setting to allow tcp_ip socket connections. I don't even reach that stage when doing initdb as postgres. So, right now, I still don’t have postgres as a DB user, and
fail to run as a service, because I the error below. There I start install as myself, then switch to OS user postgres for initdb (instead su), hoping to come back afterwards.
If I can do development and some cross-platform stuff as myself, then it’s all right for my cygwin postreSQL. But still I running it as a service would be nicer.
For now, I did succeed in connecting with pgAdmin as myself. The error below didn’t come up when running w/o a service as myself.
Thanks,
r.
P.S.
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user "postgres". This user must also own the server process.
The database cluster will be initialized with locale C.
Fixing permissions on existing directory /usr/share/postgresql/data... ok creating directory /usr/share/postgresql/data/base... ok creating directory /usr/share/postgresql/data/global... ok creating directory /usr/share/postgresql/data/pg_xlog... ok creating directory /usr/share/postgresql/data/pg_clog... ok creating template1 database in /usr/share/postgresql/data/base/1...
IpcSemaphore
Create: semget(key=1, num=17, 03600) failed: Function not implemented
initdb failed.