Обсуждение: Issue while non-english character in userid and password
Hi Team,
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.
Regards
Manadeep
"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 haveused non-English character í, with this userid and password we are able to connect the database but when we try to runthe backup for same db using pg_dump utility it fails saying error as "password authentication failed". Please let usknow 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 Dbit for SQL queries it works but when I try to run backup using pgAdmin(which internally run pg_dump) it still gives mesame 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 haveused non-English character í, with this userid and password we are able to connect the database but when we try to runthe backup for same db using pg_dump utility it fails saying error as "password authentication failed". Please let usknow 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 thosecharacters are always sent the same way in connection requests. Postgres can't do any encoding conversion on connectionrequests since it doesn't know what character set the client is using. Presumably what's happening here is thatthe backup script isn't running with the same code page you used when creating the password. regards, tom lane