Postgresql on linux restore and Roles (users)

Last post 04-26-2019, 1:02 PM by Hariharan. 1 replies.
Sort Posts: Previous Next
  • Postgresql on linux restore and Roles (users)
    Posted: 04-26-2019, 10:56 AM


    I have a customer who is using Posgresql 10.6 on linux (Ubuntu 16.04). My knowlledge op posgresql is very limited and the customer is doing some out of place restore tests.

    The restores are done from the dumpbased backups and after the restore completes the customer notices that the roles (users) are not restored. 

    According to books online, the dumpbased backup does backup the following:

    What Gets Backed Up

    Dump Based Backup:

    • PostgreSQL system databases
    • PostgreSQL user databases
    So I would expect that users can also be restored when doing an out of place restore. Anyone any experience with this?
  • Re: Postgresql on linux restore and Roles (users)
    Posted: 04-26-2019, 1:02 PM


    We expect users and roles to be created on the target instance for restore to be successful. However FSBasedBackupset full backup and restore, will restore users and roles also.






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.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy