# Delete packages RDBMS PostgresPro
sudo apt-get purge --auto-remove -y postgrespro*
# rm -rf /etc/apt/sources.list.d/postgresproee.list
sudo rm -rf /var/lib/pgpro/ent-10/data/*

# Install RDBMS PostgresPro

sudo sh -c 'echo "deb https://YOURLOGIN:[email protected]/pgproee-10/ubuntu $(lsb_release -cs) main" > /etc/apt/sources.list.d/postgresproee.list'
wget --quiet -O - https://YOURLOGIN:YOURPASS@repoee.postgrespro.ru/pgproee-10/keys/GPG-KEY-POSTGRESPRO | sudo apt-key add -
sudo apt-get update -y
sudo apt-get install -y postgrespro-ent-10 postgrespro-ent-10-contrib

# Connect to RDBMS, check install
sudo su - postgres -c "psql -c \"select pgpro_version();\""
sudo su - postgres -c "psql -c \"select pgpro_edition();\""

# Export dump shemas from source
sudo su - postgres -c "/opt/pgpro/ent-10/bin/pg_dump --format=custom -s cdr -f /tmp/cdr.out"

# Create database

# Enable pg_pathman libraries
sudo su - postgres -c "psql -c \"alter system set shared_preload_libraries='pg_pathman';\""

sudo systemctl restart postgrespro-ent-10.service

#sudo su - postgres -c "psql -c \"drop database cdr;\""
sudo su - postgres -c "psql -c \"create user cdr password 'cdr123';\""
sudo su - postgres -c "psql -c \"create database cdr owner cdr;\""
sudo su - postgres -c "psql -d cdr -c \"create extension pg_pathman;\""

# Create compression tablespace
sudo su - -c "mkdir -p /var/lib/pgpro/ent-10/data_compressed2"
sudo su - -c "chown -R postgres. /var/lib/pgpro/ent-10/data_compressed2"
sudo su - postgres -c "psql -c \"create tablespace compressed2 location '/var/lib/pgpro/ent-10/data_compressed2' with (compression=true); \""

# Import dump shemas
sudo su - postgres -c "pg_restore -v -d cdr /tmp/cdr.out"