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.
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.
During the backup you can get the following error message:
[SRV:8007#1326] Authorization failed. Computer name: <computer name>. Username: <user name>. Domain: <domain> > The user name or password is incorrect Computer name: <computer name> Continue reading [SRV:8007#1326] The User Name or Password is Incorrect
SQLBackupAndFTP application (SBF) communicates with https://api.sqlbak.com – below are the details. At no point any of the passwords or secret keys are being sent to SQLBackupAndFTP servers. Still, you may want to know what information is being exchanged in order to understand that your security and privacy is not compromised or to configure your firewall or proxy server if any issues arise.
SBF connects to api.sqlbak.com web server to upload the data as described below. If there is an issue connecting to api.sqlbak.com – make sure that “SQLBackupAndFTP (SQL Server backup)” Windows service can connect to api.sqlbak.com:443. If the app connects to Internet through a Proxy server, you can set up Proxy server settings in the Tools -> Proxy Settings menu.
When a user installs SBF and runs it for the first time, the app posts a request to api.sqlbak.com to register the installation and activate a Professional Trial license. The app requests api.sqlbak.com server in few times in a day to validate the Professional Trial license.
When a user enters a license key into SBF, the app posts a request to api.sqlbak.com to register the license for the installed app. The app requests api.sqlbak.com server in few times in a day to validate the current license. If SBF can not validate a license at least once in 24 hours, the license is downgraded to the Free edition.
SBF can show text and graphics with ads, notifications or announcements at the bottom of the main window. The app requests api.sqlbak.com server in few times in a day to request such content (if any). This feature does not throw an error the Internet connection is missing.
When user sends email via our servers using “Automatic/Zero-config” option (default for trials and paid editions with active subscriptions) – SBF communicates with api.sqlbak.com to upload backup log. These log records do not contain passwords or secret keys.
When “See backup history on the web” option is ON (in Backup Settings section – available for trials and paid editions with active subscriptions), SBF requests api.sqlbak.com to store the log records on sqlbackupandftp.com server. These log records do not contain passwords or secret keys.
Users may want to enable writing advanced log into a temporary file and send this file to SQLBackupAndFTP developer team. SBF does not send this file automatically. You can enable and send it to us using the main menu: Tools -> Advanced Log. This file does not contain passwords or secret keys.
When SBF encounters an error, SBF requests api.sqlbak.com server to send the error information including error text and stack trace. The error information does not contain passwords or secret keys.
SBF requests api.sqlbak.com server to check the app for updates. The app is updated automatically if the new version is available for the license used and “Automatically download and install updates” option in settings is ON.
When “Service down alert” option is ON and the connected server is not available (like service stopped), SBF requests api.sqlbak.com server to send an email notification. SBF also sends “Keep Alive” requests to api.sqlbak.com web service (if this option is ON).
SBF connects to a database server (local or remote) – whatever is specified in your job. If a remote connection is specified, your firewall may need to be configured to allow such connection.
SBF connects to destinations for uploading database backups – Network, FTP server, Dropbox, Amazon S3, etc – whatever is specified in your job. If a remote connection is specified, your firewall may need to be configured to allow such connection.
When you encounter an issue with SQLBackupAndFTP, to understand the problem better our support team may ask you to send us the log file. This post explains how to enable the log and send it to us. Continue reading How to send Log to developers
This step-by-step guide helps a user having a Microsoft Azure account to create Microsoft Azure SQL Server on Linux (Ubuntu) (free license) and to use the SQL Server on Ubuntu with an SSH terminal. Continue reading How to Deploy Azure SQL Server on Ubuntu (Free Lisense)
If you have an active Full-Service subscription, then by default your mail server is set to Automatic (it is actually sent through our servers) and you don’t need to configure anything. But if you use a free version of SQLBackupAndFTP, or your subscription has expired or you just want to configure your own mail servers – below are the instructions on how to do so. Continue reading How to send SQL Backup confirmations through my GMail, Hotmail or Yahoo account
SQLBackupAndFTP v11 is a culmination of years of work and our SQL backup experience with close to 1 million installations of the earlier versions. It is significantly better than the previous version in every respect (or anything else on the market). Read SQLBackupAndFTP v11 – What’s New? or How SQLBackupAndFTP 11 differs from the previous versions?
If you have used the previous versions of SQLBackupAndFTP we strongly suggest migrating to v 11. Continue reading How to migrate to SQLBackupAndFTP 11 from the previous versions
Being a managed cloud database Azure SQL Database provides built-in functionality for automatic database backups. It allows you to restore your database to any point in the past and those backups are kept in reliable geo-redundant storage. So why do we need other tools like SqlBackupAndFtp to backup of Azure SQL Database? This can be the case when you need to get a copy of your database locally, outside Azure infrastructure. In this post, you can find a step-by-step guide on how to backup the Microsoft Azure SQL Database with the help of SQLBackupAndFTP.
Continue reading How to backup Azure SQL Database to Local Machine
When you are using the master production server and there appears a need to recover the root password in MySQL, you cannot restart at once.
The remote database experts suggest a few ways by which you can come out of this situation.
Continue reading Learn the Ways to Recover MySQL Root Password without Restarting