Re: Can't connect on Windows->half done - Mailing list pgadmin-support

From Reshat Sabiq
Subject Re: Can't connect on Windows->half done
Date
Msg-id 000701c2a986$672699d0$7882d380@main
Whole thread Raw
List pgadmin-support

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.

 

pgadmin-support by date:

Previous
From: "Reshat Sabiq"
Date:
Subject: Can't connect on Windows
Next
From: "Reshat Sabiq"
Date:
Subject: Access-postgreSQL migration (extra invalid foreign key added)