| From: | Jani Averbach <jaa(at)jaa(dot)iki(dot)fi> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dump, custom format and changes in the dump file |
| Date: | 2005-03-21 21:49:40 |
| Message-ID: | 20050321214940.GI9590@jaa.iki.fi |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
We have a system where we take periodic dumps from PgSQL 8.0.1
database and put those dumps under version control (Subversion).
Now the problem is that when we take a custom format dump with:
pg_dump --format=c --compress=0 --column-inserts \
--use-set-session-authorization \
db_name > db_dump_file
The dump file has been changed when at the same time taken ASCII dump
(--format=p) is identical to the previous one.
So, Is there any way to stabilize pg_dump with custom format so that
the dump file won't change without real db changes?
Thank you for your help,
Jani
--
Jani Averbach
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-21 22:56:54 | Re: Excessive growth of pg_attribute and other system tables |
| Previous Message | Ivo Rossacher | 2005-03-21 20:56:54 | Re: submit data from php: error with special character in the posted text |