Thread: BUG #15498: Pg_Dump failed if Database name contains specialcharacters(non english).

BUG #15498: Pg_Dump failed if Database name contains specialcharacters(non english).

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      15498
Logged by:          vinod viswanath
Email address:      vtvkerala@gmail.com
PostgreSQL version: 9.6.10
Operating system:   Windows 10
Description:

I have created a data base example: "Química" this contains an italian
letter "í"

When i created the pgdump using command line

--host 127.0.0.1 --port 7555 --username postgres --format=d --verbose
--jobs=10 --compress 9 --file "C:\Delete\Archive" --dbname "Química"
--schema "Archive_TVT"

I was getting error 
"pg_dump: [archiver (db)] connection to database "Quφmica" failed: FATAL:
database "Quφmica" does not exist."
i am using windows 10 English OS, postgre version 9.6.10 .
Please help here.


Hello

Maybe you have "create database Química;" instead of "create database "Química";"? In this case you have database
"química",not "Química".
 
Can you check it with psql \l command?

regards, Sergei