By default, PostgreSQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home computer or from web server. Step # 1: Login over ssh if server is outside your IDC Login over ssh to remote PostgreSQL database server: $ ssh user@remote.pgsql.server.com Step [...]
When you work in tech support department and deal with inexperienced clients debugging problems turns into a nightmare. As a sysadmin, you won’t become too paranoid if less experienced people have root-access. As a consultant, you won’t feel isolated if you don’t have remote access to your systems. As a support engineer, you won’t become [...]
By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. If you want to remotely access to the database server from the web server or home, follow this quick tutorial.