Quick Links

question on plain pg_dump file usage

From:	"Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To:	PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject:	question on plain pg_dump file usage
Date:	2024-09-17 12:22:14
Message-ID:	GV0P278MB009945F8EA0D8D6B2CF9D91D8B612@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

Re: question on plain pg_dump file usage at 2024-09-17 12:43:36 from Ron Johnson
Re: question on plain pg_dump file usage at 2024-09-17 13:18:02 from Greg Sabino Mullane
WG: question on plain pg_dump file usage at 2024-09-17 13:27:42 from Zwettler Markus (OIZ)
Re: question on plain pg_dump file usage at 2024-09-17 14:02:34 from Tom Lane

	From	Date	Subject
Next Message	Andy Hartman	2024-09-17 12:31:49	Re: load fom csv
Previous Message	Alvaro Herrera	2024-09-17 08:28:45	Re: update faster way