On Tue, Aug 4, 2009 at 1:02 PM, Aras Angelo wrote:
> Hi All,
>
> I recently upgraded my box to the latest version. The previous one was a
> bit outdated. Apparently we have some bad structure formatting in our db
> design, cause the latest version broke our software. The issue is some
> character
On Tue, 2009-08-04 at 13:02 -0600, Aras Angelo wrote:
> I recently upgraded my box to the latest version. The previous one
> was a bit outdated. Apparently we have some bad structure formatting
> in our db design, cause the latest version broke our software. The
> issue is some character varying
On Wed, Dec 15, 2004 at 10:20:00AM -0600, Scott Marlowe wrote:
> For upgrades from one major version to the next, you'll need to:
>
> -- pg_dump all databases in the cluster. (optionally, also backup the
> files in the $PGDATA directory)
[&c.]
Or
-- install Slony-I
-- replicate from 7.3.x -> 7
2 bits of wisdom:
1. As mentioned below, always try this upgrade on a test/ offline/
sandbox/ development/ testing /etc server first
-- Clean out the $PGDATA directory (keep a copy of your pg_hba.conf and
postgresql.conf for reference)
2. A simple 'mv data/ data73/' after pg shutdown keeps your 7
On Wed, Dec 15, 2004 at 10:09:32AM -0600, Bruno Wolff III wrote:
>
> You would have to do a dump and reload to go to the 7.4 series.
...and the "If You Are Upgrading" section of the "Installation
Instructions" chapter in the documentation recommends using pg_dumpall
from the version you're upgrad
On Wed, 2004-12-15 at 03:52, Tsirkin Evgeny wrote:
> Hi all!
> We are currently running a 7.3.4 backed and planning to upgrade.
> However we can't do to much/at all changes in the applications using the db.
> So the question is to what version to upgrade :
> what is the best release from the 7.3.*
On Wed, Dec 15, 2004 at 11:52:35 +0200,
Tsirkin Evgeny <[EMAIL PROTECTED]> wrote:
> Hi all!
> We are currently running a 7.3.4 backed and planning to upgrade.
> However we can't do to much/at all changes in the applications using the db.
> So the question is to what version to upgrade :
> what is
