Re: pg_dump on local Windows, pg_restore on Linux? - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: pg_dump on local Windows, pg_restore on Linux?
Date
Msg-id e373d31e0708151104p1798a781r3cc825ccd0961058@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump on local Windows, pg_restore on Linux?  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: pg_dump on local Windows, pg_restore on Linux?  ("Leif B. Kristensen" <leif@solumslekt.org>)
List 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?

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
Next
From: Decibel!
Date:
Subject: Re: Copy command and duplicate items (Support Replace?)