Re: Moved postgres, now won't start

From: Madison Kelly <linux(at)alteeve(dot)com>
To: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moved postgres, now won't start
Date: 2007-07-16 18:33:26
Message-ID: 469BB9F6.1090507@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zoltan Boszormenyi wrote:
> Do you use SELinux?
> Look for "avc denied" messages in the logs to see if it's the case.

No, I don't (unless I missed it and Debian Etch uses it by default
now). To be sure, I checked the log files and only say this:

2007-07-16 13:58:03 EDT LOG: incomplete startup packet
2007-07-16 13:58:04 EDT LOG: could not open temporary statistics file
"global/pgstat.tmp": No such file or directory
2007-07-16 13:59:03 EDT FATAL: could not open file
"global/pg_database": No such file or directory
2007-07-16 13:59:04 EDT LOG: could not open temporary statistics file
"global/pgstat.tmp": No such file or directory
2007-07-16 14:00:03 EDT FATAL: could not open file
"global/pg_database": No such file or directory

Over and over again. I tried shutting down postgresql again and got
this at the shell:

# /etc/init.d/postgresql-8.1 stop
Stopping PostgreSQL 8.1 database server: main* pg_ctl: postmaster does
not shut down
(does not shutdown gracefully, now stopping immediately)pg_ctl: could
not send stop signal (PID: 19958): No such process
Insecure dependency in kill while running with -T switch at
/usr/bin/pg_ctlcluster line 370.
(does not shutdown, killing the process)
failed!

And this in the logs:

2007-07-16 14:28:00 EDT LOG: received fast shutdown request
2007-07-16 14:28:00 EDT LOG: shutting down
2007-07-16 14:28:00 EDT PANIC: could not open control file
"global/pg_control": No such file or directory
2007-07-16 14:28:00 EDT LOG: background writer process (PID 19960) was
terminated by signal 6
2007-07-16 14:28:00 EDT LOG: terminating any other active server processes
2007-07-16 14:28:00 EDT LOG: all server processes terminated;
reinitializing
2007-07-16 14:28:00 EDT LOG: could not open file "postmaster.pid": No
such file or directory
2007-07-16 14:28:00 EDT PANIC: could not open control file
"global/pg_control": No such file or directory
2007-07-16 14:28:00 EDT LOG: could not open temporary statistics file
"global/pgstat.tmp": No such file or directory

Lastly, to be very sure, I tried grep'ing for that string with no
results:

nicole:/var/log# grep "avc denied" * -Rni
nicole:/var/log#

Thanks for the reply!

Madison

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2007-07-16 18:36:25 What's the logical counterpart of the to_hex function?
Previous Message Madison Kelly 2007-07-16 18:26:37 Re: Moved postgres, now won't start