Re: from 6.5 > 7.1, cannot pg_dumpall. - Mailing list pgsql-novice

From Patrick Coulombe
Subject Re: from 6.5 > 7.1, cannot pg_dumpall.
Date
Msg-id 003901c14ead$48b75e10$6b0e8242@caroline
Whole thread Raw
In response to Re: from 6.5 > 7.1, cannot pg_dumpall.  ("postgresql" <pgsql@symcom.com>)
List 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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.
Next
From: Patrick Coulombe
Date:
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.