Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_upgrade utility with --link option

pg_upgrade utility with --link option

From
"M.Yousaf Maqsood"
Date:
Hi Team,

I hope you are doing well.  Have anyone of you tried pg_upgrade with --link option .

I was trying to upgrade from 15.3 to 17.1 . I successfully upgraded but my new PGDATA is very small size and still referencing the old PGDATA dir because it has used --link option.

Can anyone guide me on how to remove the previous PGDATA and fully rely on the new PGDATA..

Kind Regards,

Muhammad Yousaf Maqsood

cell# +923134039397

Re: pg_upgrade utility with --link option

From
daur exp
Date:
Hello, may be u need just edit .bash_profile file and put correct PGDATA path?

ср, 18 дек. 2024 г. в 14:58, M.Yousaf Maqsood <m.yousaf.maqsood@gmail.com>:
Hi Team,

I hope you are doing well.  Have anyone of you tried pg_upgrade with --link option .

I was trying to upgrade from 15.3 to 17.1 . I successfully upgraded but my new PGDATA is very small size and still referencing the old PGDATA dir because it has used --link option.

Can anyone guide me on how to remove the previous PGDATA and fully rely on the new PGDATA..

Kind Regards,

Muhammad Yousaf Maqsood

cell# +923134039397

Re: pg_upgrade utility with --link option

From
Scott Ribe
Date:
Those are hard links. If you're successfully running PG 17 against the new dir, just delete the old one.

https://linuxhandbook.com/hard-link/

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Dec 15, 2024, at 6:16 AM, M.Yousaf Maqsood <m.yousaf.maqsood@gmail.com> wrote:
>
> Can anyone guide me on how to remove the previous PGDATA and fully rely on the new PGDATA..
>