Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.700.51.1.1\))
Subject: Re: Upgrading 6 versions between 2 systems
From: Alban Hertroys <haramrae@gmail.com>
In-Reply-To: <8598df-508d-fa22-5866-35423256b1b3@appl-ecosys.com>
Date: Tue, 15 Sep 2026 10:02:13 +0200
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <0392D5EB-21FF-4BE4-9FAC-A4F7546C88D3@gmail.com>
References: <deee7dc-8e5e-cbba-aa3-2141e5d15c6a@appl-ecosys.com>
 <CANzqJaBQYcLc=aThm52En4EY+sPvQy6gTLx+ekiA4wuJjMJFKw@mail.gmail.com>
 <8598df-508d-fa22-5866-35423256b1b3@appl-ecosys.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
Archived-At: 
 <https://www.postgresql.org/message-id/0392D5EB-21FF-4BE4-9FAC-A4F7546C88D3%40gmail.com>
Precedence: bulk


> On 14 Sep 2026, at 23:44, Rich Shepard <rshepard@appl-ecosys.com> =
wrote:
>=20
> On Mon, 14 Sep 2026, Ron Johnson wrote:
>=20
>> Yes.  Note, though, that a single .sql file is the *slow* way to
>> export/import a database, especially if it's of any size.
>=20
> Ron,
>=20
> 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=E2=80=99re dumping one database at a time, that doesn=E2=80=99t =
include any of the database roles or users you may have added. Roles =
(and users) are stored with the cluster, not per database.=20

That=E2=80=99s where the below mentioned `pg_dumpall --globals-only` =
feature comes into play. You don=E2=80=99t need the parallel stuff, but =
the globals bit could be important.

With the rest cut out, that leaves:

>=20
>> 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.=