Category Archives: PostgreSQL

Setting Windows PATH for Postgres tools

PostgreSQL, windols psql, wsndows psql

If, after installing PostgreSQL, you face “psql not recognized as an internal or external command” error when you try to run psql from the command prompt, then most probably all you need to do to solve this problem is to add Postgres’s bin directory to the PATH system variable (the PATH is a system variable which allows Windows with the help of the Command prompt or the Terminal window find executables).

In this blog post, we’ll share seven simple steps that describe how to add the folder to the Windows 10 PATH variable.

Continue reading Setting Windows PATH for Postgres tools →

How to Backup PostgreSQL to Amazon S3

full backup, PostgreSQL, sql backup job

How do you make your PostgreSQL database backups, with the help of pg_dump utility or in any other way? Do you prefer to store your backup in the cloud, like Amazon S3? How much time do you usually spend every day to make your database backup and send them to Amazon S3? It is really very easy to backup PostgreSQL to Amazon S3 with the help of SQLBackupAndFTP. You can create a backup job just in a few minutes. Continue reading How to Backup PostgreSQL to Amazon S3 →

How to backup PostgreSQL to Azure Storage

full backup, PostgreSQL, sql backup job

Are you sure that your method to backup PostgreSQL databases is reliable, safe, and convenient? What if you need to backup your database somewhere to the cloud, let’s say to Azure Storage. How much time will you spend every day to complete this scenario? You can do it simply with the help of SQLBackupAndFTP. Below we are going to show you how to create a backup job that will backup PostgreSQL to Azure Storage on a regular basis. Continue reading How to backup PostgreSQL to Azure Storage →

How to backup PostgreSQL with SQLBackupAndFTP

full backup, PostgreSQL, sql backup job

Starting from SQLBackupAndFTP version 12.2, you can backup and restore PostgreSQL along with SQL Server and MySQL databases. SQLBackupAndFTP backups PostgreSQL databases using the standard pg_dump tool and, currently, it allows you to create full database backups only.

All you need is to create a backup job as you did before, with the only difference being that you have to select PostgreSQL Server as a server type when establishing the connection. If you have just started using SQLBackupAndFTP, here is a short tutorial on how to create a backup task to backup your PostgreSQL databases. Continue reading How to backup PostgreSQL with SQLBackupAndFTP →