Re: Postgresql fails to start? (Update)

From: Dianne Yumul <dianne(at)wellsgaming(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql fails to start? (Update)
Date: 2005-06-09 19:23:48
Message-ID: 8596f97934a684f4521e585e31b9b4a8@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just an update . . . I tried upgrading kernel to 2.6.11.11 (kernel.org)
but was unsuccessful (due to i2c and gcc 4.0 issue). So I settled for
the one on the fedora development repository. But that didn't help,
upgraded other stuff too like selinux-policy-targeted and initscripts.
Beginning to pull my hair out at this point.

Tried relabeling filesystem per selinux faq. Used fixfiles restore,
which looked promising because now ls -Z on my /home actually showed
some stuff. Now the big test:

# touch /home/postgres/pgstartup.log
# ls -Z /home/postgres/pgstartup.log
-rw-r--r-- root root
/home/postgres/pgstartup.log
# chown postgres:postgres /home/postgres/pgstartup.log
# chmod go-rwx /home/postgres/pgstartup.log
# chcon -u system_u -r object_r -t postgresql_log_t
/home/postgres/pgstartup.log
chcon: can't apply partial context to unlabeled file
/home/postgres/pgstartup.log
# ls -Z /home/postgres/pgstartup.log
-rw------- postgres postgres
/home/postgres/pgstartup.log

Argh . . . But found this odd thing while googling:

# touch /home/postgres/pgstartup.log
# ls -Z /home/postgres/pgstartup.log
-rw-r--r-- root root
/home/postgres/pgstartup.log
# chown postgres:postgres /home/postgres/pgstartup.log
# chmod go-rwx /home/postgres/pgstartup.log
# chcon system_u:object_r:postgresql_log_t /home/postgres/pgstartup.log
# ls -Z /home/postgres/pgstartup.log
-rw------- postgres postgres system_u:object_r:postgresql_log_t
/home/postgres/pgstartup.log

Voila, it works. I kind of have to move on now. Since this is just a
development box, this will do for now. When the final Fedora Core 4
comes out will install that and see what happens.

Thank very much again for the great help.

dianne

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Browne 2005-06-09 19:37:15 monetary data
Previous Message Tom Lane 2005-06-09 18:48:33 Re: postgreSQL 7.3.8, pg_dump not able to find large o