Re: pg_dump on local Windows, pg_restore on Linux?

> 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?