pg_upgrade vs. pg_dump - Mailing list pgsql-admin

From Perry, Hemy
Subject pg_upgrade vs. pg_dump
Date
Msg-id CCA7F829407A9D46B8358520B195A929CE71F0D5@EU-MBX-04.mgc.mentorg.com
Whole thread Raw
Responses Re: pg_upgrade vs. pg_dump  ("Stéphane Wirtel" <stephane@wirtel.be>)
Re: pg_upgrade vs. pg_dump  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Re: pg_upgrade vs. pg_dump  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
List pgsql-admin

Hello,

 

I am planning  a migration from 9.1.7 to 9.4.0.

Based on my understanding, the recommendation is to use pg_upgrade over ‘dump and restore’.

Is that right?

 

If I want to use pg_upgrade, I need to provide the -b bindir (--old-bindir=bindir) and so my second question is what if I’ll provide 9.4 (the new PostgreSQL executable directory) also as the ‘old-bindir’, can it work that way? Always?

[I am trying to solve a problem that I might not have the old-bindir available on the machine and only the new-bindir will be available (as well as the old & new datadir of course J]

 

Thanks

Hemy

 

 

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: cannot drop an extension
Next
From: "Stéphane Wirtel"
Date:
Subject: Re: pg_upgrade vs. pg_dump