| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Upgrading 6 versions between 2 systems |
| Date: | 2026-09-14 22:23:07 |
| Message-ID: | 45ef2a8b-7a33-4274-9d88-a4abbbaf60cb@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/14/26 2:58 PM, Rich Shepard wrote:
> On Mon, 14 Sep 2026, Adrian Klaver wrote:
>
>> Since you are transferring the data as text that should not be a problem.
>> Just point the newer version of pg_dumpall, I assume the one on the
>> Slackware 15 host, at the older version Postgres server.
>
> Adrian,
>
> Hadn't thought I could do that. But, why not if I use the
> servername:/directory?
Not sure what servername:/directory means?
As example, assuming Postgres 12.7 is running on machine at address
192.168.0.1.
pg_dumpall -h 192.168.0.1 -U some_user -f db_cluster.sql
This would be run from the second machine that has Postgres 18.6.
>
> Thanks,
>
> Rich
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brajendra Pratap Singh | 2026-09-15 01:38:35 | pg_upgrade --link |
| Previous Message | Rich Shepard | 2026-09-14 21:58:28 | Re: Upgrading 6 versions between 2 systems |