Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Location
    Knoxville, TN
    Posts
    4

    Unanswered: Tablespace Recovery in PostgreSQL

    Is it possible to do a tablespace recovery in PostgreSQL? The recoveries I have been testing have been full database. However, if it is possible to do just a tablespace recovery, I need to find out how to do it and test/document it.

    Thanks,

    Sandra

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    You didn't mention which version of PostgreSQL you are using, but a quick Google search found online documentation that indicates it is possible and provides details on the methodology. The site has manuals for versions from 7.4 to 8.3, hopefully one will work.

    PostgreSQL: Documentation

    Hope this helps.

  3. #3
    Join Date
    Mar 2009
    Location
    Knoxville, TN
    Posts
    4
    We are using 8.3.6 currently. I have created a hotbackup script using the pg_hotbackup perl script. However, I looked at the documentation again and found the following paragraph.


    "As with the plain file-system-backup technique, this method can only support restoration of an entire database cluster, not a subset. Also, it requires a lot of archival storage: the base backup might be bulky, and a busy system will generate many megabytes of WAL traffic that have to be archived. Still, it is the preferred backup technique in many situations where high reliability is needed. "

    It looks like it does not allow me to do just a tablespace recovery.

    Sandra

  4. #4
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    You are correct. Not sure what I was thinking. I do not see anything about tablespace recovery.

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    I believe the main issue is that it is entirely possible to have a table in any one of a number of individual tablespaces, indexes possibly in others, etc. The problem is thus ensuring that one backed up tablespace is of the exact same 'vintage' as the rest of the tablespaces. (all related database objects would have to be of the same vintage in order to be consistent.)
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •