From: | "Saravanakumar Ramasamy" <rsk(at)zoniac(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Cc: | <senthil(at)zoniac(dot)com>, <rsk(at)zoniac(dot)com> |
Subject: | invalid byte sequence for encoding "UTF8" |
Date: | 2015-06-10 14:57:19 |
Message-ID: | 000d01d0a38d$c4a1f910$4de5eb30$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All.
Now I am using postgres 9.4.3 version. Before I am used
9.1.3 after I upgraded 9.4.3. Upgraded was successfully completed.
In Postgres 9.1.3
#------------------#
OS : CentOS 5.2
Postgres Conf :
client_encoding = default value
List of databases
Name | Owner | Encoding | Collate | Ctype |
Access privileges
--------------------------+----------+-----------+---------+-------+--------
---------------
postgres | postgres | SQL_ASCII | C | C |
rsk | xxxxx | SQL_ASCII | C | C
|
template0 | postgres | SQL_ASCII | C | C |
=c/postgres + postgres=CTc/postgres
template1 | postgres | SQL_ASCII | C | C |
=c/postgres + postgres=CTc/postgres
Query
-----
rsk=# select columnname from tablename;
Status
=======
Query is working file;
Get the export database following command
# pg_dump --host "localhost" --port "5432" --username "xxxxx" "DBnameXXX" >
filenameXXX.sql
============================================================================
================================================
After upgrade In Postgres 9.4.3
#--------------------------------#
Problem 1 :
===========
OS : CentOS 7.0
Postgres Conf :
client_encoding = default value
import databse using
=================
# psql template1 xxxxx
template1=# create database DBnameXXX;
template1=# \q
# psql DBnameXXX xxxxx
rsk=# \i filenameXXX.sql
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------------+----------+-----------+------------+------------+---------
--------------
postgres | postgres | SQL_ASCII | en_US.utf8 | en_US.utf8 |
rsk | xxxxx | SQL_ASCII | en_US.utf8 | en_US.utf8 |
template0 | postgres | SQL_ASCII | en_US.utf8 | en_US.utf8 |
=c/postgres + postgres=CTc/postgres
template1 | postgres | SQL_ASCII | en_US.utf8 | en_US.utf8 |
=c/postgres + postgres=CTc/postgres
rsk=# select columnname from tablename;
we are getting error like this,
ERROR: invalid byte sequence for encoding "UTF8": 0xd9 0x30
ERROR: invalid byte sequence for encoding "UTF8": 0x80
ERROR: invalid byte sequence for encoding "UTF8": 0xa2
ERROR: invalid byte sequence for encoding "UTF8": 0x98
ERROR: invalid byte sequence for encoding "UTF8": 0x92
how to sovle probleam, if any configuration chnage. please let me know
With Regards,
Saravanakumar Ramasamy.
From | Date | Subject | |
---|---|---|---|
Next Message | Ronaldlee Ejalu | 2015-06-10 18:49:43 | SQL State 42P01 |
Previous Message | Devrim GÜNDÜZ | 2015-06-10 13:00:59 | Re: barman binary not working properly |