Date: Sat, 29 Sep 2012 10:41:55 +0100 From: Chris Rees <utisoft@gmail.com> To: Axel Rau <Axel.Rau@chaos1.de>, Alexander Pyhalov <alp@rsu.ru> Cc: pgsql@freebsd.org, freebsd-ports@freebsd.org Subject: Re: Question about postgresql 9 and pg_upgrade Message-ID: <CADLo83_t_=CaV_8UBUAK1WNoV3dDo8SH=BAhSMjAGELvxCjXAg@mail.gmail.com> In-Reply-To: <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> References: <4C985BA2.5060906@rsu.ru> <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE>
next in thread | previous in thread | raw e-mail | index | archive | help
On 29 Sep 2012 09:49, "Axel Rau" <Axel.Rau@chaos1.de> wrote:
>
>
> Am 21.09.2010 um 09:15 schrieb Alexander Pyhalov:
>
> > All latest PostgreSQL ports has conflicts with earlier versions. May
this be corrected in some way (for example, modify CONFLICTS variable and
install each new PostgreSQL version in its own directory, e.g.
${LOCALBASE}/postgresql/XX/, where XX is 90 , 91 and so on). This will
allow us to use pg_upgrade to upgrade databases (it needs binary files from
both new and old postgresql version).
> >
> > How do you advise to solve this problem? Should we compile postgresql
from sources and avoid using databases/postgresql*-server ports?
> Did anybody find a good solution for this?
> I'm just planning upgrade from 9.1.x to 9.2.x.
Sorry for the delay in replying (major delay!)
We (pgsql@) are dreamily considering ways to mitigate this problem, by
perhaps versioning the data directories, but the sad fact is that its going
to be pretty difficult to do without migration by most people on upgrades.
Added to the fact that databases are almost always mission-critical, we're
reluctant to mess about until something's properly tested.
Sorry to say, but the only current upgrade path is stop database, dump,
upgrade, restore, restart.
Minimum downtime is;
# cd /usr/ports/databases/postgresql92-server
# make
# service postgresql stop
(dump database)
# pkg_delete -fx postgresql-server
# make install clean
(Restore database)
# service postgresql start
I hope we'll have a solution soon.
Chris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CADLo83_t_=CaV_8UBUAK1WNoV3dDo8SH=BAhSMjAGELvxCjXAg>