Re: from 6.5 > 7.1, cannot pg_dumpall.

From: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
To: postgresql <pgsql(at)symcom(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.
Date: 2001-10-06 21:24:29
Message-ID: 003901c14ead$48b75e10$6b0e8242@caroline
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> How big is this database? (how many rows?)
around 10000 rows

> Do you have more than one table?
2 big tables (10-16 col) and 18 small tables (2-3 col).

only 1 table cause me trouble :
medias=> \d contacts_secteurs
Table = contacts_secteurs
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| contact_id | int4 |
4 |
| soussecteur_id | int2 |
2 |
| secteur_id | int2 |
2 |
+----------------------------------+----------------------------------+-----
--+
Index: contacts_secteurs_contact_id_ke

and it seem that the contacts_secteurs_contact_id_ke is causing also
trouble. can i "reload" it ?

patrick

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Coulombe 2001-10-06 21:32:57 Re: from 6.5 > 7.1, cannot pg_dumpall.
Previous Message Tom Lane 2001-10-06 21:13:48 Re: from 6.5 > 7.1, cannot pg_dumpall.