From: Basil Bourque <basil.list@me.com>
To: pgsql-sql@postgresql.org
Subject: Re: Which version of PostgreSQL should I use.
Date: Sat, 21 May 2011 16:45:54 -0700
Message-ID: <790CEE72-260B-47DD-9507-5F65EC3FA324@me.com> (raw)
In-Reply-To: <1A897194-293D-4311-968E-E765B5A63606@thespidernet.com>
References: <1A897194-293D-4311-968E-E765B5A63606@thespidernet.com>
> We're currently using psql 8.1 and are on the way to upgrading to 8.4.
The tools "pg_dump" & "pg_restore" are used to extract and re-create databases. Can be used for chores such as deploying from development to production, backing up, and upgrading.
http://www.postgresql.org/docs/current/static/app-pgdump.htmlhttp://www.postgresql.org/docs/9.0/static/app-pgrestore.html
The tool "pg_upgrade" is intended to help you upgrade from one version to another. Think of it as a wrapper around pg_dump & pg_restore. Has a bonus feature where you can upgrade a database in place rather than re-create it if you have a huge amount of data and too little time at the moment of officially upgrading to afford re-creating the data.
http://www.postgresql.org/docs/current/static/pgupgrade.html
You may want to go to version 9 rather than 8.4.
a) 9.0 is not a major upgrade in terms of compatibility. Original plans labeled it as 8.5 for that reason. "9" was eventually chosen as a label only because of dramatic new features added.
b) Some hooks were added to 9 to allow enhancements to the 'pg_upgrade' tool. It may be actually be easier to upgrade to 9 than 8.4 for that reason.
> I have now been asked to start replicating our databases between servers - as a hot-copy / redundancy improvement.
A relatively simple and built-in replication system was one of the major features added to version 9.0.
http://www.postgresql.org/docs/current/static/high-availability.html> 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;
Version 9.0.4 is the current stable version. Version 9.1 is due out soon.
> 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
http://www.postgresql.org/docs/current/static/release.html
--Basil Bourque
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: basil.list@me.com
Subject: Re: Which version of PostgreSQL should I use.
In-Reply-To: <790CEE72-260B-47DD-9507-5F65EC3FA324@me.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox