PDA

View Full Version : Installing PostGreSQL 8.4.x on a NEW Fedora Linux



ZeBoulet
03-28-2010, 06:51 AM
Hi !
This is a quick step HowTo Installing PostGreSQL 8.4.x on a NEW Fedora Linux


1) DL Latest Fedora ISO complete DVD
Will not say how to install/configure a linux
2) Select costumise package (or some thing like that), and search PostgreSQL and select it for Installation.
4) Installed all in French, would be better english with KB in french. Anyhow ...
5) Install is going.

Now :
Need to be done before :
- Network settings
- Desable firewall (non secure)

6) Configure PostgreSQL 8.4 Database Server
- Initialize the cluster first with initdb command:

# service postgresql initdb

(Note : This will not make PostGreSQL start automatically at boot, u will have to use "service postgresql start" commant eatch time, willl update this post)

7) Edit /var/lib/pgsql/data/postgresql.conf file
Set PostgreSQL server to listen all addresses. Add/Uncomment/Edit following lines:

listen_addressses = '*'
port = 5432


8) Edit /var/lib/pgsql/data/pg_hba.conf file:
Add (example) your local network with trust passwords, what i did (non secure) this my my windows HM computer :

# Local networks
host all all 192.168.0.1/32 trust


9) Start/Restart PostgreSQL Server:
service postgresql start

Here, u should have no problem (i had none) PgSQL started.


10) testing connexion via my HM DB Controle Panel
Then, just play

11) do not apply tips for PostgreSQL 8.3, it makes my SQL crash at start.
Will fixe that and Update.


Will update this post with perf tips
and firewall settings
and access ur Linux DB over Internet.

Regards

ZeBoulet


P.S. My slow computer is now more OK with no PostGreSQL on it, there for, still slow to import ...

morny
03-28-2010, 11:50 AM
Thanks ill get this added to a FAQ, if you want i can quote your username in the FAQ to give credit to you but the downside is you might get PMs about it occassionaly, let me know either way

ZeBoulet
03-28-2010, 12:58 PM
Hi,
OK for FAQ but later,
Let me update this post a few times and correct the english, and when it's good, u can.
And u can put my name, we will see ;-)

See ya Next time
ZeBoulet

morny
03-28-2010, 03:01 PM
ok just bump this when its ready