From: | Patrick Coulombe <pcoulombe(at)mediacces(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | from 6.5 > 7.1, cannot pg_dumpall. |
Date: | 2001-10-06 18:28:39 |
Message-ID: | 004001c14e94$b833e6a0$6b0e8242@caroline |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi,
i'm ready to upgrade (i know) to 7.1, but i have a big problem in my
[PostgreSQL 6.5.3] :
medias=> select * from contacts_secteurs;
... freeze ...
medias=> select * from contacts_secteurs where contact_id = 534;
contact_id|soussecteur_id|secteur_id
----------+--------------+----------
534| 118| 6
534| 114| 1
(2 rows)
so, i cannot pg_dump this database = cannot upgrade !
the vacuum command freeze also, but wait, i just try it, and here the result
:
medias=> vacuum;
NOTICE: Rel contacts: TID 223/38: OID IS INVALID. TUPGONE 1.
NOTICE: Rel medias_categories: TID 28/81: OID IS INVALID. TUPGONE 0.
NOTICE: Rel contacts_secteurs: Uninitialized page 66 - fixing
NOTICE: Rel contacts_secteurs: Uninitialized page 67 - fixing
...
NOTICE: Rel contacts_secteurs: Uninitialized page 526 - fixing
NOTICE: Rel contacts_secteurs: Uninitialized page 527 - fixing
NOTICE: Index contacts_secteurs_contact_id_ke: pointer to EmptyPage (blk
527 off 169) - fixing
... freeze ...
like i said in past post (no answer), i don't want to loose data in my
upgrade, can someone try to help me to fix this, so i can be like you with a
good and stable version. if possible, this week-end, cause i have a vacation
on monday.
patrick
From | Date | Subject | |
---|---|---|---|
Next Message | postgresql | 2001-10-06 20:18:26 | Re: from 6.5 > 7.1, cannot pg_dumpall. |
Previous Message | nandalal gunaratne | 2001-10-06 07:43:02 | installation problem -please help |