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 [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
