Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C03471336971 for ; Mon, 13 Dec 2010 16:38:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 89866-02 for ; Mon, 13 Dec 2010 20:38:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web114715.mail.gq1.yahoo.com (web114715.mail.gq1.yahoo.com [98.136.183.142]) by mail.postgresql.org (Postfix) with SMTP id CAB351337B69 for ; Mon, 13 Dec 2010 16:38:13 -0400 (AST) Received: (qmail 60844 invoked by uid 60001); 13 Dec 2010 20:38:12 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s1024; t=1292272692; bh=QoBu/X7MYf+ZqHrrdyK9XGZStsW9SrXr1YWs/eiSWso=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=5iPCiRnpxr+KG7Psq4hcPZruDnWX1U4TJjq8nzBCLbG25NA6lV7dEKGy2+H/tCqj8GMVli/hKK2R+UqqjFiAn/MCYMoCQXjtUKa+g7fFWUFv+ZHyPHl+cWwJQlxOOkS0HVbn3TWL/dTPXOFC0J1kDgrVpUmL56QJvp3Pc+pGOZ0= 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:In-Reply-To:MIME-Version:Content-Type; b=g//sKjQtUjLhqCXI3q98/7r5QQZS5VHNOkNwNIbJ1JNv+zEAyuWd+cdhjgBm2r3jRWOEP2JaFI5WZLTLkXZkLSkXw3Gl7H9c2vmfGCOBqFdMHE9EmATSynEeHoINijvDveA8WvTN/bBf/msrI0qG0+cCMjybp+NpArFt/Vu9ZCM=; Message-ID: <825780.59847.qm@web114715.mail.gq1.yahoo.com> X-YMail-OSG: W8N2XFIVM1mpMg9FEqpbBFbKhiHspjx22Hm46nypuBmQ4t8 .6VjFMKSdQuyepgcxN7s2BnR1cowt.tCzN7L.U6AV_j86mqIetcUIP2Q2IPN zgjFsrzktHRRcQFLHNOJdYTyW9Q2_7nmzceQG1MszHtiYsUTCaBWXP3XyGqw 1SX1wZB77lsONcsZQq9ji9w3Ad9w3te9qB7rlexY1Si9z_gFTJVhC3aelypX RbinJjM91GadZiopbMPl1KMjVyxhDNeYhMMpEznUwp.TLz7IHz16lvu6JiBE JGpf783bXikQ9fGdLFAikEewgUJh0BZrtr9SDo5UWcV20Fpfo56TdslBWQHk iaQUH4SDHzxgdsqz6dzujSZVpLlJ4E06KlihwCeWaoYf6wuz1kd3.U.s- Received: from [187.78.191.162] by web114715.mail.gq1.yahoo.com via HTTP; Mon, 13 Dec 2010 12:38:12 PST X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259 References: <382634.50728.qm@web114704.mail.gq1.yahoo.com> <4D063798.2010206@2ndQuadrant.it> <979244.32654.qm@web114719.mail.gq1.yahoo.com> Date: Mon, 13 Dec 2010 12:38:12 -0800 (PST) From: paulo matadr Subject: Res: [GENERAL] Res: Cluster with LATIN1 and UTF-8 To: admin In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1992674933-1292272692=:59847" 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/99 X-Sequence-Number: 36328 --0-1992674933-1292272692=:59847 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Solved tnks...=0Acreatedb -E LATIN1 -O yyyy -T template0 --lc-collate=3Dpt= _BR --lc-ctype=3Dpt_BR xxxx=0A=0APaulo=0A=0A=0A=0A=0A______________________= __________=0ADe: Osvaldo Kussama =0APara: paulo = matadr =0AEnviadas: Segunda-feira, 13 de Dezembro d= e 2010 16:14:36=0AAssunto: Re: [GENERAL] Res: [ADMIN] Cluster with LATIN1 a= nd UTF-8=0A=0A2010/12/13 paulo matadr :=0A> I dont = find way to create cluster... with example:=0A> psql -l=0A> teste1 = |admin | LATIN1=0A> teste2 = | postgres | SQL_ASCII=0A> teste3 = | admin2 | UTF8=0A>=0A> -bash-3.1$ = psql --version=0A> psql (PostgreSQL) 8.3.5=0A> on this version in another s= erver, it's working..=0A> but I cant repeat on postgres 9 .=0A>=0A>=0A>=0A>= =0A>=0A> Paulo=0A>=0A> ________________________________=0A> De: Gabriele Ba= rtolini =0A> Para: paulo matadr =0A> Cc: admin =0A> Enviadas: S= egunda-feira, 13 de Dezembro de 2010 13:11:20=0A> Assunto: Re: [ADMIN] Clus= ter with LATIN1 and UTF-8=0A>=0A> Ciao Paulo,=0A>=0A> Il 13/12/10 14:22, pa= ulo matadr ha scritto:=0A>=0A> Im try install postgres 9.0 on rhel=0A> and= I try install cluster with 2 options of databases LATIN1 and UTF-8.=0A> I= t's possible?=0A>=0A> Yes it is. I suggest that you look at the "ENCODING" = option for the CREATE=0A> DATABASE command:=0A>=0A> http://www.postgresql.o= rg/docs/9.0/interactive/sql-createdatabase.html=0A>=0A> Hope this helps.=0A= >=0A=0A=0ASee an example in manual:=0Ahttp://www.postgresql.org/docs/curren= t/interactive/multibyte.html#AEN30690=0A=0AOsvaldo=0A=0A=0A=0A --0-1992674933-1292272692=:59847 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Solved  tnks...
createdb -E LATIN1 -O yyyy -T template= 0 --lc-collate=3Dpt_BR --lc-ctype=3Dpt_BR xxxx

Paulo

<= div style=3D"font-family: times new roman,new york,times,serif; font-size: = 10pt;">
De: Osvaldo Kussama <osvaldo.kussama@gmai= l.com>
Para: paulo m= atadr <saddoness@yahoo.com.br>
Enviadas: Segunda-feira, 13 de Dezembro de 2010 16:14:36
<= b>Assunto: Re: [GENERAL] Res:= [ADMIN] Cluster with LATIN1 and UTF-8

2010/12/13 paulo matad= r <saddoness@yahoo.com.br>:
> I dont find way to create cl= uster... with example:
>  psql -l
> teste1   &nb= sp;            =            |admin    = ;               = ;    | LATIN1
> teste2      &= nbsp;           &nbs= p;        | postgres    &= nbsp;             | SQL_A= SCII
> teste3          &= nbsp;               = | admin2                    | UTF8
>
> -bash-3.1$ psql --versio= n
> psql (PostgreSQL) 8.3.5
> on this version in another server= , it's working..
> but I cant repeat on postgres 9 .
>
><= br>>
>
>
> Paulo
>
> _____________________= ___________
> De: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
> Para: 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 L= ATIN1 and UTF-8
>
> Ciao Paulo,
>
> Il 13/12/10 14:= 22, paulo matadr ha scritto:
>
> Im try install postgres 9.0 = on rhel
> and I try install cluster with 2 options of databases = ; LATIN1 and UTF-8.
> It's possible?
>
> Yes it is. I sug= gest that you look at the "ENCODING" option for the CREATE
> DATABASE= command:
>
> http://www.postgresql.o= rg/docs/9.0/interactive/sql-createdatabase.html
>
> Hope th= is helps.
>


See an example in manual:
http://www.postgresql.org/docs/current/interactive/multibyte.h= tml#AEN30690

Osvaldo
=0A
=0A=0A=0A=0A =   --0-1992674933-1292272692=:59847--