The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backup Postgresql

Discussion in 'Database Discussions' started by alexandz, Oct 28, 2011.

  1. alexandz

    alexandz Well-Known Member

    Joined:
    Oct 28, 2011
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Chile
    cPanel Access Level:
    Root Administrator
    How to backup postgresql?
     
    #1 alexandz, Oct 28, 2011
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You can back up postgres with the following commands in root SSH:

    Code:
    su - postgres
pg_dumpall > /tmp/pg111102
exit
    This would save the dump file to /tmp with the name pg111102 (for today's date). You can name the file whatever you prefer and put it into any location you prefer.

    To restore the database dump, you’d do the following:

    Code:
    su - postgres
psql -f /tmp/pg111102 template1
exit
     
    #2 cPanelTristan, Nov 2, 2011
  3. alexandz

    alexandz Well-Known Member

    Joined:
    Oct 28, 2011
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Chile
    cPanel Access Level:
    Root Administrator
    Thank you :)
     
    #3 alexandz, Nov 7, 2011
  4. riyast

    riyast Registered

    Joined:
    Nov 15, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    For taking postgresql backup one can follow the steps below:

    Login to the server VIA ssh,
    su - postgres
    pg_dumpall > /tmp/backup_filename
    exit

    For restoring the backup
    su - postgres
    psql -f /tmp/backup_filename file
    exit


    Riyas
     
    #4 riyast, Nov 15, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Backup Postgresql
  1. Deker

    Timeout on editing the backup destination password

    Deker, Jun 24, 2017 at 4:22 PM, in forum: General Discussion
    Replies:
    3
    Views:
    40
    cPanelMichael
    Jun 26, 2017 at 2:13 PM
  2. Erel

    Backup doesn't seem to work

    Erel, Jun 23, 2017 at 2:34 AM, in forum: Data Protection
    Replies:
    4
    Views:
    62
    cPanelMichael
    Jun 26, 2017 at 11:39 AM
  3. jndawson

    Backup to remote has auth issues

    jndawson, Jun 21, 2017 at 3:17 PM, in forum: Data Protection
    Replies:
    6
    Views:
    86
    cPanelMichael
    Jun 23, 2017 at 11:45 AM
  4. Zoee

    Duplicate Backup of One Account?

    Zoee, Jun 21, 2017 at 5:05 AM, in forum: Data Protection
    Replies:
    3
    Views:
    63
    cPanelMichael
    Jun 21, 2017 at 10:32 AM
  5. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    86
    Naila
    Jun 22, 2017 at 1:35 PM

Share This Page