Re: Schema, databse, or tables in different system folder

"Carlos Oliva" <olivac@earthlink.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/>