-
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 .
Vmware Installation
VMware Workstation is a computer emulator. It allows you to create virtual machines in which you can install operating systems as if they were physical machines. You might want to emulate an operating system because you want to run a program that isn’t compatible with the host operating system (the operating system that you are installing VMware Workstation on), or because you want to test malware without putting an actual computer at risk. This article shows you how to install VMware Workstation 9 and create or open a virtual machine.
Step 1.Make sure that your computer meets the minimum requirements to run VMware Workstation 9.
Operating System:
Windows or Linux 64-bit
CPU:
To run 32-bit virtual machines: 64-bit; 1.3 GHz or higher
To run 64-bit virtual machines: the above requirements along with VT-x support if you have an Intel processor (make sure that it is enabled in the BIOS), or the above requirements along with long mode support if you have an AMD processor.
RAM:
1 GB is minimum, but 2 GB is recommended
GPU:
at least a 16 or 32 bit display adapter (you probably have a 32-bit display adapter). If you want Windows Aero graphics to work in Windows virtual machines, then you should have either an NVIDIA GeForce 8800GT graphics card or newer or an ATI Radeon HD 2600 graphics or newer.
HDD space: 3.5 GB is required to install the program alone, but virtual machines will take up even more space.
VMWARE software :
REDHAT 7.3 OS
PostgreSQL10.3/10.4 :
Step 2.Run the setup file. Double-click the file that you downloaded. If the User Account Control or Open File – Security Warning dialog appears, click Yes or Run respectively
Step 3.Click Next > to dismiss the Welcome dialog box.
Step 4.Select the I accept the terms in the license agreement option then click Next >.
Step 5.Click the Typical button.
Step 6.Choose the directory in which you want to install VMware Workstation. To install it into a directory other than the default one, click Change… and browse to the desired directory. After deciding on where to install VMware Workstation, click Next >.
If you install VMware Workstation on a network drive, you cannot run it when the network drive is inaccessible.
Step 7.Decide if you want VMware Workstation to check for updates every time it is opened, then click Next >.
Step 8.Decide if want to send information about VMware Workstation’s performance on your computer to VMware. This information is used to help improve the program. Click Next > after you have made your decision.
Step 9.Select the locations that you want setup to create shortcuts to VMware Workstation in. Choices include the Desktop and the Start menu. Deselect any shortcuts you do not want the installer to create and then click Next >.
Step 10.The installer is ready to begin installing VMware Workstation. If you want to change any options, click < Back to return to them, change them, then click Next > until you reach this screen again once you’ve finished. Once you are ready to begin installing VMware Workstation, click Continue.
Step 11.Close setup. Click the Finish button once setup completes its operations.
