From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_upgrade: What is changed? |
Date: | 2006-08-23 08:26:19 |
Message-ID: | 44EC112B.5010704@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm working on pg_upgrade concept. I try to determine what is changed
from 8.1 to 8.2. There is list of important areas for upgrade and
suggested action.
1) BKI - catalog.
There are a lot of changes. See attached file.
a) There is new table pg_shdescription
action: create
b) There is new record in some tables.
action: insert
question: Should be any OID conflict during insertion?
c) Some records are changed
action: ???
d) Some record are removed
action: keep it
question : Is it safe to keep for example record in the pg_proc?
2) GUC - postgresql.conf
a) New variable.
action: nothing
b) Some changes (default, context)
action: nothing
c) backslash_quote is removed
action: removed from postgresql.conf
There is list of GUC changes:
ssl (assign hook)
array_nulls (new)
escape_string_warning (default false->true, context
PGC_INTERNAL->PGC_USERSET)
allow_system_table_mods (new)
ignore_system_indexes (new)
post_auth_delay (new)
join_collapse_limit (description)
backslash_quote (removed)
search_path (default $user,public -> \"$user\",public)
3) pg_hba.conf, pg_ident.conf
no changes
4) Disk layout is same - version 3
5) Tuples
question: Does have data types some disk representation?
Does have tupleheader same structure?
6) Indexes
question: Any changes on disk representation?
Should be possible remove all index before upgrade and recreate
them on the new version instead upgrade index structure?
7) Change PG_VERSION files
8) WAL/XLOG
Question: Should be deleted?
9) ...
Any other ideas?
Zdenek
Attachment | Content-Type | Size |
---|---|---|
bki.diff.gz | application/x-gzip | 5.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-08-23 08:27:46 | Re: seahorse again failing |
Previous Message | Magnus Hagander | 2006-08-23 08:24:52 | Re: seahorse again failing |