pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow is the default encoding determined
3+ messages / 2 participants
[nested] [flat]
* How is the default encoding determined
@ 2008-06-12 16:20 Geoffrey <lists@serioustechnology.com>
2008-06-12 16:26 ` Re: How is the default encoding determined Travis Smith <tsmith@optionshouse.com>
0 siblings, 1 reply; 3+ messages in thread
From: Geoffrey @ 2008-06-12 16:20 UTC (permalink / raw)
To: pgsql-admin
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'
encoding?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How is the default encoding determined
2008-06-12 16:20 How is the default encoding determined Geoffrey <lists@serioustechnology.com>
@ 2008-06-12 16:26 ` Travis Smith <tsmith@optionshouse.com>
2008-06-12 19:20 ` Re: How is the default encoding determined Geoffrey <lists@serioustechnology.com>
0 siblings, 1 reply; 3+ messages in thread
From: Travis Smith @ 2008-06-12 16:26 UTC (permalink / raw)
To: Geoffrey <lists@serioustechnology.com>; pgsql-admin
This looks like what you are looking for.
http://www.postgresql.org/docs/8.2/static/app-initdb.html
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.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'
encoding?
--
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
_______________________________________________________
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How is the default encoding determined
2008-06-12 16:20 How is the default encoding determined Geoffrey <lists@serioustechnology.com>
2008-06-12 16:26 ` Re: How is the default encoding determined Travis Smith <tsmith@optionshouse.com>
@ 2008-06-12 19:20 ` Geoffrey <lists@serioustechnology.com>
0 siblings, 0 replies; 3+ messages in thread
From: Geoffrey @ 2008-06-12 19:20 UTC (permalink / raw)
To: Travis Smith <tsmith@optionshouse.com>; +Cc: pgsql-admin
Travis Smith wrote:
> This looks like what you are looking for.
>
>
>
> http://www.postgresql.org/docs/8.2/static/app-initdb.html
>
>
> 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.
Thanks, I saw all that, what I was trying to figure out is where in the
environment does initdb determine what to set the encoding to when it's
not specified.
I ran into a problem with the wrong encoding on our database and I want
to figure out if it's because the environment is different on this box,
or if it was caused by the upgrade from 7.4 to 8.3
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-06-12 19:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-12 16:20 How is the default encoding determined Geoffrey <lists@serioustechnology.com>
2008-06-12 16:26 ` Travis Smith <tsmith@optionshouse.com>
2008-06-12 19:20 ` Geoffrey <lists@serioustechnology.com>
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