Re: Problem in starting Postgres Database

From: Pandurangan R S <pandurangan(dot)r(dot)s(at)gmail(dot)com>
To: jey(at)zoniac(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem in starting Postgres Database
Date: 2005-12-12 05:50:01
Message-ID: 5e744e3d0512112150g5b5f66c0u77db25c040f0cf09@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <jey(at)zoniac(dot)com> 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 error
> 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Helbling Julien 2005-12-12 06:49:52 Migration from 8.0.2 to 8.1.0
Previous Message Bruce Momjian 2005-12-12 02:48:23 Re: 8.1: import of 8.0 dump fails with UTF-8 error