Backup PostgreSQL Database

Dumps a PostgreSQL database to a compressed file using pg_dump with gzip. The -Fc format is more efficient but requires pg_restore; plain SQL is more portable.

When you need this: Before migrations, upgrades, or on a scheduled backup cron job.

Variables

Command


        

    







    2 views
    0 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install PostgreSQL
                    
                                                                
                        Create PostgreSQL Database & User
                    
                                                                
                        Connect to PostgreSQL as postgres
                    
                                                                
                        Restore PostgreSQL from Backup
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account — save snippets into your own collections.