question on plain pg_dump file usage - Mailing list pgsql-general

From Zwettler Markus (OIZ)
Subject question on plain pg_dump file usage
Date
Msg-id GV0P278MB009945F8EA0D8D6B2CF9D91D8B612@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: question on plain pg_dump file usage
Re: question on plain pg_dump file usage
WG: question on plain pg_dump file usage
Re: question on plain pg_dump file usage
List pgsql-general

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.

 

Thanks, Markus

 

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: update faster way
Next
From: Ron Johnson
Date:
Subject: Re: question on plain pg_dump file usage