[Admin] Upgrading DB from 6.1 to 6.3.2

From: Catherine(dot)Chat(at)inria(dot)fr (Catherine Chat, INRIA)
To: pgsql-admin(at)postgresql(dot)org
Subject: [Admin] Upgrading DB from 6.1 to 6.3.2
Date: 1998-08-26 14:41:01
Message-ID: 199808261441.QAB03403@maillol.inria.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

I've installed on a new machine (Sun Ultra10, solaris 2.6) the
version 6.3.2 of postgres using the binary package from:
ftp://ftp.postgresql.org/pub/bindist/PostgreSQL-v6.3-Solaris_v2.6.gz

Now, I try to migrate my databases from the old machine also on
solaris 2.6 to the new one. To do so, I follow the steps :

1- use pg_dumpall from the package PostgreSQL-v6.3-Solaris_v2.6 to
dump my databases on my old machine.
This generates a db.out which looks fine

2- get this db.out on my new machine
3- log as postgres super-user. perform initdb and
psql -e template1 < db.out
everything seems to work fine

4- launch psql as postgres super-user to check my tables in one of my
database :

$ psql declic
Welcome to the POSTGRESQL interactive sql monitor:
You are currently connected to the database: declic

declic=> \d
Couldn't find any tables, sequences or indices!
declic=> \q

What is the problem ??
When I perform a ls -l on $PGDATA/base/declic, It seems OK (look at
the end of my mail, I insert the ls-l result).

Can you please help me ?
Thanks in advance.

Best regards,
Catherine.

--
Catherine CHAT Tel:+33 1 3963 5737
Fax:+33 1 3963 5114
INRIA - DirDRI Catherine(dot)Chat(at)inria(dot)fr
Domaine de Voluceau - BP 105 http://www.inria.fr
78153 - Le Chesnay Cedex - FRANCE http://www.inria.fr/dirdri
-----------------------------------------------------------------

-----------------------------------------------------------------
ls -l $PGDATA/base/declic
-------------------------
-rw------- 1 postgres 4 Aug 26 16:35 PG_VERSION
-rw------- 1 postgres 57344 Aug 26 16:35 atome
-rw------- 1 postgres 16384 Aug 26 16:35 atome_idx
-rw------- 1 postgres 8192 Aug 26 16:35 compteur
-rw------- 1 postgres 8192 Aug 26 16:35 intitule
-rw------- 1 postgres 16384 Aug 26 16:35 intitule_idx
-rw------- 1 postgres 8192 Aug 26 16:35 pg_aggregate
-rw------- 1 postgres 8192 Aug 26 16:35 pg_am
-rw------- 1 postgres 16384 Aug 26 16:35 pg_amop
-rw------- 1 postgres 8192 Aug 26 16:35 pg_amproc
-rw------- 1 postgres 0 Aug 26 16:35 pg_attrdef
-rw------- 1 postgres 16384 Aug 26 16:35 pg_attrdef_adrelid_index
-rw------- 1 postgres 49152 Aug 26 16:35 pg_attribute
-rw------- 1 postgres 32768 Aug 26 16:35 pg_attribute_attrelid_index
-rw------- 1 postgres 57344 Aug 26 16:35 pg_attribute_relid_attnam_index
-rw------- 1 postgres 32768 Aug 26 16:35 pg_attribute_relid_attnum_index
-rw------- 1 postgres 8192 Aug 26 16:38 pg_class
-rw------- 1 postgres 16384 Aug 26 16:35 pg_class_oid_index
-rw------- 1 postgres 16384 Aug 26 16:35 pg_class_relname_index
-rw------- 1 postgres 65536 Aug 26 16:35 pg_description
-rw------- 1 postgres 49152 Aug 26 16:35 pg_description_objoid_index
-rw------- 1 postgres 8192 Aug 26 16:35 pg_index
-rw------- 1 postgres 0 Aug 26 16:35 pg_inheritproc
-rw------- 1 postgres 0 Aug 26 16:35 pg_inherits
-rw------- 1 postgres 2121 Aug 26 16:35 pg_internal.init
-rw------- 1 postgres 0 Aug 26 16:35 pg_ipl
-rw------- 1 postgres 8192 Aug 26 16:35 pg_language
-rw------- 1 postgres 0 Aug 26 16:35 pg_listener
-rw------- 1 postgres 8192 Aug 26 16:35 pg_opclass
-rw------- 1 postgres 65536 Aug 26 16:35 pg_operator
-rw------- 1 postgres 8192 Aug 26 16:35 pg_parg
-rw------- 1 postgres 155648 Aug 26 16:35 pg_proc
-rw------- 1 postgres 49152 Aug 26 16:35 pg_proc_oid_index
-rw------- 1 postgres 73728 Aug 26 16:35 pg_proc_proname_index
-rw------- 1 postgres 40960 Aug 26 16:35 pg_proc_prosrc_index
-rw------- 1 postgres 0 Aug 26 16:35 pg_relcheck
-rw------- 1 postgres 16384 Aug 26 16:35 pg_relcheck_rcrelid_index
-rw------- 1 postgres 0 Aug 26 16:35 pg_rewrite
-rw------- 1 postgres 0 Aug 26 16:35 pg_statistic
-rw------- 1 postgres 0 Aug 26 16:35 pg_trigger
-rw------- 1 postgres 16384 Aug 26 16:35 pg_trigger_tgrelid_index
-rw------- 1 postgres 16384 Aug 26 16:35 pg_type
-rw------- 1 postgres 16384 Aug 26 16:35 pg_type_oid_index
-rw------- 1 postgres 16384 Aug 26 16:35 pg_type_typname_index
-rw------- 1 postgres 8192 Aug 26 16:38 pg_user
-rw------- 1 postgres 0 Aug 26 16:35 pg_version
-rw------- 1 postgres 8192 Aug 26 16:35 societe
-rw------- 1 postgres 16384 Aug 26 16:35 societe_idx
-rw------- 1 postgres 0 Aug 26 16:35 xpg_user
-----------------------------------------------------------------

Browse pgsql-admin by date

  From Date Subject
Next Message Nikolay G. Grigoriev 1998-08-27 21:13:15 some questions about POstgreSQL
Previous Message Aleksey Dashevsky 1998-08-26 08:00:32 Datastyle settings (fwd)