Skip site navigation (1) Skip section navigation (2)

Pg_dump and bytaA

From: "Lukas" <lukas(at)fmf(dot)vtu(dot)lt>
To: pgsql-novice(at)postgresql(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Pg_dump and bytaA
Date: 2007-03-08 20:02:07
Message-ID: 53561.85.206.198.223.1173384127.squirrel@fmf.vtu.lt (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
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...

Now we are using it like this:
pg_dump -f /home/backup/DB.sql -d -Fp -v DB

thx
Lukas


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


Responses

pgsql-novice by date

Next:From: Michael SwierczekDate: 2007-03-09 01:03:10
Subject: Re: Runaway Instances of Postmaster
Previous:From: Michael FuhrDate: 2007-03-06 06:19:08
Subject: Re: help with dynamic table name

pgsql-admin by date

Next:From: Jeff FrostDate: 2007-03-09 05:17:56
Subject: Re: Can not restore a dumped database
Previous:From: Campbell, LanceDate: 2007-03-08 17:14:00
Subject: Re: Error with postgresql-8.2-504.jdbc3.jar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group