INSTALACION DE POSTGRES EN OPENSUSE

$ sudo su

# zypper install -y postgresql postgresql-server

# rcpostgresql start

# su – postgres

# psql

postgres=# ALTER USER postgres WITH PASSWORD 'postgres';

postgres=# \q

$ sudo su

# rcpostgresql restart

# su - postgres

In file /var/lib/pgsql/data/pg_hba.conf you should replace peer and ident authentication method with trust method, so this lines:

# "local" is for Unix domain socket connections only

local all all peer

# IPv4 local connections:

host all all 127.0.0.1/32 ident

… should be replaced on:

# "local" is for Unix domain socket connections only

local all all trust

# IPv4 local connections:

host all all 127.0.0.1/32 trust

Command belows should do this replacing (logged as postgres):

$ sed -i "s/local all all peer/local all all trust/g" /var/lib/pgsql/data/pg_hba.conf

$ sed -i "s/host all all 127.0.0.1\/32 ident/host all all 127.0.0.1\/32 trust/g" /var/lib/pgsql/data/pg_hba.conf

Finally, login as root and restart server:

sudo su

rcpostgrsql restart

Instalación de pgadmin

zypper install pgadmin3

pgadmin3

Fuente: http://blog.milczarek.it/2012/09/install-postgresql-on-opensuse-12-1/