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@wellsgaming.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
>