Postgres Pro
Downloads
Home   >   mailing lists

Re: Connecting to Postgres using Rekall - Mailing list pgsql-general

From Tony Caduto
Subject Re: Connecting to Postgres using Rekall
Date
Msg-id 427BED1E.3000005@amsoftwaredesign.com
Whole thread Raw
In response to Connecting to Postgres using Rekall  (Susemail <susemail@hawaii.rr.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: elein@varlena.com (elein)
Date:
Subject: Re: inherit with foreign key reference
Next
From: Michael Glaesemann
Date:
Subject: Re: Duplicate key error when updating unique columns