> On 14 Sep 2026, at 23:44, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> On Mon, 14 Sep 2026, Ron Johnson wrote:
>
>> Yes. Note, though, that a single .sql file is the *slow* way to
>> export/import a database, especially if it's of any size.
>
> Ron,
>
> My databases are small and I'll transfer them one-at-a-time rather than the
> whole custer itself.
Rich,
Just a little heads-up:
If you’re dumping one database at a time, that doesn’t include any of the database roles or users you may have added.
Roles(and users) are stored with the cluster, not per database.
That’s where the below mentioned `pg_dumpall --globals-only` feature comes into play. You don’t need the parallel
stuff,but the globals bit could be important.
With the rest cut out, that leaves:
>
>> Current system:
>> cd /path/to/backups
>> pg_dumpall --globals-only > globals_127.sql
...
>> New system:
>> cd /path/to/backups
>> psql -af globals_127.sql
Regards,
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
