Postgres Pro
Downloads
Home   >   mailing lists

Res: [ADMIN] Cluster with LATIN1 and UTF-8 - Mailing list pgsql-general

From paulo matadr
Subject Res: [ADMIN] Cluster with LATIN1 and UTF-8
Date
Msg-id 979244.32654.qm@web114719.mail.gq1.yahoo.com
Whole thread Raw
List pgsql-general
Tree view
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

 

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Devart ADO.NET Data Providers Deliver Advanced Model-First and Database-First Support and Improved ORM Solution!
Next
From: Jens Wilke
Date:
Subject: Re: Problem while pg_xlog directory