Обсуждение: Problem in starting Postgres Database

Поиск
Список
Период
Сортировка

Problem in starting Postgres Database

От
"Jey"
Дата:
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
 

Re: Problem in starting Postgres Database

От
Pandurangan R S
Дата:
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@zoniac.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
>