Allow Remote Connections to PostgreSQL

Configure PostgreSQL to accept connections from other machines. Pair with a firewall rule.

Configures PostgreSQL to accept connections from remote hosts by editing postgresql.conf (listen_addresses) and pg_hba.conf (host auth rules). Restart required after changes.

When you need this: When an application on another server needs to connect to PostgreSQL, or for dev tools like TablePlus.

Variables

Command


        

    







    9 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.