Re: pg_restore and permissions

That should work.  Because of the error, I wonder if your OS doesn't
support local/indent authentication.  Can you psql into template1 as
that user?

---------------------------------------------------------------------------

Florian Weimer wrote:
> Is there a simple way to restore a databases from a pg_dump file?
> I've got a "pg_dump -F c" from version 7.1.3 and would like to restore
> it on a 7.2.1 database server.
>
> However, if I invoke, say, "pg_restore -C -d web web.db", I get the
> following error message:
>
> pg_restore: [archiver (db)] could not reconnect to database: FATAL 1:  IDENT authentication failed for user
"www-data"
>
> My pg_hba.conf looks like this:
>
> local        all                                           ident sameuser
> host         all         127.0.0.1     255.0.0.0           ident sameuser
> host         all         0.0.0.0       0.0.0.0             reject
>
> I know how to work around this problem (and did it in the past), but
> I'd really like to be able to restore a database using a single
> command.  Does such a command exist?
>
> --
> Florian Weimer                       Weimer@CERT.Uni-Stuttgart.DE
> University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
> RUS-CERT                          +49-711-685-5973/fax +49-711-685-5898
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026