Installing bacula-server with PostgreSQL 9.2

[Steven Schlansker]

I have a FreeBSD system I recently upgraded to FreeBSD 10-RELEASE with pkgng.

The system is a backup server.  It runs bacula-server on top of PostgreSQL 9.2.

I can no longer start the bacula director:

Starting bacula_dir.
Shared object "libstdc++.so.6" not found, required by "bacula-dir"
/usr/local/etc/rc.d/bacula-dir: WARNING: failed to start bacula_dir

I figured that I need to reinstall Bacula from the new pkg repository so
that it doesn’t have stale library dependencies:

[steven at d0028:~]% sudo pkg install -f bacula-server
Updating repository catalogue
The following 2 packages will be installed:

        Installing postgresql90-client: 9.0.17
        Installing bacula-server: 5.2.12_3

The installation will require 11 MB more space

Oh no!  I’m running postgresql92-client!

[steven at d0028:~]% sudo pkg info | grep postgres
postgresql92-client-9.2.8      PostgreSQL database (client)
postgresql92-contrib-9.2.8     The contrib utilities from the PostgreSQL distribution
postgresql92-server-9.2.8      The most advanced open-source database available anywhere

So of course this cannot install, there are conflicting files, and I don’t want it anyway.

I tried updating the origin as I’ve seen some people recommend, but it seems to have no effect.

[steven at d0028:~]% sudo pkg set -o db/postgresql90-client:db/postgresql92-client
Change origin from db/postgresql90-client to db/postgresql92-client for all dependencies? [y/N]: y

How do I get my backups back?

Thanks,
Steven