Re: Refactor handling of database attributes between pg_dump and pg_dumpall

On 03/29/2017 05:43 AM, Haribabu Kommi wrote:
> Updated patch attached.

I get a test failure in the pg_upgrade tests, but I do not have time
right now to investigate.

The failing test is "Restoring database schemas in the new cluster".

I get the following in the log:

command:
"/home/andreas/dev/postgresql/src/bin/pg_upgrade/tmp_check/install//home/andreas/dev/postgresql-inst/bin/pg_dump"
--host /home/andreas/dev/postgresql/src/bin/pg_upgrade --port 50848
--username andreas --schema-only --quote-all-identifiers
--binary-upgrade --format=custom --file="pg_upgrade_dump_16385.custom"
'dbname='"'"'./0123456789:;<=>?(at)ABCDEFGHIJKLMNOPQRSTUVWXYZ'"'"'' >>
"pg_upgrade_dump_16385.log" 2>&1

command:
"/home/andreas/dev/postgresql/src/bin/pg_upgrade/tmp_check/install//home/andreas/dev/postgresql-inst/bin/pg_restore"
--host /home/andreas/dev/postgresql/src/bin/pg_upgrade --port 50848
--username andreas --exit-on-error --verbose --dbname
'dbname='"'"'./0123456789:;<=>?(at)ABCDEFGHIJKLMNOPQRSTUVWXYZ'"'"''
"pg_upgrade_dump_16385.custom" >> "pg_upgrade_dump_16385.log" 2>&1
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database
"./0123456789:;<=>?(at)ABCDEFGHIJKLMNOPQRSTUVWXYZ" failed: FATAL: database
"./0123456789:;<=>?(at)ABCDEFGHIJKLMNOPQRSTUVWXYZ" does not exist

Andreas