pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading
8+ messages / 6 participants
[nested] [flat]
* Upgrading
@ 2003-01-16 22:03 Patrick Nelson <pnelson@neatech.com>
0 siblings, 0 replies; 8+ messages in thread
From: Patrick Nelson @ 2003-01-16 22:03 UTC (permalink / raw)
To: pgsql-general
I have a RedHat 7.2 system with 7.2.1-2PGDG (as a server) installed on it.
I installed the PGDG rpm mainly because our RH 7.3 and 8.0 systems seemed to
have problems with the version that was current in the RH 7.2 updates.
Everything has worked great.
However, RH has release new clients (7.2.3-5.73 for RH7.2 systems and
7.1.3-4bp.2 on 7.2 systems) so I would like to update my 7.2 server and
clients. The 7.1.3-4 installed on the RH7.2 clients works fine
communicating with the 7.2.1-2PGDG server, but I am going to push these up
to what ever version is suggested.
So here is the questions:
1. What version of server should I install on the RH 7.2 system?
2. If I go with the latest 7.3.1 (using the RH 7.3 rpms) will 7.2.3-5.73
clients have any problems communicating?
3. Or should I stick with a lower version?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2003-01-17 17:31 Patrick Nelson <pnelson@neatech.com>
0 siblings, 0 replies; 8+ messages in thread
From: Patrick Nelson @ 2003-01-17 17:31 UTC (permalink / raw)
To: pgsql-general
Patrick Nelson wrote:
----------------->>>>
I have a RedHat 7.2 system with 7.2.1-2PGDG (as a server) installed on it.
I installed the PGDG rpm mainly because our RH 7.3 and 8.0 systems seemed to
have problems with the version that was current in the RH 7.2 updates.
Everything has worked great.
However, RH has release new clients (7.2.3-5.73 for RH7.2 systems and
7.1.3-4bp.2 on 7.2 systems) so I would like to update my 7.2 server and
clients. The 7.1.3-4 installed on the RH7.2 clients works fine
communicating with the 7.2.1-2PGDG server, but I am going to push these up
to what ever version is suggested.
So here is the questions:
1. What version of server should I install on the RH 7.2 system?
2. If I go with the latest 7.3.1 (using the RH 7.3 rpms) will 7.2.3-5.73
clients have any problems communicating?
3. Or should I stick with a lower version?
----------------->>>>
Hmm... no response at all. Either I'm to vague or to complex or to stupid.
I guess to stupid... I'll try some stuff and see if upgrading works.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Upgrading
@ 2023-07-30 11:53 Amn Ojee Uw <amnojeeuw@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Amn Ojee Uw @ 2023-07-30 11:53 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Just a quick question.
On my Debian 12, I installed PostgreSQL-12, 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?
Thanks in advance.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2023-07-30 12:04 Wen Yi <wen-yi@qq.com>
0 siblings, 0 replies; 8+ messages in thread
From: Wen Yi @ 2023-07-30 12:04 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
You can see this document.
https://www.postgresql.org/docs/current/pgupgrade.html
Yours,
Wen Yi
---Original---
From: "Amn Ojee Uw"<amnojeeuw@gmail.com>
Date: Sun, Jul 30, 2023 19:54 PM
To: "pgsql-general"<pgsql-general@lists.postgresql.org>;
Subject: Upgrading
Just a quick question.
On my Debian 12, I installed PostgreSQL-12, 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?
Thanks in advance.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2023-07-30 12:12 Ron <ronljohnsonjr@gmail.com>
parent: Amn Ojee Uw <amnojeeuw@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Ron @ 2023-07-30 12:12 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 7/30/23 06:53, Amn Ojee Uw wrote:
> Just a quick question.
>
> On my Debian 12, I installed PostgreSQL-12, 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?
To the latest release of v12 (which is 12.15), or the latest major version
(v15, at release 15.3)?
"Upgrade" has a specific meaning in PostgreSQL: to migrate from a prior
*major* (like 12) version to a newer major (like 15) version.
Is that what you mean?
Or did you mean to *update* from an older release of v12 (for example 12.11)
to the latest release (12.15)?
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2023-07-30 15:34 Peter J. Holzer <hjp-pgsql@hjp.at>
parent: Amn Ojee Uw <amnojeeuw@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Peter J. Holzer @ 2023-07-30 15:34 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2023-07-31 02:22 Amn Ojee Uw <amnojeeuw@gmail.com>
parent: Peter J. Holzer <hjp-pgsql@hjp.at>
0 siblings, 1 reply; 8+ messages in thread
From: Amn Ojee Uw @ 2023-07-31 02:22 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Thank you Ron and Peter for taking the time to respond to my call for help.
In summery, I'd like to use PostgreSQL-15.
However, since my Debian 12 already has already PostgreSQL-15 installed,
did I inadvertently overwrote PostgreSQL-15 when I installed
PostgreSQL-12? If so, how do I remove PostgreSQL-12 and continue on with
PostgreSQL-15.
Please note that I installed using the following command
/*sudo apt-get -y install postgresql-12*/
Thanks in advance.
On 7/30/23 11:34 a.m., Peter J. Holzer wrote:
> 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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading
@ 2023-07-31 02:46 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Amn Ojee Uw <amnojeeuw@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Adrian Klaver @ 2023-07-31 02:46 UTC (permalink / raw)
To: Amn Ojee Uw <amnojeeuw@gmail.com>; pgsql-general@lists.postgresql.org
On 7/30/23 19:22, Amn Ojee Uw wrote:
> Thank you Ron and Peter for taking the time to respond to my call for help.
>
> In summery, I'd like to use PostgreSQL-15.
>
> However, since my Debian 12 already has already PostgreSQL-15 installed,
> did I inadvertently overwrote PostgreSQL-15 when I installed
> PostgreSQL-12? If so, how do I remove PostgreSQL-12 and continue on with
> PostgreSQL-15.
Short answer
1) No you just created a new cluster. See result of:
pg_lsclusters
2) This assumes you don't have any valuable data in cluster. To remove
first confirm cluster name below(main) with above command then:
pg_dropcluster 12 main
Longer answer read:
https://wiki.debian.org/PostgreSql
and for more in depth explanation two blogs I recently posted:
https://aklaver.org/wordpress/2023/06/29/postgres-debian-ubuntu-packagingpart-1/
https://aklaver.org/wordpress/2023/07/01/postgres-debian-ubuntu-packagingpart-2/
>
> Please note that I installed using the following command
>
> /*sudo apt-get -y install postgresql-12*/
>
> Thanks in advance.
>
>
> On 7/30/23 11:34 a.m., Peter J. Holzer wrote:
>> 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
>>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2023-07-31 02:46 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-16 22:03 Upgrading Patrick Nelson <pnelson@neatech.com>
2003-01-17 17:31 Re: Upgrading Patrick Nelson <pnelson@neatech.com>
2023-07-30 11:53 Upgrading Amn Ojee Uw <amnojeeuw@gmail.com>
2023-07-30 12:12 ` Ron <ronljohnsonjr@gmail.com>
2023-07-30 15:34 ` Peter J. Holzer <hjp-pgsql@hjp.at>
2023-07-31 02:22 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-07-31 02:46 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-07-30 12:04 Re: Upgrading Wen Yi <wen-yi@qq.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox