Re: pg_restore : ident authentication problem - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: pg_restore : ident authentication problem
Date
Msg-id 20020910143238.V7504@mail.libertyrms.com
Whole thread Raw
In response to pg_restore : ident authentication problem  ("Paul Tuohy" <pablo_100@hotmail.com>)
List pgsql-admin
On Tue, Sep 10, 2002 at 05:29:26PM +0000, Paul Tuohy wrote:
>
> pg_restore: [archiver (db)] could not reconnect to database FATAL 1: IDENT
> authentication failed for user <<username>>
>
> i have at least tried most of the pg_restore options, as well relaxing all
> permissions in pg_hba.conf and pg_ident.conf. tried running pg_restore as

But did you (a) get rid of ident authentication and (b) remember to
HUP the postmaster?  7.2 and forward don't read the pg_hba.conf file
unless they receive SIGHUP.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Ragnar Kjørstad
Date:
Subject: Re: fsync or fdatasync
Next
From: Tom Lane
Date:
Subject: Re: fsync or fdatasync