public inbox for [email protected]
help / color / mirror / Atom feedRe: question on plain pg_dump file usage
2+ messages / 2 participants
[nested] [flat]
* Re: question on plain pg_dump file usage
@ 2024-09-17 12:43 Ron Johnson <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ron Johnson @ 2024-09-17 12:43 UTC (permalink / raw)
To: pgsql-general
On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) <
[email protected]> wrote:
> 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.
>
>
Why must it be a plain text dump instead of a custom or directory dump?
Restoring to a new (and differently-named( database is perfectly doable.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!
^ permalink raw reply [nested|flat] 2+ messages in thread
* WG: [Extern] Re: question on plain pg_dump file usage
@ 2024-09-17 13:16 Zwettler Markus (OIZ) <[email protected]>
parent: Ron Johnson <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Zwettler Markus (OIZ) @ 2024-09-17 13:16 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; pgsql-general
Von: Ron Johnson <[email protected]>
Gesendet: Dienstag, 17. September 2024 14:44
An: PG-General Mailing List <[email protected]>
Betreff: [Extern] Re: question on plain pg_dump file usage
On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) <[email protected]<mailto:[email protected]>> wrote:
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.
Why must it be a plain text dump instead of a custom or directory dump? Restoring to a new (and differently-named( database is perfectly doable.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!
--- Externe Email: Vorsicht mit Anhängen, Links oder dem Preisgeben von Informationen ---
Because I can simply change the application from the old to the new structure then.
-Regards, Markus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-09-17 13:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-17 12:43 Re: question on plain pg_dump file usage Ron Johnson <[email protected]>
2024-09-17 13:16 ` WG: [Extern] Re: question on plain pg_dump file usage Zwettler Markus (OIZ) <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox