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