| From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Upgrading |
| Date: | 2023-07-30 15:34:37 |
| Message-ID: | 20230730153437.bkogcoh4jyyzwjdz@hjp.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2023-07-30 07:53:54 -0400, Amn Ojee Uw wrote:
> On my Debian 12, I installed PostgreSQL-12,
Where did you install that from?
AFAICS, Debian 12 comes with PostgreSQL 15.
> I'd like to upgrade to the latest release of PostgreSQL. So, my
> question is, what is the best way to upgrade to the next release of
> PostgreSQL?
If you stay with the same source, Just installing the new version and
then invoking pg_upgrade (or a variant - PGDG, Debian, Ubuntu have
pg_upgradecluster) should do the trick.
If you switch sources, the setup may be sufficiently different that
pg_dump/pg_restore may be the easiest way.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaushal Shriyan | 2023-07-30 17:53:52 | Re: Migrating MySQL DB to PostgreSQL DB. |
| Previous Message | Adrian Klaver | 2023-07-30 14:53:44 | Re: Migrating MySQL DB to PostgreSQL DB. |