public inbox for [email protected]
help / color / mirror / Atom feedRe: libc to libicu via pg_dump/pg_restore?
2+ messages / 2 participants
[nested] [flat]
* Re: libc to libicu via pg_dump/pg_restore?
@ 2025-02-07 14:53 Greg Sabino Mullane <[email protected]>
2025-02-07 16:13 ` Re: libc to libicu via pg_dump/pg_restore? Adrian Klaver <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Greg Sabino Mullane @ 2025-02-07 14:53 UTC (permalink / raw)
To: Daniel Verite <[email protected]>; +Cc: Paul Foerster <[email protected]>; Adrian Klaver <[email protected]>; Pgsql-General List <[email protected]>
I'm not sure why we are focused on the other errors - the database fails to
get dropped (or created), so future errors are to be expected.
pg_restore should be run with the --exit-on-error flag, and handle the
errors one by one as someone mentioned upthread.
I would use the --section=pre-data --section=data and --section=post-data
flags to pg_dump to create (for the pre-data) a small and editable file so
you can tweak the CREATE DATABASE as you please.
pg_dump mydb --clean --create --section=pre-data --file=mydb.pre.pg
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: libc to libicu via pg_dump/pg_restore?
2025-02-07 14:53 Re: libc to libicu via pg_dump/pg_restore? Greg Sabino Mullane <[email protected]>
@ 2025-02-07 16:13 ` Adrian Klaver <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2025-02-07 16:13 UTC (permalink / raw)
To: Greg Sabino Mullane <[email protected]>; Daniel Verite <[email protected]>; +Cc: Paul Foerster <[email protected]>; Pgsql-General List <[email protected]>
On 2/7/25 06:53, Greg Sabino Mullane wrote:
> I'm not sure why we are focused on the other errors - the database fails
> to get dropped (or created), so future errors are to be expected.
It is already created before the pg_restore is run.
The OP says it works for ~40 other databases they are upgrading using
the same process.
>
> Cheers,
> Greg
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-07 16:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-07 14:53 Re: libc to libicu via pg_dump/pg_restore? Greg Sabino Mullane <[email protected]>
2025-02-07 16:13 ` Adrian Klaver <[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