Skip site navigation (1) Skip section navigation (2)

Re: How is the default encoding determined

From: Travis Smith <tsmith(at)optionshouse(dot)com>
To: 'Geoffrey' <lists(at)serioustechnology(dot)com>, Postgres-Admin list<pgsql-admin(at)postgresql(dot)org>
Subject: Re: How is the default encoding determined
Date: 2008-06-12 16:26:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
This looks like what you are looking for.

The character set encoding can be set separately for a database when it is created. initdb determines the encoding for the template1 database, which will serve as the default for all other databases. To alter the default encoding use the --encoding option. More details can be found in Section 21.2.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Geoffrey
Sent: Thursday, June 12, 2008 11:21 AM
To: Postgres-Admin list
Subject: [ADMIN] How is the default encoding determined

I recently was bitten by having two servers where the database encoding
was different. When I do an 'initdb' how does it determine the 'default'

Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:


The  information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial  use  of  the individual or entity to which it is
addressed and may contain information that is  propri-
etary  and  confidential.  If you are not the intended
recipient of this message you are hereby notified that
any  review, dissemination, distribution or copying of
this message is strictly prohibited.  This  communica-
tion  is  for information purposes only and should not
be regarded as an offer to sell or as  a  solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be  secure  or  error-
free. P6070214

In response to


pgsql-admin by date

Next:From: GeoffreyDate: 2008-06-12 19:20:55
Subject: Re: How is the default encoding determined
Previous:From: GeoffreyDate: 2008-06-12 16:20:49
Subject: How is the default encoding determined

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group