Re: Pg_dump and bytaA

-b
--blobs
    Include large objects in dump.

Examples

To dump a database:
$ pg_dump mydb > db.out


To dump a database called mydb that contains large objects to a tar file:
$ pg_dump -Ft -b mydb > db.tar


> Achilleas Mantzios wrote:
>> Στις Παρασκευή 09 Μάρτιος 2007 15:05, ο/η Milen A.
>> Radev έγραψε:
>>> Achilleas Mantzios wrote:
>>>> Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas
>>>> έγραψε:
>>>>> Hello,
>>>>>
>>>>>  pg_dump can avoid bloob fields (it can dumb without blobs), but as I
>>>>> understand byteA is not bloob, so in this case what is blob? I did
>>>>> not
>>>>> found such type as blob..
>>>> Take a look at
>>>> http://www.postgresql.org/docs/7.4/interactive/largeobjects.html
>>>>
>>>> You might also consider writing a program for transforming your db/app
>>>> from bytea based to large object based, and simply exclude blobs
>>>> from your pg_dump's.
>>> How to exclude them from a custom dump? (That's for version 8.1/8.2)
>>
>> you just dont include them :)
>
> Yes, and how exactly you do not include them?
>
> For example - this is my backup script that is executed nightly:
>
> -------------------------------------------------------------------
> PSQL=/usr/local/pgsql/bin/psql
> PG_DUMP=/usr/local/pgsql/bin/pg_dump
> PG_DUMPALL=/usr/local/pgsql/bin/pg_dumpall
>
>
> $PG_DUMPALL -U postgres --globals-only > $BACKUPDIR/pg_globals.sql
>
> for db in `$PSQL -U postgres -d template1 -t -c "SELECT datname FROM
> pg_catalog.pg_database WHERE datname "\!"~ 'template(0|1)';"`
> do
>         echo -n -e "Dumping database $db...\t\t"
>         $PG_DUMP -U postgres --format=c $db > $BACKUPDIR/$db.dump
>         echo "done."
> done
> -------------------------------------------------------------------
>
> Guess what? There was a special command-line parameter for including
> large objects in the custom/tar dump until version 8.1
> (http://www.postgresql.org/docs/8.0/static/app-pgdump.html, look for
> "--blobs"). Now they are included by default AND could not be excluded,
> at least I could not find a way to do that
> (http://www.postgresql.org/docs/8.1/static/app-pgdump.html).
>
> So what are you suggesting?
>
>
> --
> Milen A. Radev
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>
> --
> This message has been scanned for viruses and
> dangerous content, and is believed to be clean.
>
>



--
This message has been scanned for viruses and
dangerous content, and is believed to be clean.