From: | Florian Weimer <Weimer(at)CERT(dot)Uni-Stuttgart(dot)DE> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_restore and permissions |
Date: | 2002-04-25 16:08:07 |
Message-ID: | 87vgafu5g8.fsf@CERT.Uni-Stuttgart.DE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)CERT(dot)Uni-Stuttgart(dot)DE
University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT +49-711-685-5973/fax +49-711-685-5898
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-04-25 16:16:22 | Re: pg_restore and permissions |
Previous Message | Tom Lane | 2002-04-25 14:04:58 | Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database |