Thread: Problem in starting Postgres Database
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
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
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 >