Issue while non-english character in userid and password

"Jadhav, Manadeep (BHGE)" <Manadeep.Jadhav@bhge.com> writes:

We are using postgres server install on windows 7 32 bit machine in Spanish and for database username and password we have used non-English character í, with this userid and password we are able to connect the database but when we try to run the backup for same db using pg_dump utility it fails saying error as "password authentication failed". Please let us know how can we handle this issue.

If you use characters outside the base ASCII set in user or database names
or passwords, it's up to you to ensure that those characters are always
sent the same way in connection requests. Postgres can't do any encoding
conversion on connection requests since it doesn't know what character set
the client is using. Presumably what's happening here is that the backup
script isn't running with the same code page you used when creating the
password.

regards, tom lane

Thanks Tom for replying on this issue but I face same issue while using pgAdmin also. When we use pgAdmin to connect to Db it for SQL queries it works but when I try to run backup using pgAdmin(which internally run pg_dump) it still gives me same error, so do you think still think it could be difference code page problem?

Regards
Manadeep

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, January 17, 2019 8:50 PM
To: Jadhav, Manadeep (BHGE) <Manadeep.Jadhav@bhge.com>
Cc: pgsql-bugs@postgresql.org; Periyaswamy, Balakrishnan (BHGE, Non-GE) <balakrishnan.periyaswamy@bhge.com>; Sabale, Sachin (BHGE) <Sachin.Sabale@bhge.com>; Kapoor, Chandan I (BHGE) <chandan.kapoor@bhge.com>
Subject: EXT: Re: Issue while non-english character in userid and password

"Jadhav, Manadeep (BHGE)" <Manadeep.Jadhav@bhge.com> writes:

We are using postgres server install on windows 7 32 bit machine in Spanish and for database username and password we have used non-English character í, with this userid and password we are able to connect the database but when we try to run the backup for same db using pg_dump utility it fails saying error as "password authentication failed". Please let us know how can we handle this issue.

If you use characters outside the base ASCII set in user or database names or passwords, it's up to you to ensure that those characters are always sent the same way in connection requests. Postgres can't do any encoding conversion on connection requests since it doesn't know what character set the client is using. Presumably what's happening here is that the backup script isn't running with the same code page you used when creating the password.

regards, tom lane