Postgres Pro
Downloads
Home   >   mailing lists

Thread: [ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

[ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

From
"Steve SAUTETNER"
Date:
Hello !

I've got a little problem with launching initdb on postgresql 7.1.2 under
cygwin :

when i launch it, it says :

$ initdb -d -n -D $PG_DATA
Running with debug mode on.
Running with noclean mode on. Mistakes will not be cleaned up.

Initdb variables:
  PGDATA=/data/pgsql
  datadir=/usr/share/postgresql
  PGPATH=/usr/bin
  TEMPFILE=/tmp/initdb.412
  MULTIBYTE=SQL_ASCII
  MULTIBYTEID=0
  POSTGRES_SUPERUSERNAME=ssautetn
  POSTGRES_SUPERUSERID=1003
  TEMPLATE1_BKI=/usr/share/postgresql/template1.bki
  GLOBAL_BKI=/usr/share/postgresql/global.bki
  TEMPLATE1_DESCR=/usr/share/postgresql/template1.description
  GLOBAL_DESCR=/usr/share/postgresql/global.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
This database system will be initialized with username "ssautetn".
This user will own all the data files and must also own the server process.

Creating directory /data/pgsql
Creating directory /data/pgsql/base
Creating directory /data/pgsql/global
Creating directory /data/pgsql/pg_xlog
Creating template1 database in /data/pgsql/base/1
Running: /usr/bin/postgres -boot -x1 -C -F -D/data/pgsql -d template1

and then the postgres process freezes and take 100 % of cpu, never creating
the template1 files, so i must kill it.

As anyone an idea on what's happening ?
thank's.

Re: [ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

From
Tom Lane
Date:
"Steve SAUTETNER" <ssa@informactis.com> writes:
> Running: /usr/bin/postgres -boot -x1 -C -F -D/data/pgsql -d template1

> and then the postgres process freezes and take 100 % of cpu, never creating
> the template1 files, so i must kill it.

> As anyone an idea on what's happening ?

Nope.  Can you attach to the stuck process with gdb and get a stack
trace?  Knowing where it's hung up would help.

            regards, tom lane

Re: [ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

From
Barry Lind
Date:
My guess is that you don't have the ipc-daemon running before you run
initdb.

--Barry

Steve SAUTETNER wrote:
> Hello !
>
> I've got a little problem with launching initdb on postgresql 7.1.2 under
> cygwin :
>
> when i launch it, it says :
>
> $ initdb -d -n -D $PG_DATA
> Running with debug mode on.
> Running with noclean mode on. Mistakes will not be cleaned up.
>
> Initdb variables:
>   PGDATA=/data/pgsql
>   datadir=/usr/share/postgresql
>   PGPATH=/usr/bin
>   TEMPFILE=/tmp/initdb.412
>   MULTIBYTE=SQL_ASCII
>   MULTIBYTEID=0
>   POSTGRES_SUPERUSERNAME=ssautetn
>   POSTGRES_SUPERUSERID=1003
>   TEMPLATE1_BKI=/usr/share/postgresql/template1.bki
>   GLOBAL_BKI=/usr/share/postgresql/global.bki
>   TEMPLATE1_DESCR=/usr/share/postgresql/template1.description
>   GLOBAL_DESCR=/usr/share/postgresql/global.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
> This database system will be initialized with username "ssautetn".
> This user will own all the data files and must also own the server process.
>
> Creating directory /data/pgsql
> Creating directory /data/pgsql/base
> Creating directory /data/pgsql/global
> Creating directory /data/pgsql/pg_xlog
> Creating template1 database in /data/pgsql/base/1
> Running: /usr/bin/postgres -boot -x1 -C -F -D/data/pgsql -d template1
>
> and then the postgres process freezes and take 100 % of cpu, never creating
> the template1 files, so i must kill it.
>
> As anyone an idea on what's happening ?
> thank's.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>