[CB-lug] configurare postgres

[Francesco Steno]

Il giorno 08/ott/07, alle ore 16:08, angelo morrone ha scritto:

> grazie adesso ho avviato  il server.

bene

> ma se provo ad installare il database di promo gest mi da errore. i  
> passi che ho fatto sono:
> 1 /etc/init.d/postgresql  start
> Starting  
> PostgreSQL                                                  done
> 2su postgres
> postgres@linux-suse:/home/angelo/Scaricati/PromoGest/install_db>  
> createuser angelo
> Shall the new role be a superuser? (s/n) s
> CREATE ROLE
> postgres@linux-suse:/home/angelo/Scaricati/PromoGest/install_db> exit
> exit
> 3 ./install_db.sh
> psql: FATAL:  Ident authentication failed for user "postgres"
> psql: FATAL:  Ident authentication failed for user "angelo"
> createlang: impossibile connettersi al database promogest_nightly:  
> FATAL:  Ident authentication failed for user "postgres"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"
> psql: FATAL:  Ident authentication failed for user "angelo"


:~> psql -l   [ ti mostra la lista degli utenti]

se l'utente non esiste devi provare a crearlo a mano

Modifica il file pg_hba.conf , inserendo questi valori:

host promogest_db promoadmin 127.0.0.1 255.255.255.0 trust

e poi riavvia il servizio

controlla l'effettiva creazione dell'utente con il comando:

:~> psql -l   [ ti mostra la lista degli utenti]


Saluti
	Franesco Steno aka "oVERDRIVE"


--
Neil Armstrong, appena arrivato sulla Luna, ha trovato un post-it con  
scritto "Chuck Norris was here".

-=-=-=-=-=-=-=-=-=-=-=-=-=-generated by /dev/over-=-=-=-=-=-=-=-=-=-=
                                  oVERDRIVE
<overdrive@OpenGeeks.it><overdrive@BitchX.it><overdrive@Linux.it>
              GnuPG Public Key: http://cb.linux.it/lug/key/overdrive.asc
  Key Fingerprint: 146A E13D 9E68 3B96 40FB  11F5 9A10 2D1F 3973 C203