[Admin] Upgrading DB from 6.1 to 6.3.2
От | Catherine.Chat@inria.fr (Catherine Chat, INRIA) |
---|---|
Тема | [Admin] Upgrading DB from 6.1 to 6.3.2 |
Дата | |
Msg-id | 199808261441.QAB03403@maillol.inria.fr обсуждение исходный текст |
Список | 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.Chat@inria.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 -----------------------------------------------------------------
В списке pgsql-admin по дате отправления: