In this blog post, we are going to discuss causes, reasons, and solutions related to the following error “Unable to Create a PostgreSQL Instance”. Here are the error messages you can receive:
Invalid PostgreSQL User Name and Password.
or
Connection to PostgreSQL server failed.
We spent several hours composing PostgreSQL String Functions Cheat Sheet. It’s yours now, enjoy ))
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
PostgreSQL doesn’t provide a built-in job scheduler like MS SQL, MySQL, and Oracle do. So if you need to run recurring tasks (like database backup), you have to use some other external tools like pgAgent, corn, or pg_cron (on Linux), and Task Scheduler (on Windows). Let’s look at these options closer.
Here we are going to give you a short description of PostgreSQL string functions. If you prefer to have everything on one page, download our free PostgreSQL String Functions – Cheat Sheet. Continue reading Postgres String Functions
Postgres provides three fundamentally different approaches for backing up its data:
Continue reading How to Backup and Restore PostgreSQL Database on Windows
The best way to protect your MySQL databases is to make scheduled backups. But is your method convenient and reliable? Assume you need to perform MySQL databases backups every 6 hours and then send them to the FTP Server? How much time will you spend every day in such a case? With the help of SQLBackupAndFTP, you can make MySQL backup in less than two minutes. Continue reading How to Backup MySQL to FTP Server
As it is well known that the best way to protect your data safe and sound is to make regular backups. But what is the best way to backup a database in MySQL? Of course, on one hand, you can backup a database in MySQL using Command Prompt (mysqldump) and from another hand, the best and the easiest way to backup a database in MySQL is to use the SQLBackupAndFTP tool. Now let’s learn how to backup a database in MySQL using all three different methods. Continue reading Backup Database in MySQL
If you are looking for the easiest way how to backup MySQL to OneDrive we’d recommend you to use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP, you can set up schedules for making MySQL backups to OneDrive. All you need is to create a backup job that will create backups on a regular basis. Here we go: Continue reading How to Backup MySQL to OneDrive
Below we are going to show how you can easily restore your database from backup. MySQL database restoration process consists of two steps if you use Command Prompt, first, you need to create a new MySQL database and then restore a database. Or you can simply use SQLBackupAndFTP restore job. Continue reading How to restore MySQL Server backup