How To Load PostgreSQL Sample Database In this tutorial, we will see How to load the PostgreSQL sample database into the PostgreSQL server. In this demonstration, we will see two methods to restore: 1). Using pg_restore command utility 2). Using pgAdmin Graphics Tool Load the sample database using psql (pg_restore) tool Step 1. Download sample
How to Install pgAdmin (Graphical Interface tool) on Windows 10 in PostgreSQL In the previous blog, we saw How to Install PostgreSQL 13 on Linux, Click here to read more. We can use a command-line utility called psql to administer PostgreSQL Server. But if you want you can install a graphical tool called pgAdmin. This
Enable Remote Connection on PostgreSQL In the previous blog, we saw How To Install PostgreSQL 13 on Linux. Click here to read more. By default, PostgreSQL installation is operating through a socket on the localhost. So remote connection will not work, To make it work we need to enable remote connection in couple of configuration
Install PostgreSQL 13 on Linux Using YUM Command In this blog, we will see How to download and install PostgreSQL 13 on Oracle Linux Server release 7.9. You can get all required commands to install PostgreSQL on Linux from PostgreSQL documentation. Click here to download/follow the steps for PostgreSQL 13 on Linux. Once click on
Fixing OGG-01161 Bad Column Index (77) Specified for the Table In this blog we will perform require steps to resolve OGG-01161 Bad column index (77) specified for the table in Oracle Goldengate, This error occurs when the target table doesn’t match the source table, there is a mismatch on columns between source and target. OGG Setup –
Unable to Add Trandata in Oracle Golden Gate (OGG) In the process of data replication using Oracle GoldenGate (OGG ) the first step and important is assuring that all the needed information and changes have been written to the database redo log files. By default, the database does not write all the information that might
Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File In this blog we will perform require steps to resolve ERROR OGG-05500 Detected database metadata mismatch between current trail file OGG Setup – Source (Window Server) OGG Setup – Target (Linux Server) Step 1. Replicat Process Abended in Target: As you will notice Replicat RC232
How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix
How To Bootstrap MySQL Router For InnoDB Cluster Bootstrap MySQL Router against an InnoDB Cluster to automatically configure the routing of incoming client connections to mysql instances. To bootstrap MySQL Router at the command-line, pass in the –bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to
Changing InnoDB Cluster Topology in MySQL By default, an InnoDB Cluster runs in single-primary mode, where the cluster has one primary server that accepts read and writes queries (R/W), and all of the remaining instances in the cluster accept only read queries (R/O). When you configure a cluster to run in multi-primary mode, all of
