X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AC45F9DD5F2 for ; Mon, 12 Dec 2005 01:50:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76061-04 for ; Mon, 12 Dec 2005 01:50:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by postgresql.org (Postfix) with ESMTP id 7FF029DCD64 for ; Mon, 12 Dec 2005 01:50:01 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i11so1672124wra for ; Sun, 11 Dec 2005 21:50:01 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=e/C50aKpDhEBNDDRQ0j3dZLNuR03hxhuWirE3OU3QH9Bf0D/wpnrCh6f0SS4plbZzmU3cBkCo+Cadt3neNwX5q0vyFFHz9zLL7sodSwI+otI2dd7NvvPr/i2flo+liDcxTy/0HIyU+NFPz/0SL92NRBm4Sl8T1VfCB4Z71kMhww= Received: by 10.64.10.9 with SMTP id 9mr5375494qbj; Sun, 11 Dec 2005 21:50:01 -0800 (PST) Received: by 10.64.209.2 with HTTP; Sun, 11 Dec 2005 21:50:01 -0800 (PST) Message-ID: <5e744e3d0512112150g5b5f66c0u77db25c040f0cf09@mail.gmail.com> Date: Mon, 12 Dec 2005 11:20:01 +0530 From: Pandurangan R S To: jey@zoniac.com Subject: Re: Problem in starting Postgres Database Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.035 required=5 tests=[AWL=0.035] X-Spam-Score: 0.035 X-Spam-Level: X-Archive-Number: 200512/90 X-Sequence-Number: 19810 Hi Jey, Looks like there is some problem with directory permissions. Btw, how do you start the DB? (what is the username, command you use) Regards Pandu On 12/10/05, Jey wrote: > > Hi, > > We are using Postgres 7.4.3, in Linux ES 3.0 Version > > While I try to start the postgres service, i am getting the following err= or > in the serverlog file > > > LOG: startup process (PID 4080) was terminated by signal 6 > LOG: aborting startup due to startup process failure > LOG: database system was interrupted at 2005-12-09 15:44:01 CST > PANIC: could not open file > "/usr/local/pgsql/data/pg_xlog/0000000000000010" (log file > 0, segment 16): Permission denied > LOG: startup process (PID 4204) was terminated by signal 6 > LOG: aborting startup due to startup process failure > FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission > denied > FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission > denied > LOG: database system was interrupted at 2005-12-09 15:44:01 CST > PANIC: could not open file > "/usr/local/pgsql/data/pg_xlog/0000000000000010" (log file > 0, segment 16): Permission denied > LOG: startup process (PID 4757) was terminated by signal 6 > LOG: aborting startup due to startup process failure > > > > Regards > Jey > Zoniac Inc > 408-329-4474 >