Re: Upgrading Database: need to dump and restore?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Carlos Oliva <carlos(at)pbsinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading Database: need to dump and restore?
Date: 2009-06-04 14:43:05
Message-ID: dcc563d10906040743o60301057x1b5c38467e66bb0d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 4, 2009 at 5:32 AM, Carlos Oliva <carlos(at)pbsinet(dot)com> wrote:
> Thank you for your response Grzegorx.  It is helping us a great deal to
> understand the issues around backups.  Would any of the pg_xlog, pg_clog,
> etc change for a table that has a stable structure and data?  That is, the
> table undergoes several inserts and then it is never updated

Wait, are you asking this as a side question, or related to your
upgrading of your database? Because you can't take any of that stuff
with you with a major version upgrade.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Esneiker 2009-06-04 14:44:27 insert from other database
Previous Message Bill Moran 2009-06-04 14:43:02 Re: Upgrading Database: need to dump and restore?