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
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 |