From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
Cc: | Rama Krishnan <raghuldrag(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: About postgres pg_upgrade |
Date: | 2024-04-06 17:41:02 |
Message-ID: | ZhGJLj6h8cBRogfm@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 5, 2024 at 09:41:05AM +0200, Daniel Gustafsson wrote:
> > On 5 Apr 2024, at 06:47, Rama Krishnan <raghuldrag(at)gmail(dot)com> wrote:
>
> > Could you please explain me how does pg_upgrade works one of my friends it works based on pg_restore I am bit confused
>
> The documentation does a fairly good job explaining how it works, and there are
> multiple blogposts and presentations on the subject to be found.
>
> https://www.postgresql.org/docs/devel/pgupgrade.html
>
> To summarize in a few words, pg_upgrade does a dump/restore of the schema from
> the old cluster into the new, but copies the table data. Your friend is thus
> isn't wrong, it does use pg_restore but only for the schema, not the data.
This presentation shows how it works internally:
https://momjian.us/main/writings/pgsql/pg_upgrade.pdf
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
From | Date | Subject | |
---|---|---|---|
Next Message | yudhi s | 2024-04-06 20:04:49 | Re: Moving delta data faster |
Previous Message | Adrian Klaver | 2024-04-06 16:55:47 | Re: Moving delta data faster |