Thank you for your response Chris. It is helping us a great deal to
understand the issues around backups. Would any of the pg_xlog, pg_clog,
etc change for a table that has a stable structure and data? That is, the
table undergoes several inserts and then it is never updated.
"Chris Browne" <cbbrowne(at)acm(dot)org> wrote in message
news:87prdlgurv(dot)fsf(at)dba2(dot)int(dot)libertyrms(dot)com(dot)(dot)(dot)
> "Carlos Oliva" <olivac(at)earthlink(dot)net> writes:
>> Would the backup be unrecoverable if I shutdown the databse first?
>
> If the backup includes pg_xlog and pg_clog, as well as all of the
> database metadata files, then whatever portions *are* included are
> likely to be somewhat usable.
>
> The portions not included in the backup will obviously not be usable.
>
> But supposing your backup does not include *all* metadata (e.g. -
> pg_catalog), pg_xlog and pg_clog, then it is unlikely that you'll be
> able to recover *anything at all* from it.
>
> The intent is that filesystem backups only work for complete backup
> and restoration of an entire database cluster.
>
> Backing up *part* of your filesystem is Not Recommended in the
> documentation. If you set a policy of doing so, you have to accept
> that you are doing this contrary to documented recommendations, and at
> considerable peril to your data.
> --
> (reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
> http://cbbrowne.com/info/multiplexor.html
> Rules of the Evil Overlord #25. "No matter how well it would perform,
> I will never construct any sort of machinery which is completely
> indestructible except for one small and virtually inaccessible
> vulnerable spot." <http://www.eviloverlord.com/>