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

Started by Steve SAUTETNERover 24 years ago3 messagesgeneral

Jump to latest

Steve SAUTETNER

ssa@informactis.com

over 24 years ago

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.

Tom Lane

tgl@sss.pgh.pa.us

over 24 years ago

In reply to: Steve SAUTETNER (#1)

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

"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

Barry Lind

barry@xythos.com

over 24 years ago

In reply to: Steve SAUTETNER (#1)

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

My guess is that you don't have the ipc-daemon running before you run
initdb.

--Barry

Steve SAUTETNER wrote:

Show quoted text

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