question on plain pg_dump file usage

Поиск
Список
Период
Сортировка
От Zwettler Markus (OIZ)
Тема question on plain pg_dump file usage
Дата
Msg-id GV0P278MB009945F8EA0D8D6B2CF9D91D8B612@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы 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
Список 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 по дате отправления: