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
-----------------------------------------------------------------
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) |