| Lists: | pgsql-cygwin |
|---|
| From: | AJIT K KADARI <akada005(at)odu(dot)edu> |
|---|---|
| To: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Postgresql installation-initdb failed |
| Date: | 2004-12-06 06:12:34 |
| Message-ID: | OFCE000714.6FB2B9D0-ON85256F62.00221C47-85256F62.00221C68@notes.odu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg와이즈 토토SQL |
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 ~
> $
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From: | Jason Tishler <jason(at)tishler(dot)net> |
|---|---|
| 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 12:13:06 |
| Message-ID: | 20041207121306.GB2164@tishler.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 베이SQL |
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