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