[postgis-users] database backup?

[Norman Vine]

Christoph Spoerri writes:
> 
> 
> Now, I have two more questions (not urgent, but still worth discussing)
> 
> 1) what do you do if you have objects (blobs) in the database. 

store the blobs as files in the normal file system

> 2) How do you back up a 100GB+ database? Split the static and dynamic data 
> into two separate databases, and back up only the dynamic nightly?

Divide and conquer,  see answer for (1) above

HTH

Norman