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 ...
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 ...