pg_restore : ident authentication problem

From: "Paul Tuohy" <pablo_100(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_restore : ident authentication problem
Date: 2002-09-10 17:29:26
Message-ID: F67TvhL1MfvqFJb9n5V000011f9@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

i am running postgres 7.2.1 on two machines running debian. i create a dump
file from one using basic options like:

pg_dump -C -F c -f <<filename>> <<database>>

copy this file to my other machine and run:

pg_restore -C -F c -d template1 <<filename>>

during restoration i get an error message that reads

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
different users (i.e. postgres or the future restored database owner). tried
the -W option to manually authenticate. tried -O to override permissions
altogether. tried various combinations using -S <<superuser>>, -r and -X.
the second system is practically a mirror image of the first as lists all
the same users. nevertheless, keep receiving this authentication error
message.

can work around it but would rather understand the problem.
does anyone have the answer?

pablo

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-09-10 17:33:20 Re: how can i get free space for database?
Previous Message Ragnar Kjørstad 2002-09-10 17:28:18 Re: fsync or fdatasync