On Aug 11, 2015, at 8:59 AM, Prasanth Reddy <dbadmin@xxxxxxxxxxx> wrote: > > The server uses SQL_ASCII encoding and the > client encoding is UTF8. There are some invalid characters in the database but this has not caused a problem in the current version or 9.3 (tried a restore in 9.3 and the application works fine). Later versions of PostgreSQL do better checking of UTF-8, and disallow invalid sequences. You're going to have to straighten out your encoding conflicts. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin