| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Subject: | Re: Very vague pg_dump question ... |
| Date: | 2005-07-08 23:29:18 |
| Message-ID: | 200507081629.18774.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Marc,
> I'm currently looking into a problem that a client is reporting that
> pg_dump from 8.0.3 is 'skipping' one of their sequences ... I'm waiting
> for more info, but am curious if anyone knows (or can think of?) any
> reason why this might happen? The only thing I can think of is that the
> sequence is owned by someone other then who the database is being dump'd
> as, and has no permissions to 'read' it ... but anything I'm not
> thinking of?
I've encountered databases where a continuous upgrade from 7.2 can cause
bad dependencies which make certain objects get dropped. Usually running
pg_depends fixes this.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2005-07-09 00:29:06 | Re: Very vague pg_dump question ... |
| Previous Message | Tom Lane | 2005-07-08 23:19:39 | Re: Very vague pg_dump question ... |