-
BASIC POSTGRESQL
-
VMWARE & POSTGRESQL INSTALLATION
- Vmware Installation
- Creating Linux Virtual Machine
- PostgreSQL Installation Types
- PostgreSQL GUI Installation
- PostgreSQL Text Mode Installation
- PostgreSQL Unattended Mode Installation
- Configure the network & Disk Partition
- How to install PostgreSQL10 On Linux Server ?
- PostgreSQL -11 Installation (rpm & source code)
-
POSTGRESQL DATABASE
-
POSTGRESQL TABLE
- PostgreSQL Languages
- PostgreSQL Create Table
- PostgreSQL Select Table
- PostgreSQL Alter Table
- PostgreSQL Drop Table
- PostgreSQL Truncate Table
- PostgreSQL Rename
- PostgreSQL Comment
- PostgreSQL Insert
- PostgreSQL Update
- PostgreSQL Table Delete
- PostgreSQL Merge Table
- PostgreSQL UNION
- PostgreSQL UNION ALL
- PostgreSQL INTERSECT
- PostgreSQL DISTINCT
-
USER/OBJECTS PRIVILEGE AND ROLES ASIGNING
-
TRANSACTIONS - MVCC
-
POSTGRESQL USER/SCHEMA MANAGEMENT
-
POSTGRESQL CONSTRAINTS
-
POSTGRESQL ADVANCE DATA TYPE
-
POSTGRESQL VIEWS
-
POSTGRESQL MONITORING OBJECT USUAGE/SIZE
-
POSTGRESQL DATABASE ARCHITECTURE
-
POSTGRESQL BACKUP AND RECOVERY
- PostgreSQL Backup & Recovery Overview
- PostgreSQL Database Backup Tools – Pg_dump
- PostgreSQL Database Backup Tools – Pg_dumpall
- PostgreSQL Database Backup Tools – Pg_basebackup
- PostgreSQL COPY data From Text File
- PostgreSQL COPY data to Text File
- PostgreSQL Clone Table
- Postgres Database Schema Migration
- PostgreSQL Database clone/migration
- PostgreSQL Compress backup format
- PostgreSQL Archivelog
- PostgreSQL Point In Time Recovery
- Taking Backup On Postgres Slave (Standby) Server
-
POSTGRESQL PERFORMANCE TUNING
-
HIGH AVAILABILITY, LOAD BALANCING, AND REPLICATION
- POSTGRESQL STREAMING REPLICATION
- SSL Streaming replication with PostgreSQL 10
- How to make Linux partition and configure the network on Redhat Linux7.3
- How To Fix Firewall Issues while connecting the other server?
- How to install the PostgreSQL10 On Linux ?
- How to Configure the cascade replication On PostgreSQL 10.3 ?
- How to add extra one slave an existing PostgreSQL cascade replication without down time ?
- PostgreSQL Switchover
- Postgres Failover
- Postgres Upgrade
- PostgreSQL Upgrade 9.5 to 11.3 .
PostgreSQL UnderStanding Of Objects
- A PostgreSQL database cluster contains one or more named databases.
- Users and groups of users are shared across the entire cluster and tablespace, but no other data is shared across databases.
- Any given client connection to the server can access only the data in a single database, the one specified in the connection request.
- Furthermore, database is collection of database objects such as schema, which contains table, view, sequence, functions and other database objects.
- A database cluster is a collection of databases that is stored at a common file system location (the “data area”). Or A database cluster is a collection of databases that are managed by a single server instance.
- It is possible to have multiple database clusters so long as they use different data areas and different communication ports. One postmaster and port per cluster. Accessed from a single “Data Directory”.
- A database is a named collection of SQL objects (table , function, etc).
Pg_database
A database is a collection of schemas and the schemas contain the tables functions, etc.