Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1054E9FB474 for ; Thu, 21 Jun 2007 02:21:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 08316-01-4 for ; Thu, 21 Jun 2007 02:21:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 3D4689FB485 for ; Thu, 21 Jun 2007 02:15:46 -0300 (ADT) Received: (qmail 18167 invoked from network); 21 Jun 2007 05:15:44 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;ba597a4ab342be6395820be84150cb87; Received: from mail.weatherbeeta.com.au (10.10.0.2) by 10.20.0.254 with SMTP; 21 Jun 2007 05:15:44 -0000 Received: (qmail 15678 invoked by uid 1166); 21 Jun 2007 15:15:33 +1000 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.293737 secs); 21 Jun 2007 05:15:33 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.293737 secs Process 15668) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 21 Jun 2007 15:15:31 +1000 From: "Phillip Smith" To: Subject: Re: initdb problem Date: Thu, 21 Jun 2007 15:15:49 +1000 Organization: Weatherbeeta Pty Ptd Message-ID: <011901c7b3c3$3ad68380$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <467a0376.b4.49b9.1068201001@ihug.co.nz> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1182402944.778-18162-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.08 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/215 X-Sequence-Number: 25883 So did initdb execute without errors after you changed the home = directory? It looks like your postgresql.conf file is pointing Postgres to log to a directory / file that the Postgres user doesn't have permission to write = to. ~p -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Joe Barwell Sent: Thursday, 21 June 2007 14:50 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] initdb problem acorn$ sudo su postgres -c 'pg_ctl start -l logfile -D /Library/PostgreSQL8/data' Password: sh: line 1: logfile: Permission denied server starting acorn$ postgres postgres cannot access the server configuration file "/Library/PostgreSQL8/data:/postgresql.conf": No such file or directory Surely initdb should have created the configure file? *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments