Loading...

Follow clouddba on Feedspot


Valid
or
Continue with Google
Continue with Facebook

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

The post PostgreSQL DBA part 6 :-PostgreSQL high availability setup using EFM appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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

The post PostgreSQL DBA part 5 :- Create user and grant privilege in postgresql appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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

The post Manual Steps to Setup ACFS file system in ODA box with GI version 11.2 appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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

The post PostgreSQL DBA part 4 :-How to create database in postgresql appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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

The post PostgreSQL Parameters(The following are most common parameters in postgresql.conf) appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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$

The post PostgreSQL DBA part 3 :-How to start/stop postgresql database appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

A.Connecting postgresql locally using port Please identify port in postgresql.conf under /opt/edb/as9.6/data and connect using psql There are pre-requisites for allowing local connection.This pg_hba.conf file is under  /opt/edb/as9.6/data.Please make sure last parameter should be md5 not peer. The below content is for example what should be in pg_hba.conf # "local" is for Unix domain socket connections only

The post PostgreSQL DBA part2 :-How to connect postgresql database appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This document explains how to secure private repository using openssl key Before we can use a private repository, we will need to secure it and offer user authentication. Let’s create a self-signed certificate, use the ‘registry’ container by Docker to create basic user authentication, and then copy the files where they need to go on

The post DOCKER CONCEPT FOR DBA– PART 10 : How to secure docker private repository using openssl certificate key appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The tool was devised by Craig from ORAPUB which is excellent to monitor what happens in session real time. 1.First I need to down OSM tool kit from ORAPUB. First we need to run the following scripts to create some pre-requisite tables under sys/system schema. a)osmprep.sql -- ****************************************************** -- * Copyright Notice : (c)1998-2014,2015 OraPub,

The post Monitor real time active session statistics by ORAPUB tool appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

1.Creating docker tar file from docker image.We can transfer that tar file and import to another docker instance. root@deb-VirtualBox:~# docker image save mywebserver:v1>mywebserver.tar root@deb-VirtualBox:~# ls -ltr mywebserver.tar -rw-r–r– 1 root root 330399232 May 2 19:53 mywebserver.tar 2.Remove the existing docker image  root@deb-VirtualBox:~# docker rmi -f mywebserver:v1 Untagged: mywebserver:v1 3.Please note the image is deleted root@deb-VirtualBox:~#

The post DOCKER CONCEPT FOR DBA– PART 9 : How to use docker tar command in docker to re-instantiate new docker appeared first on clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases.

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview