X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7AB9A545CB; Sun, 24 Apr 2005 10:45:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70828-09; Sun, 24 Apr 2005 13:45:33 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id CDC6853330; Sun, 24 Apr 2005 10:45:30 -0300 (ADT) Received: from p188.n-nypop04.stsn.com ([199.106.91.188] helo=[10.0.43.211]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1DPhQU-00031Y-BJ; Sun, 24 Apr 2005 09:45:34 -0400 Message-ID: <426BA306.6050702@zeut.net> Date: Sun, 24 Apr 2005 09:45:42 -0400 From: "Matthew T. O'Connor" User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Locale question Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 199.106.91.188 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/354 X-Sequence-Number: 17367 I have a (hopefully simple) question regarding locale. I am migrating a postgresql database from a server running FC1 & PostgreSQL 7.4 to a newer machine running FC2 and PostgreSQL 8.0. I dumped the data from the old server using pg_dumpall and restored it to the new server with no problems, and while testing the new server everything seems to be OK. However, I did notice that the client and server encoding settings on the old server are set to SQL_ASCII whereas those same settings on the new server are set to LATIN1. I'm wondering if I might wind up with some lurking problems since I don't really understand all the implications of locale settings. Thanks, Matthew O'Connor Details below: On the old server -bash-2.05b$ cat /etc/redhat-release Fedora Core release 1 (Yarrow) -bash-2.05b$ locale LANG=en_US LC_CTYPE="en_US" LC_NUMERIC="en_US" LC_TIME="en_US" LC_COLLATE="en_US" LC_MONETARY="en_US" LC_MESSAGES="en_US" LC_PAPER="en_US" LC_NAME="en_US" LC_ADDRESS="en_US" LC_TELEPHONE="en_US" LC_MEASUREMENT="en_US" LC_IDENTIFICATION="en_US" -bash-2.05b$ psql template1 Welcome to psql 7.4.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=# show all; name | setting --------------------------------+--------------------------------------- client_encoding | SQL_ASCII lc_collate | en_US lc_ctype | en_US lc_messages | en_US lc_monetary | en_US lc_numeric | en_US lc_time | en_US server_encoding | SQL_ASCII On the new server: -bash-2.05b$ cat /etc/redhat-release Fedora Core release 2 (Tettnang) -bash-2.05b$ locale LANG=en_US LC_CTYPE="en_US" LC_NUMERIC="en_US" LC_TIME="en_US" LC_COLLATE="en_US" LC_MONETARY="en_US" LC_MESSAGES="en_US" LC_PAPER="en_US" LC_NAME="en_US" LC_ADDRESS="en_US" LC_TELEPHONE="en_US" LC_MEASUREMENT="en_US" LC_IDENTIFICATION="en_US" -bash-2.05b$ psql template1 Welcome to psql 8.0.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit template1=# \o foo template1=# show all; name | setting --------------------------------+--------------------------------------- client_encoding | LATIN1 lc_collate | en_US lc_ctype | en_US lc_messages | en_US lc_monetary | en_US lc_numeric | en_US lc_time | en_US server_encoding | LATIN1