| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | listy <listy(at)localities(dot)work>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: upgrade from 13 to 16 |
| Date: | 2026-03-02 14:34:30 |
| Message-ID: | f6da599d9e2736da00a149d36b5f65e934ad34ed.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 2026-03-02 at 13:43 +0100, listy wrote:
> Is upgrade from ver. 13 to 16 possible?
Yes.
> -> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/
> You must identify the directory where the old cluster binaries reside.Please use the -b command-line option or the PGBINOLD environment variable.
> Failure, exiting
>
> Or is a restoration from a backup the only way?
>
> If you cannot be bothered to read the documentation for pg_upgrade, then
dump and restore may be the only way.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-03-02 14:36:30 | Re: problem during postgres restore: max_connections = 100 is a lower setting than on the primary server, where its value was 350 |
| Previous Message | Ron Johnson | 2026-03-02 14:31:32 | Re: upgrade from 13 to 16 |