Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C8EF01337BA2 for ; Mon, 13 Dec 2010 12:46:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 74224-09 for ; Mon, 13 Dec 2010 16:46:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web114719.mail.gq1.yahoo.com (web114719.mail.gq1.yahoo.com [98.136.183.146]) by mail.postgresql.org (Postfix) with SMTP id 353EA1337B88 for ; Mon, 13 Dec 2010 12:46:16 -0400 (AST) Received: (qmail 35087 invoked by uid 60001); 13 Dec 2010 16:46:14 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s1024; t=1292258774; bh=vDHESeyMQnF7VhFWqakgxKMs7jPcAvQUCMt2FCn7vOY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=3nIQ0Xoxur3UH9FooohZTWUEy8G8pwNyJzT8vypOHyfiXZas2eNAt3LpasQOGJjY+ke9wR7oyVJ5oFHqmQbPzWZFS2lafQucUbeK4IhfmaiSU9GOpnvudxgpq3TbAenhvbQwnmHEHC3YxREPuFolh55jUdVc0MyRSru3si9lkIo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=zqOSnafaP/loaRwxjDzYHqMt4PSgRF+hH46uVyKYzYJOtyRdMLLiMBPhwSBgSE47D5tYegio329PgpUgWog/m3ojajvZ+6tmOM/UKDxdpizfNUmH0CI1PYTVoq7UUc491nl8NFSUuaaGkOQ/MkC/E/z64dSQJ3yzzoDhi5GDmjI=; Message-ID: <979244.32654.qm@web114719.mail.gq1.yahoo.com> X-YMail-OSG: TXCjjW0VM1m5oVQ4Nqob4TV9T98ltZR5DrNd26PPJJJbHjM hx33hRdvw Received: from [187.78.191.162] by web114719.mail.gq1.yahoo.com via HTTP; Mon, 13 Dec 2010 08:46:13 PST X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259 References: <382634.50728.qm@web114704.mail.gq1.yahoo.com> <4D063798.2010206@2ndQuadrant.it> Date: Mon, 13 Dec 2010 08:46:13 -0800 (PST) From: paulo matadr Subject: Res: Cluster with LATIN1 and UTF-8 To: Gabriele Bartolini Cc: admin , GENERAL In-Reply-To: <4D063798.2010206@2ndQuadrant.it> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-855920801-1292258773=:32654" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201012/93 X-Sequence-Number: 36322 --0-855920801-1292258773=:32654 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I dont find way to create cluster... with example:=0A psql -l =0Ateste1 = |admin | LATIN1=0Ateste2 = | postgres | SQL_ASCII=0Ateste3 = | admin2 | UTF8=0A=0A-bash-3.1$= psql --version=0Apsql (PostgreSQL) 8.3.5=0Aon this version in another serv= er, it's working..=0Abut I cant repeat on postgres 9 .=0A=0A=0A=0A=0A=0A Pa= ulo=0A=0A=0A=0A=0A________________________________=0ADe: Gabriele Bartolini= =0APara: paulo matadr =0ACc: admin =0AEnviadas: Segunda-feira,= 13 de Dezembro de 2010 13:11:20=0AAssunto: Re: [ADMIN] Cluster with LATIN1= and UTF-8=0A=0ACiao Paulo,=0A=0AIl 13/12/10 14:22, paulo matadr ha scritto= : =0AIm try install postgres 9.0 on rhel=0A>and I try install clus= ter with 2 options of databases LATIN1 and =0AUTF-8.=0A>It's possi= ble?=0A>=0AYes it is. I suggest that you look at the "ENCODING" option for = the CREATE =0ADATABASE command:=0A=0Ahttp://www.postgresql.org/docs/9.0= /interactive/sql-createdatabase.html=0A=0AHope this helps.=0A=0ACheers,=0AG= abriele=0A=0A=0A-- =0A Gabriele Bartolini - 2ndQuadrant Italia=0A PostgreSQ= L Training, Services and Support=0Agabriele.bartolini@2ndQuadrant.it | www.= 2ndQuadrant.it =0A=0A=0A --0-855920801-1292258773=:32654 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I dont find way to create cluster... with example:
 ps= ql -l 
teste1         &nbs= p;             =     |admin           = ;            | LATIN1
tes= te2             = ;              = | postgres            &nb= sp;     | SQL_ASCII
teste3     = ;              =        | admin2                 &nb= sp;  | UTF8

-bash-3.1$ psql --version
psql (PostgreSQL) 8.3.= 5
on this version in another server, it's working..
but I cant repea= t on postgres 9 .




 
Paulo

<= div style=3D"font-family: times new roman,new york,times,serif; font-size: = 10pt;">
De: Gabriele Bartolini <gabriel= e.bartolini@2ndQuadrant.it>
Par= a: paulo matadr <saddoness@yahoo.com.br>
Cc: admin <pgsql-admin@postgresql.org= >
Enviadas: Segunda-= feira, 13 de Dezembro de 2010 13:11:20
Assunto: Re: [ADMIN] Cluster with LATIN1 and UTF-8

=0A=0A =0A =0A =0A Ciao Paulo,
=0A
=0A Il 13/= 12/10 14:22, paulo matadr ha scritto:=0A
=0A = =0A
Im try install postgres=0A = 9.0  on rhel
=0A and I try install cluster with 2 options o= f databases  LATIN1=0A and UTF-8.
=0A It's possible?<= br>=0A
=0A
=0A Yes it is. I suggest that you = look at the "ENCODING" option for the=0A CREATE DATABASE command:
=0A=
=0Ahttp://www.postgresql.org/docs/9.0/interactive/sql-createdatabas= e.html
=0A
=0A Hope this helps.
=0A
=0A Cheer= s,
=0A Gabriele
=0A
=0A 
-- =

 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Servi=
ces and Support
 gabriele.bartolini@2ndQuadran=
t.it | www.2ndQuadrant.it=0A
= =0A
=0A
=0A=0A=0A=0A   --0-855920801-1292258773=:32654--