Thread: [BUGS] BUG #14779: Can't Backup Database

[BUGS] BUG #14779: Can't Backup Database

From
myprofmailbox@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      14779
Logged by:          AYMEN AMMAR
Email address:      myprofmailbox@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Windows Server 2008
Description:

Dear Sir,  I'm using Postgresql v9.3 with Odoo, and the company want to have an
arabic name for every database (company in Odoo).
I created four arabic separate databases (with arabic database name for each
one)...Until now everything goes well, but when i want to backup any
database i receive an error (uknown "?????" database). I think that the
problem is coming from pg_dump with utf8...i'm really blocked ...Do you have
any solution for that? Thank you in advance for help.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #14779: Can't Backup Database

From
Michael Paquier
Date:
On Tue, Aug 15, 2017 at 6:55 AM,  <myprofmailbox@gmail.com> wrote:
>    I'm using Postgresql v9.3 with Odoo, and the company want to have an
> arabic name for every database (company in Odoo).
> I created four arabic separate databases (with arabic database name for each
> one)...Until now everything goes well, but when i want to backup any
> database i receive an error (uknown "?????" database). I think that the
> problem is coming from pg_dump with utf8...i'm really blocked ...Do you have
> any solution for that? Thank you in advance for help.

You may want to use chcp 65001 before running pg_dump so the encoding
used by cmd is correct.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs