Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E12C99FBF11 for ; Thu, 18 Oct 2007 09:55:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 33329-08 for ; Thu, 18 Oct 2007 09:55:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hoefnix.telenet-ops.be (hoefnix.telenet-ops.be [195.130.132.54]) by postgresql.org (Postfix) with ESMTP id C6D3D9FBEF2 for ; Thu, 18 Oct 2007 09:55:38 -0300 (ADT) Received: from hoboe2bl1.telenet-ops.be (hoboe2bl1.telenet-ops.be [195.130.137.73]) by hoefnix.telenet-ops.be (Postfix) with ESMTP id 499F79C91A for ; Thu, 18 Oct 2007 14:55:37 +0200 (CEST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hoboe2bl1.telenet-ops.be (Postfix) with SMTP id E2E3B124071 for ; Thu, 18 Oct 2007 14:55:34 +0200 (CEST) Received: from [192.168.0.104] (cable-87-244-158-175.upc.chello.be [87.244.158.175]) by hoboe2bl1.telenet-ops.be (Postfix) with ESMTP id D1B30124070 for ; Thu, 18 Oct 2007 14:55:34 +0200 (CEST) From: Sylvain Brohee To: pgsql-admin@postgresql.org Subject: could not open file "global/pg_database" Date: Thu, 18 Oct 2007 14:56:03 +0200 User-Agent: KMail/1.9.5 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200710181456.03192.sylvain@scmbb.ulb.ac.be> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/163 X-Sequence-Number: 27077 Dear PostgreSQL users, =46irst of all sorry for double-posting my question on this forum and on th= e=20 newbie forum.=20 I'm running postgreSQL 8.1 (installed with YaST) on a Suse 10.2 machine. My $PGDATA variable is /home/postgres/data When I initiate the databases with initdb without argument. It seems to wor= ks=20 as I get this :=20 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 en_US.UTF-8. The default database encoding has accordingly been set to UTF8. fixing permissions on existing directory /home/postgres/data ... ok creating directory /home/postgres/data/global ... ok creating directory /home/postgres/data/pg_xlog ... ok creating directory /home/postgres/data/pg_xlog/archive_status ... ok creating directory /home/postgres/data/pg_clog ... ok creating directory /home/postgres/data/pg_subtrans ... ok creating directory /home/postgres/data/pg_twophase ... ok creating directory /home/postgres/data/pg_multixact/members ... ok creating directory /home/postgres/data/pg_multixact/offsets ... ok creating directory /home/postgres/data/base ... ok creating directory /home/postgres/data/base/1 ... ok creating directory /home/postgres/data/pg_tblspc ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 1000 creating configuration files ... ok creating template1 database in /home/postgres/data/base/1 ... ok initializing pg_authid ... ok enabling unlimited row size for system tables ... ok initializing dependencies ... 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 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. Success. You can now start the database server using: =A0 =A0 postmaster -D /home/postgres/data or =A0 =A0 pg_ctl -D /home/postgres/data -l logfile start But it I try to run the daemon with=20 pg_ctl -D /home/postgres/data -l logfile start, I get this :=20 Postmaster running (and that's all, nothing is added in logfile) ... and th= e=20 server does not seem to work. If I try create a database=20 createdb testdb createdb: could not connect to database postgres: FATAL: =A0could not open= =20 file "global/pg_database": No such file or directory If I try to create a user createuser sylvain Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n createuser: could not connect to database postgres: FATAL: =A0could not ope= n=20 file "global/pg_database": No such file or directory It seems that the server cannot get access to global/pg_database but why? E= ven=20 if all the of this file (777) are available. It cannot get access to it? Does somebody as any idea? Thanks a lot, Sylvain