Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    Question Unanswered: Recovery In Postgresql

    I have two questions:

    1. In Postgresql, what is the name of the exact DATAFILE under the DATA DIRECTORY ?

    2. We want to prepare a backup machine (for disaster management) by passing only the ARCHIVEDIR directory from another online machine - both the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR but the recovery is not successful unless we send the FULL DATA Directory.

    Please help us in resolving this problem whereby we do not have to send the full DATA Directory.

    The version of Postgresql is 8.0.3 on SuSe Linux 9.

    Thanks and Regards

    Sumita Chatterjee

  2. #2
    Join Date
    Mar 2006
    I suggest you use the psql dump command where you can select the data you wish to backup or backup all data. It is easy to use and you can gzip the file and later pype it through to retrieve data.

    Here is a link: Postgres Chapter 23: Bakup

  3. #3
    Join Date
    Feb 2005
    Colorado Springs
    I would add, as can be seen from the PostgreSQL documentation, that pg_dump and pg_restore are very flexible and should meet your needs. You can backup/restore individual tables, schemas, indexes, data only, or schema only. You can backup to .tar, plain text, or the pg custom format (which is already compressed). In disaster recovery, a full restore involves several steps, but this process is well documented in the manual. These procedures have been available for quite some time in PostgreSQL and are well-established and stable. No need to reinvent the wheel.

Posting Permissions

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