Re: question on plain pg_dump file usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: question on plain pg_dump file usage
Date: 2024-09-17 14:02:34
Message-ID: 1461555.1726581754@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> writes:
> I have to do an out-of-place Postgres migration from PG12 to PG16 using:
> pg_dump -F p -f dump.sql ...
> sed -i "s/old_name/new_name/g"
> psql -f dump.sql ...

> Both databases are on UTF-8.

> I wonder if there could be character set conversion errors here, as the data is temporarily written to a plain text file.

The dump script will include a "SET client_encoding" command to
prevent that.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-09-17 15:01:32 Re: question on plain pg_dump file usage
Previous Message Zwettler Markus (OIZ) 2024-09-17 13:27:42 WG: question on plain pg_dump file usage