PostGres Database Configuration

Last post 09-16-2019, 1:58 AM by ganeshkishan. 6 replies.
Sort Posts: Previous Next
  • PostGres Database Configuration
    Posted: 09-06-2019, 6:16 AM

    Hi All,

    I want to configure PostGres Database Backup but confused which type of backup should be configured as i see two types of database backup in postgres

    1) Fs Bacsed Backup

    2) Dump based backup.

    we just want to backup databse and archive log so which type of backup is preferred here.

  • Re: PostGres Database Configuration
    Posted: 09-06-2019, 7:57 AM

    FSBased backup supports Full and incremental log backups.

    But you cannot restore indivisual databases or tables(unless you are using block level backups).

     

    DumpBased backup provides table and database level restore support.

    But you can only perform FULL backups under this.

    Here we use pg_dump/pg_restore utility provided by postgres to backup and restore databases.

     

    I suggest you to use FsBased backup as you want to backup archive logs along with databases.

  • Re: PostGres Database Configuration
    Posted: 09-06-2019, 8:55 AM

    FSBased backup supports Full and incremental log backups.

    But you cannot restore indivisual databases or tables(unless you are using block level backups).

     

    DumpBased backup provides table and database level restore support.

    But you can only perform FULL backups under this.

    Here we use pg_dump/pg_restore utility provided by postgres to backup and restore databases.

     

    I suggest you to use FsBased backup as you want to backup archive logs along with databases.

  • Re: PostGres Database Configuration
    Posted: 09-12-2019, 6:32 AM

    Hi,

    What specific permissions are needed With respect to Backup and restore for a database user which we use under commvault.

    Need specific rights which is requried for that user and not a Full DBA user.

  • Re: PostGres Database Configuration
    Posted: 09-12-2019, 8:22 AM

    Hi,

     

    To perform FsBased backups you need to have following permissions:

    Operations

    Privileges PostgreSQL User Should Have:

    Backup

    Full Database Administrator privileges.

    Restore

    Full Database Administrator privileges.

    For more information you can refer: https://documentation.commvault.com/commvault/v11_sp16/article?p=21523.htm

     

    Thanks,

    Ganesh Kishan

  • Re: PostGres Database Configuration
    Posted: 09-15-2019, 2:47 AM

    Hi Ganesh,

    I have referred to this link but these persmission require Full DBA user. Is there any sprecific permissions that can be given to a user which can be use by commvault.

    or a Full DBA access is required ?

  • Re: PostGres Database Configuration
    Posted: 09-16-2019, 1:58 AM

    Hi,

     

    You need to provide full DBA permission if you are performing FSBased backups.

     

    Thanks,

    Ganesh Kishan

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