restore crashes PG on Linux, works on Windows
От | Chris Curvey |
---|---|
Тема | restore crashes PG on Linux, works on Windows |
Дата | |
Msg-id | CADfwSsBZjwzTQcTq99f7EwtZ-qP4JW2GSHm0jFpv-c32qB2Kkg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: restore crashes PG on Linux, works on Windows
Re: restore crashes PG on Linux, works on Windows |
Список | pgsql-general |
I'm working with a vendor who is in the process of converting their system from "something else" to Postgres. Yay!
My vendor took a dump of our "something else" database (which runs on Windows), did their conversion to Postgres, and then sent me back a postgres dump (custom format) of the database for me to load onto my servers for testing.I suspect that the problem is related to the encoding specified in the database dump:
CREATE DATABASE "TestDatabase" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252';
So my questions for the brain trust are:
1) Would you expect this to work?
2) If I had to load this database on Linux, what would be the best way to go about it? (see if I can find that charset/encoding for Linux? Ask the vendor for a plain-text dump? )
В списке pgsql-general по дате отправления: