Re: pg_dump on local Windows, pg_restore on Linux?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump on local Windows, pg_restore on Linux?
Date: 2007-08-15 18:04:08
Message-ID: e373d31e0708151104p1798a781r3cc825ccd0961058@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> At least on a *nix system, collation is based on the value of the LC_ALL
> environment variable at dbinit time. There's nothing you can do about
> it in a live database. IMO that's a little awkward, and is what finally
> made me change the global from ISO-8859-1 to UTF-8 on my three Gentoo
> Linux machines.

This is great info, thanks. Could you let me know how I could change
the global values of "LC_ALL"? I am on Linux too, just CentOS, but I
suppose it should be the same or similar?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Decibel! 2007-08-15 18:04:29 Re: Copy command and duplicate items (Support Replace?)
Previous Message Phoenix Kiula 2007-08-15 18:01:50 Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"