| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Susemail <susemail(at)hawaii(dot)rr(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Connecting to Postgres using Rekall |
| Date: | 2005-05-06 22:18:06 |
| Message-ID: | 427BED1E.3000005@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wayne schlemitz | 2005-05-07 01:41:01 | starting |
| Previous Message | Scott Marlowe | 2005-05-06 21:21:24 | Re: inherit with foreign key reference |