Restore PostgreSQL from Backup

Restores a PostgreSQL dump to a database. For .sql files use psql redirect; for pg_dump custom format use pg_restore. The target database must exist first.

When you need this: After a failed migration or when restoring from a backup on a new server.

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
                    
                                                                
                        Backup PostgreSQL Database
                    
                                    

    





        

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