pg_dump/pg_restore fail for TAR_DUMP and CUSTOM_DUMP from v94/v95/v96 to v11/master.

Hi,

I got a failure in pg_dump/pg_restore as below:
pg_dump/pg_restore fails with 'ERROR: schema "public" already exists' for
TAR_DUMP and CUSTOM_DUMP from v94/v95/v96 to v11/master.

-- Take pg_dump in v94/v95/v96:
[prabhat(at)localhost bin]$ ./pg_dump -f /tmp/*tar_dump_PG94.tar* -Ft postgres
-p 9000
[prabhat(at)localhost bin]$ ./pg_dump -f /tmp/*custom_dump_PG94.sql* -Fc
postgres -p 9000

-- Try to restore the above dump into v11/master:
[prabhat(at)localhost bin]$ ./pg_restore -F t -U prabhat -d db3 -p 9001 /tmp/
*tar_dump_PG94.tar*
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6; 2615 2200 SCHEMA public
prabhat
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"public" already exists
Command was: CREATE SCHEMA public;

WARNING: errors ignored on restore: 1

[prabhat(at)localhost bin]$ ./pg_restore -F c -U prabhat -d db4 -p 9001 /tmp/
*custom_dump_PG94.sql*
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6; 2615 2200 SCHEMA public
prabhat
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"public" already exists
Command was: CREATE SCHEMA public;

WARNING: errors ignored on restore: 1

Note: I am able to perform "Plain dump/restore" across the branches.

--

With Regards,

Prabhat Kumar Sahu
Skype ID: prabhat.sahu1984
EnterpriseDB Corporation

The Postgres Database Company