Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5D65F2E2DE0 for ; Mon, 26 Nov 2007 23:34:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 53738-09 for ; Mon, 26 Nov 2007 23:34:20 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id 9C4132E2DD8 for ; Mon, 26 Nov 2007 23:34:38 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so2177965pyb for ; Mon, 26 Nov 2007 19:34:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=ems8ayqo5pHpVF7Iqag3U7J4RHKg6goUHGfvRwgClxc=; b=GnZQv/pNZXIkCA/lQhIIy8hn+V8mEuOVNEYbXNrqrQhqlYBqyMlrSb0Do036tACsdox+sOkp3+5hTNwoxQ4XABHtCFETMhkx/tCzSXAm2p2D8vJ64oSwqDhhmROFjyaWcoqxt2odI8QQVPRXi8wHYblxjvuHekZHUOY67wlSem8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type; b=dVeFWyj/P6vds74zwy7lG8OVVHztjazImtKIC+XWLfemIa7yzTBYW1TzrOT/pevHB/ySZd3IFWHnTOzTVxBWXYsqWK77KUB4OBXdd4z+Wd39k49+WFkfKn30OsCglbVC9jOlGzBalRfhKt8QNhUYykFNFTBkW7cbz+LHKqdZN8M= Received: by 10.65.219.20 with SMTP id w20mr7606868qbq.1196134476839; Mon, 26 Nov 2007 19:34:36 -0800 (PST) Received: by 10.64.242.15 with HTTP; Mon, 26 Nov 2007 19:34:36 -0800 (PST) Message-ID: <8078a1730711261934l22e62f68t26301d638ae73c96@mail.gmail.com> Date: Mon, 26 Nov 2007 19:34:36 -0800 From: "Medi Montaseri" To: pgsql-admin@postgresql.org Subject: postmaster -D PGDATA and postmaster.pid MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2762_22495286.1196134476822" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/228 X-Sequence-Number: 27471 ------=_Part_2762_22495286.1196134476822 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I am configuring a PG 8.1.9 on CentOS 5. I am seeing some anomalies and would like you feedback. I have defined a new PGDATA=/qmsvol/pg_8.1.9/data, ran initdb -D /qmsvol/pg_8.1.9/data successfully and can start the engine with pg_ctl -D $PGDATA. I have also populated /etc/sysconfig/pgsql/postgresql which overrides PGDATA and PGLOG to my values. However if I try to start the engine with "/etc/init.d/postgresql start " or service postgresql start" I see the following error message in my PGLOG (ie /var/log/pgsql/pgstartup.log) postmaster cannot access the server configuration file "/qmsvol/pg_8.1.9/data/postgresql.conf": Permission denied ls -ld /qmsvol /qmsvol/pg_8.1.9 /qmsvol/pg_8.1.9/data /qmsvol/pg_8.1.9/data/postgresql.conf drwxrwxrwx 4 root root 4096 Nov 26 10:39 /qmsvol drwx------ 3 postgres postgres 4096 Nov 26 11:25 /qmsvol/pg_8.1.9 drwx------ 11 postgres postgres 4096 Nov 26 12:04 /qmsvol/pg_8.1.9/data -rw------- 1 postgres postgres 13699 Nov 26 11:25 /qmsvol/pg_8.1.9/data/postgresql.conf Any ideas ? Thanks medi ------=_Part_2762_22495286.1196134476822 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

I am configuring a PG 8.1.9 on CentOS 5. I am seeing some anomalies and would like you feedback.
I have defined a new PGDATA=/qmsvol/pg_8.1.9/data, ran initdb -D /qmsvol/pg_8.1.9/data successfully and can start the engine with pg_ctl -D $PGDATA.

I have also populated /etc/sysconfig/pgsql/postgresql which overrides PGDATA and PGLOG to my values.

However if I try to start the engine with "/etc/init.d/postgresql start " or service postgresql start" I see the following error message in my PGLOG (ie /var/log/pgsql/pgstartup.log)

postmaster cannot access the server configuration file "/qmsvol/pg_8.1.9/data/postgresql.conf": Permission denied

ls -ld /qmsvol /qmsvol/pg_8.1.9 /qmsvol/pg_8.1.9/data /qmsvol/pg_8.1.9/data/postgresql.conf
drwxrwxrwx  4 root     root     4096 Nov 26 10:39 /qmsvol
drwx------  3 postgres postgres 4096 Nov 26 11:25 /qmsvol/pg_8.1.9
drwx------ 11 postgres postgres 4096 Nov 26 12:04 /qmsvol/pg_8.1.9/data
-rw------- 1 postgres postgres 13699 Nov 26 11:25 /qmsvol/pg_8.1.9/data/postgresql.conf

Any ideas ?

Thanks
medi




------=_Part_2762_22495286.1196134476822--