LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Password
Fedora This forum is for the discussion of the Fedora Project.

Notices


Reply
  Search this Thread
Old 08-19-2006, 04:24 PM   #1
HeyAZ
LQ Newbie
 
Registered: Aug 2006
Posts: 29

Rep: Reputation: 15
pgadmin postgresql install


Installed Fedora core 5 and now want postgresql with pgadmin up and running. On Windows this was so easy... Went to postgresql.org for installation tutorial, no help with rpm's.

On pirut have all sorts of postgresql stuff installed, so how do I even begin? How do I get pgadmin in there? No icon to click. 'yum install postgresql' came back with nothing. How do I start this program? Newbie, need step by step by step. Thanks!
 
Old 08-19-2006, 04:37 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 18,322

Rep: Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596Reputation: 2596
Try this link.
http://idancameron.com/pages/how-to-...r-fedoralinux/
 
Old 08-19-2006, 05:56 PM   #3
HeyAZ
LQ Newbie
 
Registered: Aug 2006
Posts: 29

Original Poster
Rep: Reputation: 15
still not working

Went to this website, working from terminal: su to be the root user, then
vi /var/lib/pgsql/data/postgresql.conf
Result: lots of blank lines starting with ~ and then with INSERT at the bottom. OK, lets type in: change tcpip_socket = true
& hit return: no response. Did it work? No idea so lets go edit that file directly, except we cannot open it; log off, log back in as root.

Next question: which pgsql conf file to edit? There are 2. Right-click to open with text editor gedit: "Could not open the
file /var/lib/pgsql/data/.postgresql.conf.swp." The word processor opens (Open Office) but the file is mostly # characters and then "change tcpip_socket = true#" at the bottom. Does this mean the file is somehow correct? How to edit properly?

Next, the website directs to change/ add lines to a file which is not there:
/var/lib/pgsql/data/pg_hba.conf

Next, test from command line terminal:
“service postgresql start”. No initializing nor starting: get failed.

If there are any other websites with step-by-step newbie instructions, appreciated; thanks.
 
Old 08-19-2006, 06:25 PM   #4
HeyAZ
LQ Newbie
 
Registered: Aug 2006
Posts: 29

Original Poster
Rep: Reputation: 15
website for postgresql install

http://www.globusconsortium.org/tutorial/ch4/page_1.php
 
Old 08-19-2006, 07:55 PM   #5
HeyAZ
LQ Newbie
 
Registered: Aug 2006
Posts: 29

Original Poster
Rep: Reputation: 15
update

Hi! Whoever may be following thread, that Globus Consortium website doesn't seem correct.
U of Florida has pretty-good instructions:
http://www.flmnh.ufl.edu/linux/install_postgresql.htm
 
Old 12-22-2009, 02:40 PM   #6
Ramon.Talavera
LQ Newbie
 
Registered: Dec 2009
Posts: 2

Rep: Reputation: 0
Pgadmin

If you are trying to connect from PGADMIN (pgadmin3) and have only set local connections up as trusted, have in mind that you need not filling the host field at all (DO NOT PUT 127.0.0.1) just leave it blank.
Name: LOCAL
Host:
Port: 5432
Username: postgres
maintenance DB postgres/template1 depends on your previous config.

Tested on Fedora 12
Enjoy.
 
  


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
How to install PostgreSQL 8.1.2 RPMS manually thick_guy_9 SUSE / openSUSE 1 03-14-2006 08:46 AM
I need help! pgAdmin make fails dickgregory Linux - Software 1 09-27-2005 12:55 PM
Error connecting to postgres with pgAdmin koswo Linux - Software 1 02-10-2004 07:45 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
postgresql fresh install jrocha Linux - Software 0 05-10-2001 03:21 AM

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

All times are GMT -5. The time now is 11:36 PM.

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