pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedusing pg_upgrade on FreeBSD for postgresql installed by ports
4+ messages / 3 participants
[nested] [flat]
* using pg_upgrade on FreeBSD for postgresql installed by ports
@ 2013-11-11 16:42 Luca Ferrari <fluca1978@infinito.it>
0 siblings, 2 replies; 4+ messages in thread
From: Luca Ferrari @ 2013-11-11 16:42 UTC (permalink / raw)
To: pgsql-admin
Hi all,
is there any best practice in using pg_upgrade to upgrade a cluster
installed using ports on FreeBSD? I mean, the port will install the
binaries over the previous installation therefore removing the old
binaries. May be using the "working" directory before the port get
installed?
Thanks,
Luca
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: using pg_upgrade on FreeBSD for postgresql installed by ports
@ 2013-11-11 19:47 Alejandro Brust <alejandrobrust@gmail.com>
parent: Luca Ferrari <fluca1978@infinito.it>
1 sibling, 1 reply; 4+ messages in thread
From: Alejandro Brust @ 2013-11-11 19:47 UTC (permalink / raw)
To: pgsql-admin
Hello
I recommend you to install the new version in other directory (start the
cluster on other port.... first) and perform the backup with de "NEW"
client.
Restore the backup(with de "NEW" client), test...and test...and compare.
Then U could promote the new one version to production.
Hope it help
El 11/11/2013 13:42, Luca Ferrari escribió:
> Hi all,
> is there any best practice in using pg_upgrade to upgrade a cluster
> installed using ports on FreeBSD? I mean, the port will install the
> binaries over the previous installation therefore removing the old
> binaries. May be using the "working" directory before the port get
> installed?
>
> Thanks,
> Luca
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: using pg_upgrade on FreeBSD for postgresql installed by ports
@ 2013-11-12 07:10 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Luca Ferrari <fluca1978@infinito.it>
1 sibling, 0 replies; 4+ messages in thread
From: Achilleas Mantzios @ 2013-11-12 07:10 UTC (permalink / raw)
To: pgsql-admin
Using the working directory as you wrote might be a good idea (for ephemeral use).
If you want to use the port method, generally you can solve this either by running it inside a jail (pkg -j <jail_id> install databases/postgres93-contrib) , or use the chroot option (pkg -c
<some_other_path> databases/postgres93-contrib)
However, as much as the use of ports/packages in FreeBSD is advocated over the manual installation, still, PostgreSQL (and its subprojects) are maybe one of the very few software that you normally
want to compile them by hand. I avoid the use of packages for postgresql. They don't give you much ease but restrict your flexibility.
So, what you have to do is download the postgresql version you want and compile it, along with its contrib/pg_upgrade module in place. That said, unfortunately, I didn't have much luck in FreeBSD
trying to upgrade from 9.0 to 9.2 one year ago.
You might give it a try tho. Hmm now that i think about it, i would follow the -c (chroot approach) first (the patches might have solved some problems), and if that proves to be a dependency
nightmare, then go to the "working directory" solution, then go manual.
On 11/11/2013 18:42, Luca Ferrari wrote:
> Hi all,
> is there any best practice in using pg_upgrade to upgrade a cluster
> installed using ports on FreeBSD? I mean, the port will install the
> binaries over the previous installation therefore removing the old
> binaries. May be using the "working" directory before the port get
> installed?
>
> Thanks,
> Luca
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: using pg_upgrade on FreeBSD for postgresql installed by ports
@ 2013-11-12 07:27 Luca Ferrari <fluca1978@infinito.it>
parent: Alejandro Brust <alejandrobrust@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Luca Ferrari @ 2013-11-12 07:27 UTC (permalink / raw)
To: alejandrob@pasteleros.org.ar; +Cc: pgsql-admin
On Mon, Nov 11, 2013 at 8:47 PM, Alejandro Brust
<alejandrobrust@gmail.com> wrote:
> Hello
> I recommend you to install the new version in other directory (start the
> cluster on other port.... first) and perform the backup with de "NEW"
> client.
> Restore the backup(with de "NEW" client), test...and test...and compare.
> Then U could promote the new one version to production.
Thanks, but this sounds like the "usual" pg_dump/pg_restore chain, I
was wondering about pg_upgrade.
Luca
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-11-12 07:27 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-11 16:42 using pg_upgrade on FreeBSD for postgresql installed by ports Luca Ferrari <fluca1978@infinito.it>
2013-11-11 19:47 ` Alejandro Brust <alejandrobrust@gmail.com>
2013-11-12 07:27 ` Luca Ferrari <fluca1978@infinito.it>
2013-11-12 07:10 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox