LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora > Fedora - Installation
User Name
Password
Fedora - Installation This forum is for the discussion of installation issues with Fedora.

Notices


Reply
  Search this Thread
Old 01-07-2008, 10:06 AM   #1
colinchiang
LQ Newbie
 
Registered: Jan 2008
Posts: 1

Rep: Reputation: 0
Fedora and Postgresql


I installed Fedora 8 and then intalled Postgresql 8.2.5. Initially, the service did not start However, according to the error message, I ran the command service postgresql initdb. The service started. But I cannot login the server using pgAdmin due to incorrect password.

During the installation process, there was no question for postgresql role to be created. Would anyone know the problem advise me that:

Either:
1. There is a default role installed, kindly advise the default role and password.

or
2. If I need to create a role, kindly advise how as I tried psql and service postgresql without success.

or
3. There should be setup of the first role during installation, kindly advise how can I do it. At my current situation, do I uninstall Postgresql and reinstall again to let the installation ask me the first role setup.

Thanks you very much in advance.

Colin Chiang
 
Old 01-07-2008, 03:38 PM   #2
thedonkdonk
Member
 
Registered: Oct 2005
Location: San Antonio, TX
Distribution: Fedora, RHEL 6, CentOS 6, Debian 6, Arch, Gentoo
Posts: 136

Rep: Reputation: 16
It depends on how you installed postgresql. If you used an rpm then it will usually make a postgres user. If you installed from source then you need to make a postgres user. So cat the /etc/passwd file and look for a user named postgres. If its not there make one. Then use su to change to the postgres user. For more information take a look at http://www.postgresql.org/docs/8.2/i...-hba-conf.html
 
  


Reply


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 thinker Red Hat 7 12-05-2006 03:39 PM
PostgreSql coolrock Slackware 4 10-04-2006 10:24 AM
How to auto start Postgresql 8.0.7 on Fedora 5 ttphuong82 Fedora 1 08-24-2006 10:02 AM
need help in postgresql yawhum80 Linux - Newbie 0 10-28-2003 10:03 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora > Fedora - Installation

All times are GMT -5. The time now is 04:27 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration