Skip site navigation (1) Skip section navigation (2)

Re: Postgresql installation-initdb failed

From: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
To: AJIT K KADARI <akada005(at)odu(dot)edu>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Postgresql installation-initdb failed
Date: 2004-12-07 02:54:39
Message-ID: 20041207025439.GA23142@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-cygwin
You also need to add cygserver to your path (settings->control panel->system->advanced->environment variables if I remember correctly.

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(at)AKA ~
> > $ psql --version
> > psql (PostgreSQL) 7.4.5
> > contains support for command-line editing
> >
> > postgres(at)AKA ~
> > $ cygrunsrv -Q cygserver
> > Service cygserver exists
> > Type                : Own Process
> > Current State       : Running
> > Controls Accepted   : Accept Stop
> >
> > postgres(at)AKA ~
> > $ cygrunsrv -Q postmaster
> > Service postmaster exists
> > Type                : Own Process
> > Current State       : Running
> > Controls Accepted   : Accept Stop, Accept Shutdown
> >
> > postgres(at)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(at)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(at)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

In response to

pgsql-cygwin by date

Next:From: Mike G.Date: 2004-12-07 02:57:49
Subject: Re: postgresql-cygwin-windowsXP
Previous:From: Sehat RosnyDate: 2004-12-06 16:49:59
Subject: Re: Postgres Database Design Issues in Tablespace

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group