Thread: 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@postgresql.org