Στις Πέμπτη 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
