Re: Postgresql fails to start?

> Can you say anything about the difference between the times where it
> gives the message and the times where it doesn't?

I get the message when I remove pgstartup.log before starting
postgresql. But if I leave pgstartup.log, it just says it failed to
start. Please see output below:

# /etc/rc.d/init.d/postgresql stop
Stopping postgresql service: [ OK ]
# ps aux | grep postmaster
root 10427 0.0 0.0 3752 664 pts/0 R+ 09:24 0:00 grep
postmaster
# rm -f pgstartup.log
# /etc/rc.d/init.d/postgresql start
/usr/bin/chcon: can't apply partial context to unlabeled file
/home/postgres/pgstartup.log
Starting postgresql service: [FAILED]
# ps aux | grep postmaster
postgres 10470 34.1 0.6 112404 5248 pts/0 S 09:24 0:02
/usr/bin/postmaster -p 5432 -D /home/postgres/data
root 10480 0.0 0.0 3756 668 pts/0 R+ 09:24 0:00 grep
postmaster

The pgstartup.log is empty. Also, data/pg_log/postgresql-Tue.log does
not contain any errors just stuff about database shutting down and
starting up. Now, trying without removing pgstartup.log:

# /etc/rc.d/init.d/postgresql stop
Stopping postgresql service: [ OK ]
# ps aux | grep postmaster
root 10244 0.0 0.0 3756 700 pts/0 R+ 09:20 0:00 grep
postmaster
# /etc/rc.d/init.d/postgresql start
Starting postgresql service: [FAILED]
# ps aux | grep postmaster
postgres 10566 20.6 0.6 112408 5312 pts/0 S 09:26 0:02
/usr/bin/postmaster -p 5432 -D /home/postgres/data
root 10577 0.0 0.0 3752 668 pts/0 R+ 09:26 0:00 grep
postmaster

I remember getting the message that postgresql started OK once or twice
yesterday, but could not get it to do now : (

> ls -Z /home/postgres/pgstartup.log

Gives:

Sorry, this option can only be used on a SELinux kernel.

But after setting selinux to permissive mode, ls -Z
/home/postgres/pgstartup.log gives:

-rw------- postgres postgres system_u:object_r:postgresql_log_t
/home/postgres/pgstartup.log

And I also tried starting postgresql with selinux in permissive mode,
but no dice.

> Oh, and is the message really complaining
> about /home/postgres/pgstartup.log? AFAICS the initscript should be
> messing with /var/lib/pgsql/pgstartup.log.

Sorry, I forgot to mention that I changed some of the defaults via
/etc/sysconfig/pgsql/postgresql file, which looks like this:

PGDATA=/home/postgres/data
PGLOG=/home/postgres/pgstartup.log

But even leaving the defaults alone gives me the same results:

# /etc/rc.d/init.d/postgresql start
/usr/bin/chcon: can't apply partial context to unlabeled file
/var/lib/pgsql/pgstartup.log
Initializing database: [ OK ]
Starting postgresql service: [FAILED]
# ps aux | grep postmaster
postgres 11003 9.4 0.3 19464 2988 pts/0 S 09:36 0:02
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data

Many thanks for the help.

Dianne

On Jun 7, 2005, at 9:02 AM, Tom Lane wrote:

> Dianne Yumul <dianne(at)wellsgaming(dot)com> writes:
>>> Um, exactly which Postgres RPMs do you have installed?
>> Thanks for the response. I have the following installed:
>
>> postgresql-server-8.0.3-1
>> postgresql-8.0.3-1
>> postgresql-jdbc-8.0.3-1
>> postgresql-libs-8.0.3-1
>> postgresql-devel-8.0.3-1
>
> Hm, those are the most current versions.
>
> Can you say anything about the difference between the times where it
> gives the message and the times where it doesn't? Does
> ls -Z /home/postgres/pgstartup.log
> show anything different? Oh, and is the message really complaining
> about /home/postgres/pgstartup.log? AFAICS the initscript should be
> messing with /var/lib/pgsql/pgstartup.log.
>
> regards, tom lane
>