[postgis-users] database backup?
Norman Vine
nhv at cape.com
Fri Oct 24 12:59:32 PDT 2003
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
More information about the postgis-users
mailing list