Re: Postgresql installation-initdb failed - Mailing list pgsql-cygwin

You also need to add cygserver to your path (settings->control panel->system->advanced->environment variables if I
remembercorrectly. 

MIke

On Mon, Dec 06, 2004 at 01:12:34AM -0500, AJIT K KADARI wrote:
>
>
>
>
> Hi,
>
> Can anybody with good knowledge on Postgresql installation on Windows XP
> using Cygwin, please help me. I have installed cygwin, run
>
> cygserver-config
>
> both cygserver and postmaster are running as per the messages below. And no
> changes have been made to postgresql.conf or any configuration files, and i
> am including the version of postgresql below.
>
>  Thanks in advance,
>  ajit
> >
> >
> > postgres@AKA ~
> > $ psql --version
> > psql (PostgreSQL) 7.4.5
> > contains support for command-line editing
> >
> > postgres@AKA ~
> > $ cygrunsrv -Q cygserver
> > Service cygserver exists
> > Type                : Own Process
> > Current State       : Running
> > Controls Accepted   : Accept Stop
> >
> > postgres@AKA ~
> > $ cygrunsrv -Q postmaster
> > Service postmaster exists
> > Type                : Own Process
> > Current State       : Running
> > Controls Accepted   : Accept Stop, Accept Shutdown
> >
> > postgres@AKA ~
> > $ initdb -d -D /var/postgresql/data
> > Running in debug mode.
> >
> > initdb: internal variables:
> >   PGDATA=/var/postgresql/data
> >   datadir=/usr/share/postgresql
> >   PGPATH=/usr/bin
> >   ENCODING=
> >   ENCODINGID=0
> >   POSTGRES_SUPERUSERNAME=postgres
> >   POSTGRES_BKI=/usr/share/postgresql/postgres.bki
> >   POSTGRES_DESCR=/usr/share/postgresql/postgres.description
> >   POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
> >   PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
> >   PG_IDENT_SAMPLE=/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 /var/postgresql/data... ok
> > creating directory /var/postgresql/data/base... ok
> > creating directory /var/postgresql/data/global... ok
> > creating directory /var/postgresql/data/pg_xlog... ok
> > creating directory /var/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 /var/postgresql/data/base/1... DEBUG:
> > invoking I
> > pcMemoryCreate(size=1081344)
> > Signal 12
> >
> > initdb: failed
> >
> > postgres@AKA ~
> > $ initdb -d -D /tmp/atest2
> > Running in debug mode.
> >
> > initdb: internal variables:
> >   PGDATA=/tmp/atest2
> >   datadir=/usr/share/postgresql
> >   PGPATH=/usr/bin
> >   ENCODING=
> >   ENCODINGID=0
> >   POSTGRES_SUPERUSERNAME=postgres
> >   POSTGRES_BKI=/usr/share/postgresql/postgres.bki
> >   POSTGRES_DESCR=/usr/share/postgresql/postgres.description
> >   POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
> >   PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
> >   PG_IDENT_SAMPLE=/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.
> >
> > creating directory /tmp/atest2... ok
> > creating directory /tmp/atest2/base... ok
> > creating directory /tmp/atest2/global... ok
> > creating directory /tmp/atest2/pg_xlog... ok
> > creating directory /tmp/atest2/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 /tmp/atest2/base/1... DEBUG:  invoking
> > IpcMemoryC
> > reate(size=1081344)
> > Signal 12
> >
> > initdb: failed
> > initdb: removing data directory "/tmp/atest2"
> >
> > postgres@AKA ~
> > $
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match