Re: Postgres question - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres question
Date
Msg-id 1662015.1604700817@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres question  (Holger Jakobs <holger@jakobs.com>)
Responses Re: Postgres question  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Holger Jakobs <holger@jakobs.com> writes:
> Of course pg_dump can also dump blobs, and it's even the default. You 
> may use the option --no-blobs to leave them out.
> A glance at the man page can be more informative than just hearing 
> something from someone.

Especially information as out of date as that :-(.  Glancing at the
commit log, the very first version of pg_dump (in PG 7.0) did not do
blobs, but that was fixed by 7.1.  I have a vague recollection that
--no-blobs might've been the default for a while after that, but
certainly it's been well over a decade since it wasn't default.

            regards, tom lane



pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Postgres question
Next
From: Walters Che Ndoh
Date:
Subject: Backup restore for upgrade