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

Bug #685: pg_dump don't works with many tables

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #685: pg_dump don't works with many tables
Date: 2002-06-07 10:30:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Victor S. (vicsanca(at)idieikon(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
pg_dump don't works with many tables

Long Description
Sorry about the last two messages. We have finally identified when the error happens. We have near 1000 tables with 3 foreings keys to three tables. Example:
Table A
Table B
Table C

Table 1--- foreign keys to A, B and C
Table 2--- foreign keys to A, B and C
Table 3--- foreign keys to A, B and C
Table 1000--- foreign keys to A, B and C

PostgreSQL works fine but if we try to do a pg_dump of the database (in verbose for debug the error) mode it breaks after 10 minutes(aprox.) when pg_dump is finding triggers for table A. The process exits with a "Killed" message.

With the same 1000 tables witout foreign keys it works fine.
Whe have tested it with PostgreSQL 7.1, 7.2 and 7.2.1 under linux systems.

Please contact us for more info if wou want.


Victor Sanchez

Another questions: Commercial support cover this type of errors?

Sample Code

No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-06-07 16:20:11
Subject: Bug #686: growing tables
Previous:From: Bruce MomjianDate: 2002-06-07 05:39:18
Subject: Re: Bug #668: cursors with params: mismatched parentheses;

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