| 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: | Whole Thread | Raw Message | 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 |