LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 07-08-2009, 07:45 AM   #1
chickenlinux
Member
 
Registered: Mar 2008
Location: Here - Where else?
Distribution: Fedora 12, Arch Linux (updated daily =D)
Posts: 270

Rep: Reputation: 31
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.
 
Old 07-08-2009, 08:11 AM   #2
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by chickenlinux View Post
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
 
Old 07-08-2009, 09:18 PM   #3
chickenlinux
Member
 
Registered: Mar 2008
Location: Here - Where else?
Distribution: Fedora 12, Arch Linux (updated daily =D)
Posts: 270

Original Poster
Rep: Reputation: 31
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
 
Old 07-08-2009, 09:22 PM   #4
chickenlinux
Member
 
Registered: Mar 2008
Location: Here - Where else?
Distribution: Fedora 12, Arch Linux (updated daily =D)
Posts: 270

Original Poster
Rep: Reputation: 31
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?
 
Old 07-08-2009, 09:32 PM   #5
chickenlinux
Member
 
Registered: Mar 2008
Location: Here - Where else?
Distribution: Fedora 12, Arch Linux (updated daily =D)
Posts: 270

Original Poster
Rep: Reputation: 31
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...
 
  


Reply

Tags
fedora, postgres, postgresql, service


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Postgresql Setting Problems in ubuntu 5.04 luisben Ubuntu 1 05-09-2008 04:18 AM
Fedora and Postgresql colinchiang Fedora - Installation 1 01-07-2008 04:38 PM
How to auto start Postgresql 8.0.7 on Fedora 5 ttphuong82 Fedora 1 08-24-2006 11:02 AM
Problems setting up PostgreSQL entheogen Linux - Software 0 08-30-2004 09:23 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM


All times are GMT -5. The time now is 09:41 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration