Re: Pg_dump and bytaA

Στις Παρασκευή 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.

> Lukas
>
> > Στις Πέμπτη 08 Μάρτιος 2007 22:02, ο/η Lukas
> >
> > έγραψε:
> >> Hello,
> >>
> >> we have one table in database (db has over 200 tables), which has one
> >> byteA filed for storing user photos. We are making backup every night,
> >> but
> >> it is now too large because of photos. We do not need to make backup of
> >> photos every night, but the question is how to backup database without
> >> this field?
> >> I tried to look at keys of pgdump, but found nothing...
> >
> > This isnt directly possible.
> > You could have a mirror of the database,
> > and nullify these bytea columns in the mirror db before
> > taking the dump of this mirror db.
> >
> >> Now we are using it like this:
> >> pg_dump -f /home/backup/DB.sql -d -Fp -v DB
> >>
> >> thx
> >> Lukas
> >
> > --
> > Achilleas Mantzios
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content, and is believed to be clean.

--
Achilleas Mantzios