Res: Cluster with LATIN1 and UTF-8

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: Gabriele Bartolini <gabriele(dot)bartolini(at)2ndQuadrant(dot)it>
Cc: admin <pgsql-admin(at)postgresql(dot)org>, GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Res: Cluster with LATIN1 and UTF-8
Date: 2010-12-13 16:46:13
Message-ID: 979244.32654.qm@web114719.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(dot)bartolini(at)2ndQuadrant(dot)it>
Para: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: admin <pgsql-admin(at)postgresql(dot)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(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fred Parkinson 2010-12-13 16:47:06 Re: pgadmin3: can't locate server: what am I doing wrong?
Previous Message Guillaume Lelarge 2010-12-13 16:32:05 Re: pgadmin3: can't locate server: what am I doing wrong?

Browse pgsql-general by date

  From Date Subject
Next Message ray 2010-12-13 18:46:25 Defining a Connection String in Windows XP
Previous Message Jens Wilke 2010-12-13 16:42:21 Re: Problem while pg_xlog directory