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