From: Goran Thyni <goran@bildbasen.se>
To: pgsql-hackers@postgreSQL.org
Cc: Mattias Kregert <matti@algonet.se>
Subject: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches)
Date: Tue, 02 Jun 1998 16:04:18 +0200
Message-ID: <35740662.A12290FC@bildbasen.se> (raw)
References: <9806020554.AA29494@hawk.illustra.com>
<3573BFF6.65D6BC74@algonet.se>
Mattias Kregert wrote:
> How about making a file specifying what to do when upgrading from one
> version of pg to another? Then a program, let's call it 'pgconv', would
> read this file and do the conversions from the old to the new format
> using pg_dump and psql and/or some other helper programs.
I think what is needed is a replication program, since pgsql uses
socket comunication it is quiet easy to run 2 concurrent systems
say one each of 6.3.2 and 6.4 and copy beteewn them at run-time.
The easiest way would be to use dump&load but as David pointed out in
a case where dump&load takes 20 hours it means 20 hours downtime unless
we want inconsistent data (data inserted/updated while copying).
A smarter replication would make the downtime shorter since most data
would be upto date and only latest changes need to be transfer during
"update downtime".
Such a mechanism would be even more useful for other proposes like
clustering/backup/redundancy etc.
Has anyone looked as this?
The only thing I have seen is the Mariposa project which seems to be
somewhat overkill for most applications.
--
---------------------------------------------
Göran Thyni, sysadm, JMS Bildbasen, Kiruna
Attachments:
[application/x-pkcs7-signature] smime.p7s (3.0K, ../35740662.A12290FC@bildbasen.se/2-smime.p7s)
download
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-hackers@postgresql.org
Cc: goran@bildbasen.se, matti@algonet.se
Subject: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches)
In-Reply-To: <35740662.A12290FC@bildbasen.se>
* 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