Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z2hRi-0006si-3Y for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jun 2015 14:57:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z2hRh-0004pa-1C for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jun 2015 14:57:37 +0000 Received: from makus.postgresql.org ([174.143.35.229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z2hRb-0004ew-NG for pgsql-admin@postgresql.org; Wed, 10 Jun 2015 14:57:32 +0000 Received: from rs143.luxsci.com ([64.49.212.119]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z2hRX-0007Vd-Ok for pgsql-admin@postgresql.org; Wed, 10 Jun 2015 14:57:29 +0000 Received: from RSKPC (nsg-static-009.236.71.182.airtel.in [182.71.236.9] (may be forged)) (authenticated bits=0) by rs143.luxsci.com (8.14.4/8.14.9) with ESMTP id t5AEvI0E015945; Wed, 10 Jun 2015 10:57:24 -0400 Reply-To: From: "Saravanakumar Ramasamy" To: Cc: , Subject: invalid byte sequence for encoding "UTF8" Date: Wed, 10 Jun 2015 20:27:19 +0530 Organization: Zoniac Software Private Limited Message-ID: <000d01d0a38d$c4a1f910$4de5eb30$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01D0A3BB.DE5A3510" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AdCjjbo1d+kNh43qRXavT5q3P3IavA== Content-Language: en-us x-cr-hashedpuzzle: AMCx BaQi IxPt Lxj7 MQe8 Mf1i Micu NnR4 Pdx0 Q/ek TbDO ZHlg azlL bIqJ htzG iJJc; 3; cABnAHMAcQBsAC0AYQBkAG0AaQBuAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnADsAcgBzAGsAQAB6AG8AbgBpAGEAYwAuAGMAbwBtADsAcwBlAG4AdABoAGkAbABAAHoAbwBuAGkAYQBjAC4AYwBvAG0A; Sosha1_v1; 7; {E2D8259C-6720-42D0-8750-AF55D7E5F501}; cgBzAGsAQAB6AG8AbgBpAGEAYwAuAGMAbwBtAA==; Wed, 10 Jun 2015 14:57:10 GMT; aQBuAHYAYQBsAGkAZAAgAGIAeQB0AGUAIABzAGUAcQB1AGUAbgBjAGUAIABmAG8AcgAgAGUAbgBjAG8AZABpAG4AZwAgACIAVQBUAEYAOAAiAA== x-cr-puzzleid: {E2D8259C-6720-42D0-8750-AF55D7E5F501} X-Lux-Comment: Message t5AEvI0E015945 sent by user #78808 X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_000E_01D0A3BB.DE5A3510 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_000E_01D0A3BB.DE5A3510 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All.

         &= nbsp;      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          =             &= nbsp;   :  CentOS 5.2

Postgres Conf  :

         &= nbsp;           &n= bsp;          = client_encoding =3D default value

 

         &= nbsp; =             &= nbsp;           &n= bsp; List of databases

         &= nbsp; Name           = |  Owner   | Encoding  | Collate | Ctype |   Access privileges

--------------------------+----------+-----------+-----= ----+-------+-----------------------

 postgres       = ;          | postgres | = SQL_ASCII | C       | C     |

 rsk       &nbs= p;            = ;        | xxxxx  =      | SQL_ASCII | C       | C     = |

 template0      &nbs= p;      | postgres | SQL_ASCII | = C       | C     | =3Dc/postgres + = postgres=3DCTc/postgres

 template1      &nbs= p;      | postgres | SQL_ASCII | = C       | C     | =3Dc/postgres + = postgres=3DCTc/postgres

 

Query

-----

rsk=3D# select columnname from = tablename;

 

Status

=3D=3D=3D=3D=3D=3D=3D

         &= nbsp;      Query is working = file;

 

Get the export database following = command

# pg_dump --host "localhost" --port "5432" --username "xxxxx" "DBnameXXX" > filenameXXX.sql

 

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D

 

After upgrade In Postgres 9.4.3

#--------------------------------#

Problem 1 :

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

OS : CentOS 7.0

Postgres Conf :

         &= nbsp;           &n= bsp;          = client_encoding =3D default value

 

import databse using

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

# psql template1 xxxxx

     template1=3D# create = database DBnameXXX;

     template1=3D# \q =

# psql DBnameXXX xxxxx

     rsk=3D# \i = filenameXXX.sql

 

         &= nbsp;           &n= bsp;           &nb= sp;  List of databases

      = Name       |  Owner   | = Encoding  |  Collate   |   Ctype    |   Access privileges

-----------------+----------+-----------+------------+-= -----------+-----------------------

 postgres       = ; | postgres | SQL_ASCII | en_US.utf8 | en_US.utf8 |

 rsk       &nbs= p;            | = xxxxx      | SQL_ASCII | en_US.utf8 | en_US.utf8 |

 template0     | postgres = | SQL_ASCII | en_US.utf8 | en_US.utf8 | =3Dc/postgres  +  = postgres=3DCTc/postgres

 template1     | postgres = | SQL_ASCII | en_US.utf8 | en_US.utf8 | =3Dc/postgres  +  = postgres=3DCTc/postgres

 

 

rsk=3D# select columnname from = tablename;

we are getting error like this,

         &= nbsp;      ERROR:  invalid byte sequence = for encoding "UTF8": 0xd9 0x30

         &= nbsp;      ERROR:  invalid byte sequence = for encoding "UTF8": 0x80

         &= nbsp;      ERROR:  invalid byte sequence = for encoding "UTF8": 0xa2

         &= nbsp;      ERROR:  invalid byte sequence = for encoding "UTF8": 0x98

         &= nbsp;      ERROR:  invalid byte sequence = for encoding "UTF8": 0x92

 

how to sovle probleam, if any configuration chnage. = please let me know

 

With Regards,

Saravanakumar Ramasamy.

 

 

------=_NextPart_000_000E_01D0A3BB.DE5A3510--