Search

  • PostgreSQL

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…

  • SOA on Oracle Cloud

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…

  • EBS on Oracle Cloud

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,…

  • PostgreSQL

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…

  • PostgreSQL

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…

  • PostgreSQL

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…

  • ASM
  • Oracle DBA
  • Technology

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…

  • PostgreSQL

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:…

  • PostgreSQL

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…

  • PostgreSQL

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…