OpenBSD Journal

databases/postgresql, update to the 8.2.x series

Contributed by Marc Balmer on from the dept.

some time in the past I updated our port of the PostgreSQL database to version 8.2.x. We had version 8.1.x in the tree, so the update will require you to do a database dump prior to the update and a restore after it.
please make sure to read the release notes at
http://www.postgresql.org/docs/current/static/release-8-2.html
_before_ you update, it contains important information on the
changes and also on how to proceed with the update.

we will try to make the update as easy as possible using the
pkg_tools, but this information beforehand should already
help to make you aware that this is an update that we can
not completely automate. our pkg_tools are designed to
flawlessly replace software, but can of course not cope with
all data produced by third party software. you manual
intervention is required to safeguard all your data before
the update and make it available again after it.

if you are unsure and your database works well for you,
please consider if you need the update at all.

(Comments are closed)


Comments
  1. By Anonymous Coward (85.222.21.198) on

    Great! Thanks!

  2. By Anonymous Coward (68.227.41.220) on

    From the changelist:
    "Add a configure flag to allow libedit to be preferred over GNU readline (Bruce)

    Use configure --with-libedit-preferred. "
    Any chance to make this the default?

    Comments
    1. By Chris (194.193.52.249) chris@chris.net on www.chris.net

      > From the changelist:
      > "Add a configure flag to allow libedit to be preferred over GNU readline (Bruce)
      >
      > Use configure --with-libedit-preferred. "
      > Any chance to make this the default?

      Not sure about the OpenBSD libedit, but with NetBSD the Postgres clients dump core when they're linked against it.

      Comments
      1. By Anonymous Coward (213.153.32.181) on

        > > From the changelist:
        > > "Add a configure flag to allow libedit to be preferred over GNU readline (Bruce)
        > >
        > > Use configure --with-libedit-preferred. "
        > > Any chance to make this the default?
        >
        > Not sure about the OpenBSD libedit, but with NetBSD the Postgres clients dump core when they're linked against it.
        >

        http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=emu&dt=2007-02-02%2007:35:03


        Stefan

Credits

Copyright © - Daniel Hartmeier. All rights reserved. Articles and comments are copyright their respective authors, submission implies license to publish on this web site. Contents of the archive prior to as well as images and HTML templates were copied from the fabulous original deadly.org with Jose's and Jim's kind permission. This journal runs as CGI with httpd(8) on OpenBSD, the source code is BSD licensed. undeadly \Un*dead"ly\, a. Not subject to death; immortal. [Obs.]