From: | Tsutomu Nakajima <ns1090156(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: did freese in creating a database cluster |
Date: | 2010-12-28 02:21:20 |
Message-ID: | AANLkTi=8Ctp1Erb6sUUkYtLkXGmR585e0kh3AaYg-aOK@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I add the information of freeze status in creating a database cluster.
The info is that the following process exists.
postgres 1331432 708812 0 11:08:31 pts/10 0:00 /bin/sh
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -d
postgres 1347694 1331432 120 11:08:32 pts/10 0:05
/usr/local/pgsql/bin/postgres -boot -x0 -F -D/usr/local/pgsql/data -c
shared_buffers=500 -c max_connections=100 template1
* TIME is now.
Regard
Tsutomu
> <<System>>
> PostGreSQL: 7.4.30 the postgres-installer ( postgresql-7.4.30.tar.gz)
> OS: AIXv5.2 TL09 (POWER5)
> Machine: 9119-590(1LPAR)
> <<Status>>
> I have got the following status or problem with an initdb command,
> which is "initdb -D /usr/local/pgsql/data -d".
> The point of "selecting default max_connections..." did freeze,
> and the status is the same although I have waited for 24 hours.
> <<Question>>
> 1. What was the situation happend in creating a database cluster?
> 2. Would you please give me solution or workaround for this status?
> <<In Details>>
> [postgres:/home/pp/postgres]initdb -D /usr/local/pgsql/data -d
> Running in debug mode.
> initdb: internal variables:
> PGDATA=/usr/local/pgsql/data
> datadir=/usr/local/pgsql/share
> PGPATH=/usr/local/pgsql/bin
> ENCODING=
> ENCODINGID=0
> POSTGRES_SUPERUSERNAME=postgres
> POSTGRES_BKI=/usr/local/pgsql/share/postgres.bki
> POSTGRES_DESCR=/usr/local/pgsql/share/postgres.description
> POSTGRESQL_CONF_SAMPLE=/usr/local/pgsql/share/postgresql.conf.sample
> PG_HBA_SAMPLE=/usr/local/pgsql/share/pg_hba.conf.sample
> PG_IDENT_SAMPLE=/usr/local/pgsql/share/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 locales:
> COLLATE: C
> CTYPE: C
> MESSAGES:
> MONETARY: C
> NUMERIC: C
> TIME: C
>
> fixing permissions on existing directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... ok
> creating directory /usr/local/pgsql/data/pg_xlog... ok
> creating directory /usr/local/pgsql/data/pg_clog... ok
> selecting default max_connections...
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-12-28 04:05:04 | Re: did freese in creating a database cluster |
Previous Message | Michael Satterwhite | 2010-12-27 22:46:48 | Re: Help with trigger |