Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql installation-initdb failed

Postgresql installation-initdb failed

From
AJIT K KADARI
Date:



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 ~
> $

Re: Postgresql installation-initdb failed

From
"Mike G."
Date:
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

Re: Postgresql installation-initdb failed

From
Jason Tishler
Date:
ajit,

On Mon, Dec 06, 2004 at 01:12:34AM -0500, AJIT K KADARI wrote:
> 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.

Did you forget to set CYGWIN=server?  Please read the README:

    /usr/share/doc/Cygwin/postgresql-7.4.5.README

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6