Thread: Problem installing postgresql in XP with cygwin

Problem installing postgresql in XP with cygwin

From
franciscojavier.solis@sainsel.abengoa.com
Date:
Hi,

I'm installinng postgresql in XP with cygwin. I have downloaded the last
version of cygwin today, so the software is up to date.
I have included in the download the packages cygrunsrv and cygipc, in
addition to postgres, of course.

I have created a new user postgres with right to log on as a service.
After I have executed the previous sentence I did in cygwin:

ipc-daemon2 --install-as-service

After that, I have created the directory for the data and make postgres the
owner of it.

and finally I restart the computer and connected with the progress user.

In cygwin  again I did the following:

postgres@PC_330540 ~
$ initdb -d -D /usr/share/postgresql/data
Running in debug mode.

initdb: internal variables:
  PGDATA=3D/usr/share/postgresql/data
  datadir=3D/usr/share/postgresql
  PGPATH=3D/usr/bin
  ENCODING=3D
  ENCODINGID=3D0
  POSTGRES_SUPERUSERNAME=3Dpostgres
  POSTGRES_BKI=3D/usr/share/postgresql/postgres.bki
  POSTGRES_DESCR=3D/usr/share/postgresql/postgres.description
  POSTGRESQL_CONF_SAMPLE=3D/usr/share/postgresql/postgresql.conf.sample
  PG_HBA_SAMPLE=3D/usr/share/postgresql/pg_hba.conf.sample
  PG_IDENT_SAMPLE=3D/usr/share/postgresql/pg_ident.conf.sample
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
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/share/postgresql/data/base/1... DEBUG:
invo
king IpcMemoryCreate(size=3D1081344)
Signal 12

initdb: failed

postgres@PC_330540 ~
$


I have already tested that the Cygwin IPC Daemon 2 is running.

I think that is a problem related with that service but I don't konw where
to continious looking. =BFAny idea?
I don't see any error regarding that service in the XP log.

Thank you and best regards
***********Internet Email Confidentiality Footer*************
This email and any files transmitted with it are confidential and intended
solely for the use of the organization or individual to whom they are
addressed.  It is expressly forbidden to retransmit or copy email and/or
this  attached files without our permission .  If you are not the
addressee indicated in this message (or responsible for delivery of the
message to such person), you may not copy or deliver this message
to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or
your employer does not consent to Internet email for messages of this
kind.  Opinions, conclusions and other information in this message that
do not relate to the official business of my firm shall be understood as
neither given nor endorsed by it.

Re: Problem installing postgresql in XP with cygwin

From
Klint Gore
Date:
On Fri, 12 Nov 2004 13:28:02 +0100, franciscojavier.solis@sainsel.abengoa.com wrote:
> I'm installinng postgresql in XP with cygwin. I have downloaded the last
> version of cygwin today, so the software is up to date.
> I have included in the download the packages cygrunsrv and cygipc, in
> addition to postgres, of course.
>
> I have created a new user postgres with right to log on as a service.
> After I have executed the previous sentence I did in cygwin:
>
> ipc-daemon2 --install-as-service

this has been replaced with cygserver

make sure the CYGWIN environment variable is set to SERVER
run cygserver-config

then start the cygserver service or run the cygserver in the background

then try the initdb again.

Can you post another message to the list with where the instructions you
followed are so they can be updated?

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg@kgb.une.edu.au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+