Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 11 Apr 2014 03:22:38 +0400 (MSK)
From:      Dmitry Morozovsky <marck@rinet.ru>
To:        Steven Schlansker <stevenschlansker@gmail.com>
Cc:        Matthew Seaman <matthew@freebsd.org>, freebsd-pkg@freebsd.org
Subject:   Re: Installing bacula-server with PostgreSQL 9.2
Message-ID:  <alpine.BSF.2.00.1404110318050.5834@woozle.rinet.ru>
In-Reply-To: <6534BBBF-4D98-4FCB-A9AC-4564B0373E08@gmail.com>
References:  <413DCEA9-DE6D-4834-B9F1-6C08C7BE5F2C@likeness.com> <533CF8EB.7090403@FreeBSD.org> <6534BBBF-4D98-4FCB-A9AC-4564B0373E08@gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, 3 Apr 2014, Steven Schlansker wrote:

> > The dependency on postgresql90 is "baked into" the compiled package, and
> > it is not possible to use that package with a different version of
> > postgresql. Apart from anything else, any binaries are linked against
> > the specific ABI versions of shlibs provided by the postgresql client
> > package. 'pkg set -o' is not an answer in this case,
> 
> That?s very unfortunate!  I would expect a binary built against libpq 9.0
> to work fine when linked with libpq 9.3, but can?t say that I know exactly
> how good PostgreSQL is about binary compatibility.

The PostgreSQL team is quite straight about it: there's no promises regarding 
binary compatibility when you're changing important (in PgSQL case, second 
number) version part; hence, whenever you're drifting from N.M to N.M+1 you're 
basically forced to to dump/resore or replication.  There were some exceptions, 
but usually you should be ready to set up new server and then migrate your 
database one way or another...

-- 
Sincerely,
D.Marck                                     [DM5020, MCK-RIPE, DM3-RIPN]
[ FreeBSD committer:                                 marck@FreeBSD.org ]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.1404110318050.5834>