Re: BUG #7507: pg_restore silently fails when restoring a db with the --create flag and no user.

On Mon, Aug 27, 2012 at 03:34:10PM +0000, iann(at)fuelforce(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7507
> Logged by: Ian Nobile
> Email address: iann(at)fuelforce(dot)com
> PostgreSQL version: 9.1.4
> Operating system: Mac OS X Version 10.8
> Description:
>
> Attempting to restore a db using pg_restore to a new database server using
> the --create and --dbname flags fails silently if the db owner username does
> not exist in the new db or the -O flag is not used.
> Command used:
> pg_restore --create --verbose --dbname=testserver
> /Volumes/USBLINKS1/hostname.testserver.net_postgres_database

Well, I tried this and it showed a proper error:

$ pg_restore --create --verbose -U yy --dbname=testserver /rtmp/xx
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "testserver" failed:
FATAL: role "yy" does not exist

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +