[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 по дате отправления:

Предыдущее
От: Aleksey Dashevsky
Дата:
Сообщение: Datastyle settings (fwd)
Следующее
От: "Nikolay G. Grigoriev"
Дата:
Сообщение: some questions about POstgreSQL