Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group