Re: initdb failing

Hello.

I installed cygwin on my windows xp machine with the postrgresql package. I
run the ipc-daemon2 & command and it goes thru but then I try to create a
cluster using initdb -D usr/local/database the following happens:

$ initdb -D usr/local/database
The files belonging to this database system will be owned by user "Owner".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory usr/local/database... ok
creating directory usr/local/database/base... ok
creating directory usr/local/database/global... ok
creating directory usr/local/database/pg_xlog... ok
creating directory usr/local/database/pg_clog... ok
selecting default max_connections... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
10
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in usr/local/database/base/1... Signal 12

initdb: failed
initdb: removing data directory "usr/local/database"

Why does initdb fail for me?

ipc-daemon2 is no longer used. Use cygserver instead. There are a few
postings to the list now with instructions.

Mike
On Mon, 2004-06-14 at 16:38, Sonia wrote:
> Hello.
>
> I installed cygwin on my windows xp machine with the postrgresql package. I
> run the ipc-daemon2 & command and it goes thru but then I try to create a
> cluster using initdb -D usr/local/database the following happens:
>
> $ initdb -D usr/local/database
> The files belonging to this database system will be owned by user "Owner".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory usr/local/database... ok
> creating directory usr/local/database/base... ok
> creating directory usr/local/database/global... ok
> creating directory usr/local/database/pg_xlog... ok
> creating directory usr/local/database/pg_clog... ok
> selecting default max_connections... Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> 10
> selecting default shared_buffers... Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> Signal 12
> 50
> creating configuration files... ok
> creating template1 database in usr/local/database/base/1... Signal 12
>
> initdb: failed
> initdb: removing data directory "usr/local/database"
>
>
> Why does initdb fail for me?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Dear list,

I am trying to run Postgres for the first time, and under Cygwin to boot,
and it seems I was caught in a change from ipc-daemon2 to cygserver. I had
originally ran ipc-daemon2, following old instructions.

But then I followed the install instructions in the 7.4.3.README, for a
single user under WinXP. I set CYGWIN to server, ran cygserver-config.

When I run cygserver (having added /usr/sbin to my path which is necessary,
but not noted), I get:

Init complete, waiting for requests
failed to creat named pipe: is the daemon already running?
fatal error on IPC transport: closing down.

I presume my problem is related to the following comment on the list from Mike,

"Make sure you have installed cygserver, included it in your path, delete
the current postgres service you have installed, and finally reinstall the
postgres service using cygserver instead of the ipc-daemon2."

I suppose this is what I should do? But I do not know how to do this delete
and reinstall.

Help, anyone!!

David

>ipc-daemon2 is no longer used. Use cygserver instead. There are a few

Hello,

If you followed the 7.4.1 readme as a service when you installed it as a
service the first time it would have referenced ipc-daemon2. To remove
the service do the following at a bash prompt, cygrunsrv -R postmaster.

That will uninstall the postmaster service. You can then reinstall the
postmaster service as mention in 7.4.3 Readme,

Adding /usr/sbin to your path is necessary only if you did not create a
system variable for cygwin. If you used control panel->system->advanced
tab->environment variables: Did you create the cygwin variable in the
top section or the bottom section? For cygserver to run as a
service(normally under a local system account and not your user account)
you must create the variable in the bottom / system section. You do
need administrator rights to add system variables.

Hope that helps.

Mike

On Wed, 2004-06-23 at 02:21, David Riggs wrote:
> Dear list,
>
> I am trying to run Postgres for the first time, and under Cygwin to boot,
> and it seems I was caught in a change from ipc-daemon2 to cygserver. I had
> originally ran ipc-daemon2, following old instructions.
>
> But then I followed the install instructions in the 7.4.3.README, for a
> single user under WinXP. I set CYGWIN to server, ran cygserver-config.
>
> When I run cygserver (having added /usr/sbin to my path which is necessary,
> but not noted), I get:
>
> Init complete, waiting for requests
> failed to creat named pipe: is the daemon already running?
> fatal error on IPC transport: closing down.
>
> I presume my problem is related to the following comment on the list from Mike,
>
> "Make sure you have installed cygserver, included it in your path, delete
> the current postgres service you have installed, and finally reinstall the
> postgres service using cygserver instead of the ipc-daemon2."
>
> I suppose this is what I should do? But I do not know how to do this delete
> and reinstall.
>
> Help, anyone!!
>
> David
>
>
>
>
>
> >ipc-daemon2 is no longer used. Use cygserver instead. There are a few
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org