clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases

December 22, 2020

Postgres Database Monitoring using Grafana Dashboard using template

1. We need to make sure that Grafana is installed already. 2. We need following postgresql dashboard to be imported in Grafana. https://grafana.com/dashboards/4164 3. Please download and install influxDB in postgresql server to be added in Grafana monitoring. wget https://dl.influxdata.com/influxdb/releases/influxdb-1.7.4.x86_64.rpm sudo yum localinstall influxdb-1.7.4.x86_64.rpm 4. Please configure and restart influxDB Please change influxdb.conf /etc/influxdb/influxdb.conf We need to enable it # […]

June 12, 2018

SOACS – What’s New on PaaS [Session-I]

SOACS – What’s New on PaaS [Session-I] PDF Attached for Reference. Major Technical Components Discussed: Difference of SOA at OnPremise and SOACS – Overview Difference of SOA at OnPremise and SOACS – Behavioral Differences Adapters Available for Oracle SOA SOACS on OCM, OCIC and OCI SOACS on OCIC – Provisioning Migrate OnPremise SOA to Oracle Cloud You can download the […]

June 4, 2018

EBS on Oracle Cloud Infrastructure (OCI) [Session-I]

This is a session I have conducted for EBS on Oracle Cloud Infrastructure. This is divided into 7 different session, I would upload them as different parts. Learn complete details of EBS on Oracle Cloud Infrastructure, DB System and DBCS from this presentation snippet.

May 30, 2018

PostgreSQL DBA part 7 :-PostgreSQL full and incremental backup restore using BART 2.0 tool

BART is a backup and recovery tool for EDB Postgres Databases EDB Backup and Recovery Tool (BART) is a key component of an enterprise-level Postgres-based data management strategy. BART implements retention policies and point-in-time recovery requirements for large-scale Postgres deployments. Now available, Bart 2.0 provides block-level incremental backup. P.C https://www.enterprisedb.com/products/edb-postgres-platform/edb-backup-and-recovery-tool A.Full backup and restore using BART 2.0 for EDB 1. […]

May 24, 2018

PostgreSQL DBA part 6 :-PostgreSQL high availability setup using EFM

PostgreSQL high availability setup using EFM A.Introduction This document provides you the overview of High Availability Setup for EDB Postgres 9.5 database. An EDB Postgres Failover Manager (EFM) cluster is comprised of Failover Manager Processes that reside on the following hosts on a network: A Master node – The Master node is the primary database server that is servicing […]

May 22, 2018

PostgreSQL DBA part 5 :- Create user and grant privilege in postgresql

edb=# create user test identified by test; CREATE ROLE edb=# grant connect on database edb to test; GRANT edb=# grant usage on schema public to test; GRANT edb=# create table t(c1 char(10)); CREATE TABLE edb=# insert into t values(‘DEB’); INSERT 0 1 edb=# commit; COMMIT edb=# grant select,insert on emp to test; GRANT edb=# \c edb test; Password for user […]

May 22, 2018

Manual Steps to Setup ACFS file system in ODA box with GI version 11.2

Below are the Manual Steps to Setup ACFS file system in ODA box with GI version 11.2 Terminology ———– DATA – is the diskgroup from which we are taking space (-volumeDiskGroup parameter) 1024 GB – is the space that we are allocating (-volumeSizeGB parameter ) acfsbkpvol – is the ACFS volume name (-volumeName parameter) /backupfs – is the file system […]

May 16, 2018

PostgreSQL DBA part 4 :-How to create database in postgresql

How to create database in postgresql Create Database command can be used to create a database in a cluster. −Syntax: Creating Databases CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner][ TEMPLATE [=] template ][ ENCODING [=] encoding ][ TABLESPACE [=] tablespace][ CONNECTION LIMIT [=] connlimit ] ] 1.Create database in postgresql named prod with user as enterprisedb.Please […]

May 11, 2018

PostgreSQL Parameters(The following are most common parameters in postgresql.conf)

A.Many Ways to set postgresql parameters •Some parameters can be changed per session using the SETcommand. •Some parameters can be changed at the user level using ALTER USER. •Some parameters can be changed at the database level using ALTER DATABASE. •The SHOW command can be used to see settings. •The pg_settings and pg_file_settings catalog table lists settings information. B.PostgreSQL Parameters(The […]

May 10, 2018

PostgreSQL DBA part 3 :-How to start/stop postgresql database

A.Stopping postgresql database pg_ctl can be used to stop a database cluster •pg_ctl supports three modes of shutdown −smart quit after all clients have disconnected −fast (default)quit directly, with proper shutdown −immediate quit without complete shutdown; will lead to recovery •Syntax −pg_ctl stop [-W] [-t SECS] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] -bash-4.1$ pwd /opt/edb/as9.6/bin -bash-4.1$ ./pg_ctl -D /opt/edb/as9.6/data -mf stop […]