EDB Postgres Database Installation

 

# Login with Root/sudo access

# Setup the EDB repository

sudo su -c 'echo "deb [arch=amd64] https://apt.enterprisedb.com/$(lsb_release -cs)-edb/ $(lsb_release -cs) main" > /etc/apt/sources.list.d/edb-$(lsb_release -cs).list'

 

# Replace '<USERNAME>' and '<PASSWORD>' below with your username and password for the EDB repositories. Visit https://www.enterprisedb.com/user to get your username and password

sudo su -c 'echo "machine apt.enterprisedb.com login username password password" > /etc/apt/auth.conf.d/edb.conf'

 

# Add support for secure APT repositories

sudo apt-get -y install apt-transport-https

 

# Add the EDB signing key

sudo wget -q -O - https://apt.enterprisedb.com/edb-deb.gpg.key  | sudo apt-key add -

 

# Update the repository meta data

sudo apt-get update

 

# Install selected packages

sudo apt-get -y install edb-as13-server   ## Server

apt-get install postgresql-client-13 ##Client

apt install postgresql-client-common ##tool

 

# Connect to the database server

 sudo su - enterprisedb

 psql postgres

 

# Check if the service is running

 /usr/bin/epas_lsclusters

Ver Cluster Port Status Owner        Data directory          Log file

13  main    5444 online enterprisedb /var/lib/edb-as/13/main /var/log/edb-as/edb-as-13-main.log