"Loic d'Anterroches" <diaeresis@xxxxxxxxx> writes: > Each night I am running: > pg_dump --blobs --schema=%s --no-acl -U postgres indefero | gzip > > /path/to/backups/%s/%s-%s.sql.gz > this for each installation, so 1100 times. Substitution strings are to > timestamp and get the right schema. This seems like a pretty dumb way to go at it. Why don't you just do one -Fc dump for the whole database? If you ever actually need to restore a single schema, there's a pg_restore switch for that. > I think that pg_dump, when looking at the objects to dump, also it is > limited to a given schema, is scanning the complete database in one > those calls: Yes, it has to examine all database objects in order to trace dependencies properly. > Is there an option: "I know what I am doing, do not look outside of > the schema" available which can help in my case? No. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
