Re: Which version of PostgreSQL should I use.

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,
>
> 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.
>
>
> 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.
>
> I have now been asked to start replicating our databases between servers - as a hot-copy / redundancy improvement.
> And subsequently have some questions, please.
>
> 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?
>
> 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.
>
> 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
>
> AS always - thanks in advance for any assistance you might be able to give us!
>
> Gavin.
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql