Re: Release cycle length

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Release cycle length
Date: 2003-11-21 21:18:26
Message-ID: 3FBE8122.9080905@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

Hello hackers

Sorry when I am talking to the gurus...

There is a database, which has a concept called "Transportable
Tablespace" (TTS). Would it not be a verry easy and fast solution to
just do this with the Tables, Index and all non catalog related files.
- You create a new db cluster (e.g 8.0).
- Generate a TTS export skript.
- Shut the (old) db-cluster (files should be consistent now, ev. do
something with the log files before).
- Move the files (eventually not needed) and
- plug it in to the new db cluster (via the export skript).

Expected downtime (without moving data files) 5-10 minutes.

Regards Oli

-------------------------------------------------------

Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland

Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli(dot)sennhauser(at)bluewin(dot)ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/

Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch

Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2003-11-21 21:23:18 Re: [HACKERS] More detail on settings for pgavd?
Previous Message Andrew Dunstan 2003-11-21 19:39:39 Re: Build farm

Browse pgsql-www by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-23 14:21:18 Cleaning up databases ...
Previous Message Dave Page 2003-11-21 21:10:55 Re: Fwd: Re: [DOCS] 7.4 official docs : Fonts?