Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    3

    Question Unanswered: how to restore single .backup file (backup of multiple database in a single backup )

    how to restore single .backup file (backup of multiple database in a single backup ) on windows having postgreSQL installed

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Hop did you create the .backup file? Which exact(!) command did you use?

  3. #3
    Join Date
    Nov 2011
    Posts
    3

    Backup file is automatically created by the script written on production server

    Backup file is automatically created by the script written on production server and then this backup is updated on the standby server through the script.

    there is no direct command to take the backup but i am sending you the link
    which can probably help u.
    [URL="http://www.thegeekstuff.com/2009/01/how-to-backup-and-restore-postgres-database-using-pg_dump-and-psql/"]

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Again, WHAT was the specific syntax that YOU used ??? the pg_dumpall?

    Rather than create a single huge backup file with the entire server's contents dumped there, it's often more 'friendly' to create individual database backups.
    If it's a single file, copy the backup file to a working file, then delete everything in front of the first portion of text referencing the database name in question, and everything after the last line of SQL that references your target database.

    Then, execute the backup SQL work file, using pgadmin or pSQL.
    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
  •