niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » PostgreSQL
Can't start PostgreSQL on Fedora Core3
Post new topic   Reply to topic Page 1 of 1 [9 Posts] View previous topic :: View next topic
Author Message
Ulrich Wisser
*nix forums beginner


Joined: 09 Mar 2005
Posts: 5

PostPosted: Thu Mar 10, 2005 6:39 am    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Hi Tom,

Quote:
sudo /sbin/restorecon -R /var/lib/pgsql

worked like a charm!

Thank you very much!

Ulrich

--
Ulrich Wisser

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
________________________________________________________________
http://www.relevanttraffic.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Back to top
Ulrich Wisser
*nix forums beginner


Joined: 09 Mar 2005
Posts: 5

PostPosted: Thu Mar 10, 2005 6:38 am    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Lonni J Friedman wrote:

Quote:
selinux-policy-targeted-1.17.30-2.85

up2date insists that these packages are all up to date.


And you're certain that you're using the targetted policy and not strict?

To be frank, I am not. I have not the slightest idea what all that
selinux is about (beside security in general). I just went with the
default install and here I am.

Ulrich

--
Ulrich Wisser

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
________________________________________________________________
http://www.relevanttraffic.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Back to top
Ian Pilcher
*nix forums beginner


Joined: 09 Mar 2005
Posts: 39

PostPosted: Wed Mar 09, 2005 5:59 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Tom Lane wrote:
Quote:

One problem is that selinux-policy-targeted updates don't necessarily
propagate to the security labels of the individual files.

Sounds like it might be a good idea to add a trigger to the PostgreSQL
RPM to run restorecon when the SELinux policy is updated.

--
========================================================================
Ian Pilcher i.pilcher@comcast.net
========================================================================


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Back to top
Tom Lane
*nix forums Guru


Joined: 24 Mar 2005
Posts: 2070

PostPosted: Wed Mar 09, 2005 1:58 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Ulrich Wisser <ulrich.wisser@relevanttraffic.se> writes:
Quote:
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?

They should work together as long as you have the latest PG RPMs (which
it seems you do) and a reasonably recent selinux-policy-targeted.

One problem is that selinux-policy-targeted updates don't necessarily
propagate to the security labels of the individual files. I think what
you need to do here is
sudo /sbin/restorecon -R /var/lib/pgsql
to ensure that /var/lib/pgsql and all its contents are correctly labeled
per your current installed selinux policy. The reason for thinking
this is that your error message suggests that
/var/lib/pgsql/data/PG_VERSION is labeled root:object_r:var_lib_t,
which I think is the generic default for files under /var/lib,
while in my (working;-)) install it's labeled postgresql_db_t:
$ sudo ls -Z /var/lib/pgsql/data/PG_VERSION
-rw------- postgres postgres root:object_r:postgresql_db_t /var/lib/pgsql/data/PG_VERSION

There's some history and info about variant problems at
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Back to top
Ian Pilcher
*nix forums beginner


Joined: 09 Mar 2005
Posts: 39

PostPosted: Wed Mar 09, 2005 1:41 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Ulrich Wisser wrote:
Quote:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file

Try running 'restorecon -n -R -v /var/lib/pgsql'. If it suggests
changes that appear to make sense, run 'restorecon -R -v
/var/lib/pgsql'.

HTH

--
========================================================================
Ian Pilcher i.pilcher@comcast.net
========================================================================


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Back to top
Devrim GUNDUZ
*nix forums Guru Wannabe


Joined: 08 Mar 2005
Posts: 107

PostPosted: Wed Mar 09, 2005 1:28 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

Are you using the latest selinux_policy_targeted package? I mean, is your
system up2date?

Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:

Quote:
Hi,

it seems selinix doesn't like postgres. Can I uninstall selinux from fedora
savely? OR is there any way to make them both work together?

Here is my error message:

Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied {
read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file

Any ideas are welcome!

Thanks

Ulrich

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCLvoUtl86P3SPfQ4RAhtKAJ9PAU+3IjRq4oo032ZiXaL9omQmUgCffJ36
yTiQ1KHu33RGd6aHAdhqrWw=
=wKRE
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Back to top
Lonni J Friedman
*nix forums beginner


Joined: 03 Mar 2005
Posts: 28

PostPosted: Wed Mar 09, 2005 1:16 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
On Wed, 09 Mar 2005 14:38:06 +0100, Ulrich Wisser
<ulrich.wisser@relevanttraffic.se> wrote:
Quote:
Sorry,

of course I forgot to mention my installed version. Please find them below:

postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
postgresql-contrib-7.4.7-3.FC3.1
postgresql-python-7.4.7-3.FC3.1
postgresql-7.4.7-3.FC3.1
postgresql-pl-7.4.7-3.FC3.1
postgresql-server-7.4.7-3.FC3.1
postgresql-tcl-7.4.7-3.FC3.1
postgresql-libs-7.4.7-3.FC3.1
postgresql-docs-7.4.7-3.FC3.1

selinux-policy-targeted-1.17.30-2.85

up2date insists that these packages are all up to date.

And you're certain that you're using the targetted policy and not strict?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Back to top
Ulrich Wisser
*nix forums beginner


Joined: 09 Mar 2005
Posts: 5

PostPosted: Wed Mar 09, 2005 12:38 pm    Post subject: Re: Can't start PostgreSQL on Fedora Core3 Reply with quote
Sorry,

of course I forgot to mention my installed version. Please find them below:

postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
postgresql-contrib-7.4.7-3.FC3.1
postgresql-python-7.4.7-3.FC3.1
postgresql-7.4.7-3.FC3.1
postgresql-pl-7.4.7-3.FC3.1
postgresql-server-7.4.7-3.FC3.1
postgresql-tcl-7.4.7-3.FC3.1
postgresql-libs-7.4.7-3.FC3.1
postgresql-docs-7.4.7-3.FC3.1

selinux-policy-targeted-1.17.30-2.85

up2date insists that these packages are all up to date.

Ulrich

Devrim GUNDUZ wrote:
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

Are you using the latest selinux_policy_targeted package? I mean, is
your system up2date?

Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:

Hi,

it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?

Here is my error message:

Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc:
denied { read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION
dev=dm-1 ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file

Any ideas are welcome!

Thanks

Ulrich

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


- --
Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org,
devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCLvoUtl86P3SPfQ4RAhtKAJ9PAU+3IjRq4oo032ZiXaL9omQmUgCffJ36
yTiQ1KHu33RGd6aHAdhqrWw=
=wKRE
-----END PGP SIGNATURE-----


--
Ulrich Wisser

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
________________________________________________________________
http://www.relevanttraffic.com

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Back to top
Ulrich Wisser
*nix forums beginner


Joined: 09 Mar 2005
Posts: 5

PostPosted: Wed Mar 09, 2005 12:24 pm    Post subject: Can't start PostgreSQL on Fedora Core3 Reply with quote
Hi,

it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?

Here is my error message:

Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file

Any ideas are welcome!

Thanks

Ulrich

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [9 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 8:22 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts bind keyboard POWER button to start some program Vladi Lemurov Debian 1 Fri Jul 21, 2006 6:00 am
No new posts setting serial start value Greg Philpott PostgreSQL 4 Fri Jul 21, 2006 1:32 am
No new posts RE : Re: RE : Re: Problem with postfix-2.1.5+sasl2 on Fed... Lucienhélène DOSSEH Postfix 0 Thu Jul 20, 2006 12:12 pm
No new posts Install oracle9i release 9.2.0.4 on Fedora 4 Maricel Espejo Server 1 Thu Jul 20, 2006 11:55 am
No new posts Fedora 5 What is Beagle? Geico Caveman Setup 2 Thu Jul 20, 2006 5:10 am

Debt Consolidation | Personal Loans | Debt Consolidation | Bankruptcy | Buy Used Cell Phone
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2282s ][ Queries: 20 (0.0982s) ][ GZIP on - Debug on ]