Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qqcOn-000FoB-TB for pgsql-general@arkaria.postgresql.org; Wed, 11 Oct 2023 16:49:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qqcOl-00HV91-Ab for pgsql-general@arkaria.postgresql.org; Wed, 11 Oct 2023 16:49:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qqcOk-00HV8Q-VC for pgsql-general@lists.postgresql.org; Wed, 11 Oct 2023 16:49:27 +0000 Received: from mail-wr1-x42a.google.com ([2a00:1450:4864:20::42a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qqcOi-0001j9-F4 for pgsql-general@lists.postgresql.org; Wed, 11 Oct 2023 16:49:27 +0000 Received: by mail-wr1-x42a.google.com with SMTP id ffacd0b85a97d-3247cefa13aso10988f8f.1 for ; Wed, 11 Oct 2023 09:49:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1697042964; x=1697647764; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=OOT5Gcs3hgdOW7YP/htHkpAYn/op1YCkdHn8ulYWx2I=; b=kkfVkWNTOdgye6Ry+ZiTDpsBv9K7Vxfi+4UCau5kR++dLFq6lFslr6c8Ug8LtBbiwM vKRUs/Vhz/DJ/8P53jWJRDA8WYYQt7eGYkaPXvyAzse1crkPfgrLRHgUlLX6ZCZZVfy1 KDtlMgxG539UsIcVEjPSzYYC4S8YHAON/sgBPeIqXx8y/+32dkmBFO/u2Z8eY8IwdTr/ XPD2E1WJwDmdSwNX3OmRofmkpiduBd8sXWKX9T6sOFvVsdWcPZ3GpTvBLa0iDjVjonFp cHqIAiZbDlBQNAfhqqFTxiaVTj4K/SvFGTvkJYxS+M2DdT4m4qZM5OjP/Ug3uDf5LMMh JXNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697042964; x=1697647764; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=OOT5Gcs3hgdOW7YP/htHkpAYn/op1YCkdHn8ulYWx2I=; b=s5+thlBpCZVZ8e0Uh2/cnG+rzcGN8QLWXh4MM0vVV/ZZUcTne0MiGGM78Vd8HcYzUZ LXFrpn0tN6w/71Q/p8SQsdn7/Gme+bi5fgJdt9yeDqKgW4elciB0taN06dEsOJgxNmA4 X+JhTGgV9rSX/fz1pnAhI4LNtZghQTYuoOCz5G3R8oY2I24n3BVsqAwJMaXxrXioVm/O QoQVFEzMQxpyZLzInnaFVdZijTSwFTxiOyLaPMjU8wKOEmZqPByB3daPDWk6gJm13mzy sQTQzwYLWpqroDDAjCMg2oBCx16kNhjqLdM87oqH1bizvP0G86LTfVZmKxWQR/DhXRAH qAkA== X-Gm-Message-State: AOJu0Yy1tWNCiZMuRm9NDOvzZDBxex+jfxjfkqOdrtLJ5iHvyNj3lCDT EU2a42l9DqTMMlYOw8IhoYfd6A== X-Google-Smtp-Source: AGHT+IE/a4tiuQNeq7m1WXaQYyeeLvWXETnBK5c8p6UPuIKc965PoAcJ+mamZY9Wnz4CEXdwtuuVnA== X-Received: by 2002:a5d:6b82:0:b0:319:5677:f832 with SMTP id n2-20020a5d6b82000000b003195677f832mr17400588wrx.62.1697042964180; Wed, 11 Oct 2023 09:49:24 -0700 (PDT) Received: from localhost.localdomain (62-46-252-117.adsl.highway.telekom.at. [62.46.252.117]) by smtp.gmail.com with ESMTPSA id bv28-20020a0560001f1c00b0032d402f816csm4775014wrb.98.2023.10.11.09.49.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Oct 2023 09:49:23 -0700 (PDT) Message-ID: <61aec9b659252bc9cef1db5266a023abde25ce9f.camel@cybertec.at> Subject: Re: moving data with pg_dump/pg_restore between database with different locale From: Laurenz Albe To: "Zwettler Markus (OIZ)" , "pgsql-general@lists.postgresql.org" Date: Wed, 11 Oct 2023 18:49:23 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-10-11 at 11:34 +0000, Zwettler Markus (OIZ) wrote:=C2=A0 > if you want to retrieve data by means of pg_dump / pg_restore from a data= base with > locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any ot= her things > to consider than the behavior implications mentioned in the documentation= : The sort order will change, the language of error messages and the log file will change (unless you set lc_messages differently), some format letters i= n to_timestamp(), to_number() and to_char() will change semantics (unless you set lc_numeric and lc_time differently). That's about it. Yours, Laurenz Albe