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
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 varying fields are used in queries joining to integers. The ol
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
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.* ?
would the upgrade to 7.4.* require serious changes in the a
