From 802b4f149bfcf3062d0de6f15f60f03b855435cc Mon Sep 17 00:00:00 2001 From: wbudic Date: Thu, 13 May 2021 19:00:19 +1000 Subject: [PATCH] Added db location info. --- Installation_ProgresSQL.txt | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/Installation_ProgresSQL.txt b/Installation_ProgresSQL.txt index efad009..ef933b5 100644 --- a/Installation_ProgresSQL.txt +++ b/Installation_ProgresSQL.txt @@ -70,6 +70,12 @@ sudo cpan DBD::Pg; sudo apt install python3-pip sudo python3 -m pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.30/pip/pgadmin4-4.30-py3-none-any.whl +# Data directory location for backup +sudo -u postgres psql -c "SHOW data_directory;" | grep -G / +## Quick tar all +sudo tar ~/czvf postgresql.db.backup.tar $(sudo -u postgres psql -c "SHOW data_directory;" | grep -G /) + + -- 2.34.1