LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Networking (https://www.linuxquestions.org/questions/linux-networking-3/)
-   -   fedora 11 postgresql problems (https://www.linuxquestions.org/questions/linux-networking-3/fedora-11-postgresql-problems-738580/)

chickenlinux 07-08-2009 06:45 AM

fedora 11 postgresql problems
 
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 07:11 AM

Quote:

Originally Posted by chickenlinux (Post 3600806)
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 08: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

chickenlinux 07-08-2009 08:22 PM

Hmmm... that wasn't the problem it seems. I tried init-ing like the guide says as user postgres... should I try building postgresql from source?

chickenlinux 07-08-2009 08:32 PM

AHA! following this guide (http://www.mkyong.com/database/how-t...n-fedora-core/) seems to work, but I have to make a postgres user manually...


All times are GMT -5. The time now is 09:12 AM.