top | item 31874128

(no title)

castorp | 3 years ago

You need to use pg_dump from the new version, not from the old version.

discuss

order

jasfi|3 years ago

I think you found a common stumbling block. The tutorial people follow may say to run pg_dump and many people would assume you're running it from the old version.

rapind|3 years ago

Wait, what? Explain please.

OK upon further thought, what you're saying is to use the pg_dump tool that comes with the pg version you are upgrading to.

I read it as "use pg_dump instead of pg_restore"...

mh-|3 years ago

Yes. Put concisely: Use the client tools from the newest version involved for all steps.

autra|3 years ago

Yes, and usually, it means you need to use the full binary path unfortunately (because debian wrappers embedded in the package select the version from your 5432 cluster).