How to install and set up a PostgreSQL on ubuntu 20.04
In this video you will learn how to install the free object-relational database management system postgresql
Also in this video you will learn how to change the location of a folder with postgresql files and, in principle, how to move folders from one location to another. We will use rsync to move and check how everything works at the end.
Useful links
Tutorial:
1.
2.
VPS/VDS -
Commands used
apt update && apt upgrade -y
apt install postgresql postgresql-contrib
systemctl start postgresql.service
sudo -i -u postgres
psql
sudo -u postgres createuser --interactive
sudo -u postgres createdb sammy
adduser NAME
sudo -i -u NAME
sudo -u postgres psql
SHOW data_directory;
systemctl stop postgresql
systemctl status postgresql
rsync -av /var/lib/postgresql /mnt/YOURFOLDER
mv /var/lib/postgresql/12/main /var/lib/postgresql/12/main.bak
nano /etc/postgresql/12/main/postgresql.conf
systemctl start postgresql
systemctl status postgresql
sudo -u postgres psql
rm -Rf /var/lib/postgresql/12/main.bak
Watch video How to install and set up a PostgreSQL on ubuntu 20.04 online, duration 07 minute 45 second in high hd quality that is uploaded to the channel MivoCloud 22 August 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 235 times and liked it 4 visitors.
