Re: Upgrading Database: need to dump and restore?

pg_xlog and clog is something that is used during operation, and for
point in time recovery.
It doesn't go to database dump at all, not needed.

On Thu, Jun 4, 2009 at 12:32 PM, 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
> ""Grzegorz Jaskiewicz"" <gryzman(at)gmail(dot)com> wrote in message
> news:2f4958ff0906031217h2a0bfe0t674f266d4397e9ba(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran <wmoran(at)potentialtech(dot)com> wrote:
>> In response to "Carlos Oliva" <carlos(at)pbsinet(dot)com>:
>>
>>> Woudl it be possible to keep the current postgresql version running in a
>>> different port, install a new version of postgresql, and copy the data
>>> from
>>> one version to the other while both versions are running? This might give
>>> us time to copy the tables and databases one at a time and reconfigure
>>> the
>>> database access for parts of the application until we complete the
>>> migration
>>> to the new version.
>>
>> Your best bet would be to install Slony-I. One of the main design goals
>> for Slony is to allow interruption-free upgrades.
>
> I don't think it is "easy", but will do if you need to synchronize
> data before switching.
>
> --
> GJ
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
GJ