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.