« Créer un miroir local avec apt-mirror
Installation Ruby on Rails »


postgreSQL 8.3 sous Debian etch

Il faut ajouter les backports dans le source.list

# nano /etc/apt/sources.list

Ajouter ceci dans le fichier :

deb http://www.backports.org/debian etch-backports main

Installer le paquet :

# apt-get install -t etch-backports postgresql postgresql-client

# apt-get install postgresql-contrib -t etch-backports

# nano /etc/postgresql/8.3/main/pg_hba.conf


local all postgres ident sameuser
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5

postgres=# alter user postgres with password 'XXXX';

psql -d postgres < /usr/share/postgresql/8.3/contrib/adminpack.sql (pgadmin function)

#nano /etc/postgresql/8.3/main/pg_hba.conf

#nano /etc/postgresql/8.3/main/postgresql.conf

listen_addresses = '*'



Leave a Reply

You must be logged in to post a comment.