fedora 11 postgresql problems

chickenlinux · 07-08-2009, 07:45 AM

I would like to set up a postgresql server on my 64-bit fedora 11 box. I install all the packages necessary, and find the service has not started itself.
I tried starting it with the GUI, but it wouldn't seem to start, so I created a pg_hba.conf, which, if it existed before, was blank. It didn't work so I removed it.
I tried starting postgres manually:

Code:

# service postgresql start

now it says I need to run

Code:

# service postgresql initdb

That fails too...

I tried again, and got this pg_log folder which gets in my way so I removed it, same deal, fails... AGAIN.

I'm really sort of a PostgreSQL noob, so I'd appreciate any help whatsoever.

centosboy · 07-08-2009, 08:11 AM

Quote:

Originally Posted by chickenlinux

I would like to set up a postgresql server on my 64-bit fedora 11 box. I install all the packages necessary, and find the service has not started itself.
I tried starting it with the GUI, but it wouldn't seem to start, so I created a pg_hba.conf, which, if it existed before, was blank. It didn't work so I removed it.
I tried starting postgres manually:

Code:

# service postgresql start

now it says I need to run

Code:

# service postgresql initdb

That fails too...

I tried again, and got this pg_log folder which gets in my way so I removed it, same deal, fails... AGAIN.

I'm really sort of a PostgreSQL noob, so I'd appreciate any help whatsoever.

initialising psql is nicely documented here

Code:

www.faqs.org/docs/ppbook/x486.htm

chickenlinux · 07-08-2009, 09:18 PM

well, that guide was slightly outdated, and was more for installing postgresql, not configuring or starting it (although it did have some information as to such but it was nothing new.)

I appreciate you sending it to me though!

I think the problem is that I can't initdb as root, but if I try as a normal user, I can't initdb because of lack of permissions... I'll play with it... get back to yall