Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Backup Postgresql

Discussion in 'Database Discussion' 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,608
    Likes Received:
    33
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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. SamAdu

    New Thread Backup creating two sets of backups

    SamAdu, Mar 17, 2019 at 4:03 PM, in forum: Data Protection
    Replies:
    2
    Views:
    45
    SamAdu
    Mar 18, 2019 at 9:40 AM
  2. Nolli

    Restoring Full Backup Question

    Nolli, Mar 16, 2019 at 8:51 PM, in forum: Data Protection
    Replies:
    1
    Views:
    63
    cPanelLauren
    Mar 18, 2019 at 2:26 PM
  3. cosmin

    Additional MySQL backup during the day

    cosmin, Mar 13, 2019 at 3:39 AM, in forum: Database Discussion
    Replies:
    1
    Views:
    74
    cPanelLauren
    Mar 13, 2019 at 2:35 PM
  4. raudabaugh

    Pruning of backups from failed transports

    raudabaugh, Mar 12, 2019, in forum: Data Protection
    Replies:
    5
    Views:
    139
    cPanelLauren
    Mar 15, 2019 at 3:44 PM
  5. Legin76

    Restore all DNS settings from backup

    Legin76, Mar 12, 2019, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    127
    cPanelLauren
    Mar 13, 2019 at 1:27 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice