pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInstallation Questions (FreeBSD / Windows / Postgres 9)
2+ messages / 2 participants
[nested] [flat]
* Installation Questions (FreeBSD / Windows / Postgres 9)
@ 2010-11-03 20:26 Panos Katergiathis <eyeprotocol@gmail.com>
2010-11-04 21:14 ` Re: Installation Questions (FreeBSD / Windows / Postgres 9) Dimitri Fontaine <dimitri@2ndQuadrant.fr>
0 siblings, 1 reply; 2+ messages in thread
From: Panos Katergiathis @ 2010-11-03 20:26 UTC (permalink / raw)
To: pgsql-admin
Hello all
My goal is to install and run Postgresql 9 under FreeBSD and Windows
with selected database cluster encoding / collation / locale to be
UTF-8.
Unfortunately, it has been a while since i last compiled and installed
Postgresql on Linux machines. I remember that selecting the proper
locale and encoding for the database cluster was a matter to be
decided at built time. Is it still so for version 9?
If yes, how does one go about installing the FreeBSD port, while
actually choosing the locale and encoding for the cluster?
Also, how does one do it under Windows? (i assume that there must be
modern ways to do it, because back then i had to install Cygwin and
take it from there, without really having the ability to select UTF-8,
since it was not an option).
Thank you in advance for any replies. I could not locate such
information within the FreeBSD community, let alone the Windows
community.
Regards
Panos
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Installation Questions (FreeBSD / Windows / Postgres 9)
2010-11-03 20:26 Installation Questions (FreeBSD / Windows / Postgres 9) Panos Katergiathis <eyeprotocol@gmail.com>
@ 2010-11-04 21:14 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Dimitri Fontaine @ 2010-11-04 21:14 UTC (permalink / raw)
To: Panos Katergiathis <eyeprotocol@gmail.com>; +Cc: pgsql-admin
Panos Katergiathis <eyeprotocol@gmail.com> writes:
> Unfortunately, it has been a while since i last compiled and installed
> Postgresql on Linux machines. I remember that selecting the proper
> locale and encoding for the database cluster was a matter to be
> decided at built time. Is it still so for version 9?
No, see CREATE DATABASE documentation here:
http://www.postgresql.org/docs/9/static/sql-createdatabase.html
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] user_name ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
[ LC_COLLATE [=] lc_collate ]
[ LC_CTYPE [=] lc_ctype ]
[ TABLESPACE [=] tablespace ]
[ CONNECTION LIMIT [=] connlimit ] ]
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-11-04 21:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-03 20:26 Installation Questions (FreeBSD / Windows / Postgres 9) Panos Katergiathis <eyeprotocol@gmail.com>
2010-11-04 21:14 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
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