If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No. Lets …
ClusterControl allows you to easily deploy and configure master/slave replication PostgreSQL instances, monitor queries and detect anomalies with built-in alerts, and lets you manage configurations, schedule & restore backups. It even has advanced fail over handling that detects master failures and automatically …
How to create a postgres user ? user should not have any DDL execution permission on postgres database. and the user should not connect other database means user need to restrict the other database connectivity How to achive this ? …
PREREQUEST : ============ 1. OpenSSL should be install on both client and server systems 2. Confirm whether openssl is installed or not . nijam@2ndquadrant.in:~ # rpm -qa|grep -i openssl openssl-1.0.2j-60.52.1.x86_64 libopenssl1_0_0-1.0.2j-60.52.1.x86_64 python-pyOpenSSL-16.0.0-4.17.1.noarch 3. Checking openSSL version : nijam@2ndquadrant.in:~ # openssl …
Below are ours server , xlog & archive details PRIMARY / MASTER: ================ postgres@tutorialdba_1:> ps -ef|grep postgres postgres 4436 1 0 Jun25 ? 00:05:04 /opt/10.6/bin/postgres -D /data postgres 4437 4436 0 Jun25 ? 00:00:00 postgres: logger process postgres 4439 4436 0 …
Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. ora2pg version 20.0 software : …
In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, …
In this tutorial, we will show you how to install PostgreSQL by using source code/RPM on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …
In this tutorial, we will show you how to install PostgreSQL by using source code on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …
In this tutorial, we will show you how to install PostgreSQL on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other …
In this tutorial i will explained about how to enable archivelog in postgresql server WAL Archive log In PostgreSQL database system, the actual database ‘writes’ to an addition file called write-ahead log (WAL) to disk. It contains a record of …
To keep 7 days of logs, one log file per day named postgresql-Mon.log, postgresql-Tue.log, etc, and automatically overwrite last week’s log with this week’s log. logging_collector=on log_filename = ‘postgresql-%a.log’ log_directory = ‘log’ log_rotation_age = 1d log_truncate_on_rotation=on
In this blog we are telling about How to do oracle schema referesh from production to DEV & SIT environment. Right now we are taking backup of umar schema after that we can restore the schema to SIT & DEV …
I. TAKING TABLE STRUCTRE BACKUP WITH THEIR’S OBJECT FILE NAME : Below scripts helpful to take backup (DDL’s) of procedure, function & table definition with individual file system (object name) based on postgres schema . 1. Windows Script for taking …
unable to restart the postgres server after enabling archivelog , we are getting below error while restarting the postgresql database . Below steps are we followed to enable archiver. archive_mode =on # enables archiving; off, on, or always # (change …