X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 73ADC5E40AC for ; Wed, 1 Sep 2004 10:27:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64489-08 for ; Wed, 1 Sep 2004 13:27:17 +0000 (GMT) Received: from post.queensu.ca (post.QueensU.CA [130.15.126.6]) by svr1.postgresql.org (Postfix) with ESMTP id 0F1AF5E3F15 for ; Wed, 1 Sep 2004 10:27:13 -0300 (ADT) Received: from Seamus.post.queensu.ca (taffy.its.QueensU.CA [130.15.48.212]) by post.queensu.ca (8.10.1/8.10.1) with ESMTP id i81DRHX26339 for ; Wed, 1 Sep 2004 09:27:17 -0400 (EDT) Message-Id: <6.1.2.0.0.20040901091028.01bd9488@post.queensu.ca> X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Wed, 01 Sep 2004 09:27:00 -0400 To: pgsql-admin@postgresql.org From: Seamus Ryan Subject: initdb - (InitPostgres) - FATAL: database "postgres" does not exist Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/15 X-Sequence-Number: 14718 hi, I am having trying to install Postgres 7.4.5, I have gmake 3.76.1 installed. I have completed following steps: ./configure --prefix=/opt/local --enable-multibyte --enable-unicode --with-java --without-readline make su rootr make install adduser postgres mkdir /opt/local/pgsql mkdir /opt/local/pgsql/data chown postgres /opt/local/pgsql chown postgres /opt/local/pgsql/data su - postgres /opt/local/bin/initdb -D /opt/local/pgsql/data Note in the initdb script I altered the call to postgres to turn on debug: ========================================================================== /opt/local/bin/postgres -d 5 -F -D/opt/local/pgsql/data -O -c search_path=pg_catalog -c exit_on_error=true Here is output from initdb with above change: ========================================================================= $ ./initdb -D /opt/local/pgsql/data 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 /opt/local/pgsql/data... ok creating directory /opt/local/pgsql/data/base... ok creating directory /opt/local/pgsql/data/global... ok creating directory /opt/local/pgsql/data/pg_xlog... ok creating directory /opt/local/pgsql/data/pg_clog... ok selecting default max_connections... 100 selecting default shared_buffers... 1000 creating configuration files... ok creating template1 database in /opt/local/pgsql/data/base/1... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok creating information schema... ok vacuuming database template1... DEBUG: found "/opt/local/bin/postgres" using argv[0] DEBUG: invoking IpcMemoryCreate(size=10461184) LOG: database system was shut down at 2004-09-01 08:12:34 EDT LOG: checkpoint record is at 0/6253E8 LOG: redo record is at 0/6253E8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 462; next OID: 17141 LOG: database system is ready DEBUG: InitPostgres FATAL: database "postgres" does not exist <=== FAILURE POINT!!! DEBUG: proc_exit(1) DEBUG: shmem_exit(1) LOG: shutting down LOG: database system is shut down DEBUG: exit(1) ========================================================================== Any hints on why InitPostgres is not finding database "postgres"? thanks, Seamus Solaris 9 ========= $ env HOME=/export/home/postgres HZ= LOGNAME=postgres PATH=/usr/bin: SHELL=/bin/sh TERM=xterm TZ=Canada/Easter