PostgreSQL

Guides on managing and optimizing PostgreSQL

August 14, 2019

How to Create a Restricted User to Connect to MySQL / PostgreSQL Remotely via GUI Client without SSH Access

Sometimes we need to add a user to a pretty locked down server just for them to login to MySQL / PostgreSQL via their GUI client without giving them any other access. It's actually pretty easy to do...

Read

December 17, 2015

How to Back Up and Restore a PostgreSQL Database

Backing up and restoring your PostgreSQL database is easy. Follow this guide and do it in 60 seconds. To back up a PostgreSQL database, we use pg_dump to save the database into a text...

Read

Sign up for our newsletter