Is there any tool to migrate from SQL to PostgreSQL?
To migrate data, you can use the EDB Migration tool kit, a part of the EnterpriseDB subscription.
How can Postgres support multitenant?
Postgres instance has three default databases in it, and users can create multiple databases in the future as per their application requirement. It means one Postgres instance can have many databases, and each database may cater to the need of specific applications. So for microservices architecture, you can host multiple databases on a single Postgres
Does Postgres have MOS Documents like oracle, and please provide some details on Support in case of issues?
Postgres has the PostgreSQL community, where all the email archives are maintained about old queries by community members. One needs to search through the email archives to get available solutions for their issues, but the community maintains no MOS-like documents.
Just like in SQL express version, does it supports 10GB of DB? What about in PostgreSQL?
Postgres being an open source database, there are no restrictions on database size, unlike proprietary databases like Oracle, MS SQL server where database capabilities are subjective to the license that is bought by the customer.
If Version up-gradation of PG can be automatic in the VM based installations?
Postgres major or minor version upgrade is not automatic though it has simple steps to follow. You should execute those steps to upgrade, but compared to other database product upgrade in Postgres is quite straightforward.
What key factors must one consider while upgrading a Postgres to a significant version on AWS, e.g., from version 10 to version 13?
For upgrading Postgres on AWS EC2 machines, the steps would be the same as that of on-premises Postgres deployment. Check the release note of the latest version for any incompatibilities. Take the backup of the Postgres database that you plan to upgrade. Test upgrade in UAT environment and test the application against the latest upgraded
Is any tool available for migration from other DBS?
You can use EDB runMTK tool for data migration from Oracle, MySQL, and MS SQL servers.
If it’s async, don’t you think it’s not real-time replication or considered it as near real-time replication?
Asynchronous replication is real-time replication. The significant difference between Asynchronous and Synchronous replication is, Synchronous replication would wait for confirmation from the standby server that it has received all the WAL changes, and then only commit confirmation is given for the corresponding transaction, whereas in async replication master database does not wait for confirmation from
Suppose my barman server is installed on PG version 9.6.is Postgres 13 version server. Can we configure on Barman the server running on 9.6.is it compatible?
BARMAN is a backup tool, so it does not need the Postgres database to install it. Barman documentation gives information about which minimum version of Postgres it supports, and accordingly, you need to install BARMAN software. However, it's always advisable to use the latest version of BARMAN.