PostGreSQL File Restore

Last post 01-15-2019, 11:04 PM by Meera. 6 replies.
Sort Posts: Previous Next
  • PostGreSQL File Restore
    Posted: 01-11-2019, 12:40 PM

    Hello all,

     

            It is possible to restore only the backup files from the PostgreSQL Backups without to restore to a instance ? For Oracle Backup there is an option restore to disk, there is any similiar with Postgre ?

     

    Regards,

     

    Humberto Araújo 

  • Re: PostGreSQL File Restore
    Posted: 01-11-2019, 1:07 PM

    No there is no restore to disk feature available for PostGreSQL.

  • Re: PostGreSQL File Restore
    Posted: 01-11-2019, 1:47 PM

    Hi Humberto,

    We don't have restore to disk ability for PostgreSQL right now, but it's in the roadmap and work in progress currently. Should be available in one of the next service packs.

     

    Thanks,

    Sunil-

  • Re: PostGreSQL File Restore
    Posted: 01-11-2019, 6:40 PM
    • efg is not online. Last active: 06-13-2019, 10:25 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,658

    Hmm...  I was thinking about this and there is a way to accomplish this using a block level backup configuration.   With BLB there is an option where you can restore tables in-place, to another DB or into a dump file.  But it allows you to select the entire database, so...  using table browse pick the entire DB, and on the restore dialog (for the table import options) select "Skip Import" and specify the staging location.  This will run the restore to an auxiliary instance, and export the entire DB into a dump in the location of the staging area.  Not exactly an elegant solution but may get you what you need until we get the disk restore feature added in a future service pack


    Ernst F. Graeler
    Senior Engineer III
    Development
  • Re: PostGreSQL File Restore
    Posted: 01-14-2019, 6:06 AM

    Thank you Sunil, i´ll follow the nexts SP

  • Re: PostGreSQL File Restore
    Posted: 01-14-2019, 6:14 AM

    Thank you Ernest, i will try it. 

  • Re: PostGreSQL File Restore
    Posted: 01-15-2019, 11:04 PM

    Restore to Disk feature is not available for PostgreSQL 

    For DumpBased Backups there is a way to stage the dump file to staging location and skip import of database to server 

    Table level browse -> select database for which dump file needs to be restored -> select Skip Import in the restore options and provide staging location -> submit restore.

     

    https://documentation.commvault.com/commvault/v11/article?p=58317.htm

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy