Hi Jerome, You need to edit the pg_hba.conf file which controls the hosts Postgres will allow to connect. By default it's set to only allow connections from local host.
pg_hba.conf is located in the data directory of where you installed PG.
You can also tell a host to be TRUSTED, i.e no password needed, if you have not defined any databases yet you might want to set it to TRUST so you can connect to template1, then from there you can create a new database.
When I try to connect to the PostgreSQL server I get this message:FATAL: Ident authentication failed for user "postgres". Anyone know why this is happening?
Thanks,
Jerome
-- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
