Subject: Re: Which version of PostgreSQL should I use.
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Gavin Baumanis <gavinb@thespidernet.com>
In-Reply-To: <1A897194-293D-4311-968E-E765B5A63606@thespidernet.com>
Date: Sun, 22 May 2011 09:10:17 +1000
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <5E151F9B-CC40-4CCC-B97E-9C06A7AF876A@thespidernet.com>
References: <1A897194-293D-4311-968E-E765B5A63606@thespidernet.com>
To: Gavin Baumanis <gavinb@thespidernet.com>

Just thought I would update this myself.

Last night I managed to have a chat with some people about this on IRC.

Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have always =
used UTF-8 for encoding, too.
So the changes from 8.4 don't seem to be of a worry for us.

(I am sure that we will find SQL hidden in our app somewhere that will =
need to be modified for implicit casting...and we'll just fix those as =
we find them.)

Otherwise it seems like a simple case of using the 9.04 pg_dump / =
(pg_dumpall) application and restoring.
I also read chapters 15 / 24 of the excellent documentation about =
running both 8.1 and 9.04 at the same time and migrating a database at a =
time.

So, I suppose unless there is something obvious, (to someone else) - we =
have all the information we need.


Gavin "Beau" Baumanis


On 17/05/2011, at 9:04 AM, Gavin Baumanis wrote:

> Hi there,
>=20
> Let me first preface this with, I am not a PostgreSQL admin.
> I am a web developer who happens to use PSQL as the back-end for my =
company's app.
> We did have a dedicated DBA / system admin - but he has recently =
resigned.
> I know enough about psql - to be able to create / drop databases... =
and enough about SQL to get stuff in and out of the database.
> Beyond that - I pretty much know , nothing about PostgreSQL - thus =
this mail.
>=20
>=20
> We're currently using psql 8.1 and are on the way to upgrading to 8.4.
> This is a process that the last DBA had us start.
> And we've slowly been going through our code, getting rid of implicit =
casts as errors appear.
>=20
> I have now been asked to start replicating our databases between =
servers - as a hot-copy / redundancy improvement.
> And subsequently have some questions, please.
>=20
> Is there are a particular version of PostgreSQL that we should be =
"aiming" to upgrade to  that provides for synching of databases.
> My initial thought is;
> We should upgrade to the latest stable version - whatever that is;
> But is the answer that simple?
>=20
> What we do we also need to take into account?
> I am "pretty sure" that to get to 8.4 from 8.1 (on our staging server) =
that we had to upgrade to 8.3 first.
>=20
> So I guess I am hoping that someone might just simply know - or be =
able to pint me in the correct direction for some information about =
what's in what version and any upgrade requirements to get to XXX from =
8.1
>=20
> AS always  - thanks in advance for any assistance you might be able to =
give us!
>=20
> Gavin.
>=20
>=20
> --=20
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql