It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.
Do the -S and -O switches also make sense? Should I add them?
Chris
---(end of broadcast)---
TIP 7: don't forget to increase your free space
Josh Berkus <[EMAIL PROTECTED]> writes:
> Right. The issue is really complex databases which were developed in 7.2 or
> 7.1, which is missing the pg_depends information.In that case, pg_dump
> seems to get confused about dependency sorting, and a few objects with long
> dependency chains si
Chris,
> Nothing gets silently dropped. It will cause an ERROR on creation and
> then keep going, but it won't silently drop it... (unless it's a
> binary dump thing...)
Silently dropped on dump, not on restore.
> Anyway, pg_dump in CVS does correct dump ordering based on a topological
> sort
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> 2) pg_restore needs to be more tolerant with certain kinds of errors.
> Hmmm, dunno about this - it wasn't on my radar really. I'll experiment
> with it, but I don't think I'm going to have time before June 30th :(
I think we dealt with thi
1) When pg_dump 7.4.1 (I have not tested on CVS) pulls a dump from a 7.2
database with confusing dependancies (e.g. functions depend on views which
depend on multiple tables and other views containing other functions), some
objects (almost always functions) still get silently dropped from the du
KL-
> Would you be able to specify exactly the deficiences? It's my mission
> at the moment to make pg_dump 7.5 known-issue free :)
Well, since you asked:
(please excuse me if I'm covering old ground. I was off Hackers for almost a
month this spring)
1) When pg_dump 7.4.1 (I have not tested
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
pg_dumpall lacks the "-X disable-dollar-quoting" switch.
I can add it - do the other hackers want it?
It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> pg_dumpall lacks the "-X disable-dollar-quoting" switch.
> I can add it - do the other hackers want it?
It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.
reg
Hi Stefan,
since we have a lot of databases here that suffer from pg_dump's
deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from
the upcoming 7.5 release.
Would you be able to specify exactly the deficiences? It's my mission
at the moment to make pg_dump 7.5 known-issue free :)
Hi!
since we have a lot of databases here that suffer from pg_dump's
deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from
the upcoming 7.5 release.
This version works much better, but it is not possible to dump a
complete cluster using pg_dumpall in a 7.3 or 7.4 compatible way b
10 matches
Mail list logo
