[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] Understanding pg_dump/pg_restore
From:       Nick Sayer <nsayer () quack ! kfu ! com>
Date:       2002-10-28 16:59:42
[Download RAW message or body]

Hi. I have been a happy user of PostgreSQL for some time now. I am 
begining a project that, much to my very slight annoyance, will involve 
either CLOBs or BLOBs. My understanding is that neither is backed-up by 
pg_dumpall (my backup strategy is that I do a pg_dumpall and mark the 
actuall database itself as "don't back up"). In fact, one is encouraged 
to use pg_dump -Fc -b to do it.

1. Does this apply to CLOBs as well or only BLOBs? That is, if I used 
CLOBs, could I expect them to be backed up by the current system? If so, 
I can use CLOBs happily and just shut up right here and now. :-)

2. Moving to a binary storage format for backups is slightly more 
frightening. Is there any guarantee at all concerning the portability of 
the pg_dump -Fc output across PostgreSQL versions?


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]