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...
