pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 8.3.x upgrade
5+ messages / 5 participants
[nested] [flat]
* Postgres 8.3.x upgrade
@ 2009-01-22 14:50 Jessica Richard <rjessil@yahoo.com>
0 siblings, 3 replies; 5+ messages in thread
From: Jessica Richard @ 2009-01-22 14:50 UTC (permalink / raw)
To: pgsql-admin
We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to the 8.3.x version.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres 8.3.x upgrade
@ 2009-01-22 14:57 ries van Twisk <pg@rvt.dds.nl>
parent: Jessica Richard <rjessil@yahoo.com>
2 siblings, 0 replies; 5+ messages in thread
From: ries van Twisk @ 2009-01-22 14:57 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
On Jan 22, 2009, at 9:50 AM, Jessica Richard wrote:
> We are going to upgrade our Postgres servers (most 8.2.9 and some
> 8.2.4) to the 8.3.x version.
>
> From the postgres web site, I can see the 8.3.5 is the latest version.
>
> Question for people who have been on 8.3.5:
>
> Is 8.3.5 very safe to use (no major new bugs)? Is it really better
> than the older versions of the 8.3.X families?
>
> Thanks a lot,
> Jessica
>
Did you read the release notes for 8.3.x?
There are a couple of gotchas when it comes to automatic casting that
differs between 8.2.x and 8.3.x.
Make sure you did test you app on 8.3.x, apart from that 8.3.x run
just fine and it's really better.
Ries
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres 8.3.x upgrade
@ 2009-01-22 18:47 Larry Rosenman <ler@lerctr.org>
parent: Jessica Richard <rjessil@yahoo.com>
2 siblings, 1 reply; 5+ messages in thread
From: Larry Rosenman @ 2009-01-22 18:47 UTC (permalink / raw)
To: 'Jessica Richard' <rjessil@yahoo.com>; pgsql-admin
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jessica Richard
Sent: Thursday, January 22, 2009 8:51 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres 8.3.x upgrade
We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to
the 8.3.x version.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres 8.3.x upgrade
@ 2009-01-22 18:55 Bruce Momjian <bruce@momjian.us>
parent: Larry Rosenman <ler@lerctr.org>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2009-01-22 18:55 UTC (permalink / raw)
To: Larry Rosenman <ler@lerctr.org>; +Cc: 'Jessica Richard' <rjessil@yahoo.com>; pgsql-admin
Larry Rosenman wrote:
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jessica Richard
> Sent: Thursday, January 22, 2009 8:51 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Postgres 8.3.x upgrade
>
FYI, we should point people here to explain upgrades:
http://www.postgresql.org/support/versioning
---------------------------------------------------------------------------
>
>
> We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to
> the 8.3.x version.
>
> >From the postgres web site, I can see the 8.3.5 is the latest version.
>
> Question for people who have been on 8.3.5:
>
> Is 8.3.5 very safe to use (no major new bugs)? Is it really better than the
> older versions of the 8.3.X families?
>
> Thanks a lot,
> Jessica
>
>
>
> Yes, we've been using it for a few months, and it's fine. You *ALWAYS* want
> to be using the latest
>
> version within the series. The PostgreSQL project releases those to fix
> bugs.
>
>
>
>
>
>
>
> --
>
> Larry Rosenman http://www.lerctr.org/~ler
>
> Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
>
> US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
>
>
>
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres 8.3.x upgrade
@ 2009-01-22 19:44 Scott Marlowe <scott.marlowe@gmail.com>
parent: Jessica Richard <rjessil@yahoo.com>
2 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2009-01-22 19:44 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
On Thu, Jan 22, 2009 at 7:50 AM, Jessica Richard <rjessil@yahoo.com> wrote:
> We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to
> the 8.3.x version.
>
> From the postgres web site, I can see the 8.3.5 is the latest version.
>
> Question for people who have been on 8.3.5:
>
> Is 8.3.5 very safe to use (no major new bugs)? Is it really better than the
> older versions of the 8.3.X families?
We've been running it in production since last fall and 8.3.x is a
very stable and very fast branch. We had about ten or so queries that
failed due to bad casting, that we fixed in about a day. Upgrading
postgres, even counting these small issues, is one of the least
painful upgrades I've ever done.
As for 8.3.x with x being 0 through 5 right now, the newer versions
are bug and security fixes only over 8.3.0. You want those bug fixes,
and running an older update version (i.e. 8.3.1) versus the latest
(i.e. 8.3.5) is rarely a good idea.
Unlike some database products which are known to ship later versions
that break things (**cough** MySQL **cough**) the postgresql hackers
are VERY picky about what goes into a point update.
**cough** (see http://bugs.mysql.com/bug.php?id=31001 )
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-01-22 19:44 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-01-22 14:50 Postgres 8.3.x upgrade Jessica Richard <rjessil@yahoo.com>
2009-01-22 14:57 ` ries van Twisk <pg@rvt.dds.nl>
2009-01-22 18:47 ` Larry Rosenman <ler@lerctr.org>
2009-01-22 18:55 ` Bruce Momjian <bruce@momjian.us>
2009-01-22 19:44 ` Scott Marlowe <scott.marlowe@gmail.com>
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