Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z"
| От | David G. Johnston |
|---|---|
| Тема | Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" |
| Дата | |
| Msg-id | CAKFQuwYcWQP=G45=oTHkXa5f2EN_emSJbAy1chOg+hTd_wrjmg@mail.gmail.com обсуждение исходный текст |
| Ответ на | TIL: In pg_dump, beware the combo of "-Fd" and "-Z" (Ron <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z"
|
| Список | pgsql-admin |
On Tuesday, January 19, 2021, Ron <ronljohnsonjr@gmail.com> wrote:
For a project using 9.6, I have this command backing up a database:
So, for the 12 project, I copied it over, removing the "0", since I want these backups compressed.
The versions in use doesn’t seem pertinent to the observation - this behavior hasn’t changed (at least in the docs).
Since the -Z default is "6"
It is? Where do you see this?
I assumed that would compress the backup. It didn't, acting instead like "-Z0". Removing "-Z" made it compress.
This surprised me, and is very counter-intuitive. A bug?
That we accept a -Z parameter without a number without complaint would be a bug given the documentation doesn’t indicate the number as being optional. That “-Z” and “-Z 0” are equivalent makes sense if one allows “-Z”.
David J.
В списке pgsql-admin по дате отправления: