On Mon, Mar 8, 2010 at 5:46 PM, John R Pierce
<pierce@hogranch.com> wrote:
I hear you, but I am not willing to throw in the towel, just yet... Generally speaking, is there a lot of metadata that would need to be exported? As I think about this, I am thinking I would have to read in ALL the system tables and find all the different parts to make up all the different aspects of all the stuff in the tablespace, like the tables, columns, views, stored procs, etc. It isn't a matter of just dumping one or two tables, but a matter of combing lots of tables and exporting lots of very specific pieces of those tables. Correct?
pg_dump -Fc dbname >filename.dump
One of the cases I need to be concerned with is the case where the application is shut down, the user goes in and deletes the tablespace folder by way of deleting the parent folder. How will PostgreSQL handle such a situation?
Sam