From: paulo matadr <saddoness@yahoo.com.br>
To: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
Cc: admin <pgsql-admin@postgresql.org>
Cc: GENERAL <pgsql-general@postgresql.org>
Subject: Res: Cluster with LATIN1 and UTF-8
Date: Mon, 13 Dec 2010 08:46:13 -0800 (PST)
Message-ID: <979244.32654.qm@web114719.mail.gq1.yahoo.com> (raw)
In-Reply-To: <4D063798.2010206@2ndQuadrant.it>
References: <382634.50728.qm@web114704.mail.gq1.yahoo.com>
<4D063798.2010206@2ndQuadrant.it>
I dont find way to create cluster... with example:
psql -l
teste1 |admin | LATIN1
teste2 | postgres | SQL_ASCII
teste3 | admin2 | UTF8
-bash-3.1$ psql --version
psql (PostgreSQL) 8.3.5
on this version in another server, it's working..
but I cant repeat on postgres 9 .
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 LATIN1 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 suggest that you look at the "ENCODING" option for the CREATE
DATABASE command:
http://www.postgresql.org/docs/9.0/interactive/sql-createdatabase.html
Hope this helps.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: saddoness@yahoo.com.br, gabriele.bartolini@2ndQuadrant.it, pgsql-general@postgresql.org
Subject: Re: Res: Cluster with LATIN1 and UTF-8
In-Reply-To: <979244.32654.qm@web114719.mail.gq1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox