Difference between revisions of "Moving the PostgreSQL Database to a New Location in Linux"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) (Created page with "On the target server edit the pg_hba.conf file to allow the connection from the source (172.21.40.131 in this example) server. # TYPE DATABASE USER ADDRE...") |
Kevin Wilkie (Talk | contribs) |
||
(3 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | + | [[Category:Database]] | |
− | + | Change /data to the folder you want to use | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | mkdir /data/gigaflow | |
− | / | + | systemctl stop gigaflow |
− | + | systemctl stop postgresql-11 | |
− | + | echo "rsync -av /var/lib/pgsql/11/data/ /data/gigaflow" | |
− | + | rsync -av /var/lib/pgsql/11/data/ /data/gigaflow | |
− | + | echo "mv /var/lib/pgsql/11/data /var/lib/pgsql/11/data_old" | |
− | / | + | mv /var/lib/pgsql/11/data /var/lib/pgsql/11/data_old |
− | + | echo "ln -s /data/gigaflow /var/lib/pgsql/11/data" | |
− | + | ln -s /data/gigaflow /var/lib/pgsql/11/data | |
− | + | chown postgres:postgres /var/lib/pgsql/11/data | |
− | + | chmod 0700 /var/lib/pgsql/11/data | |
− | / | + | systemctl start postgresql-11 |
− | + | systemctl start gigaflow | |
− | + | ||
− | + | ||
− | + | ||
− | / | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | / | + | |
− | + |
Latest revision as of 11:45, 3 February 2022
Change /data to the folder you want to use
mkdir /data/gigaflow systemctl stop gigaflow systemctl stop postgresql-11 echo "rsync -av /var/lib/pgsql/11/data/ /data/gigaflow" rsync -av /var/lib/pgsql/11/data/ /data/gigaflow echo "mv /var/lib/pgsql/11/data /var/lib/pgsql/11/data_old" mv /var/lib/pgsql/11/data /var/lib/pgsql/11/data_old echo "ln -s /data/gigaflow /var/lib/pgsql/11/data" ln -s /data/gigaflow /var/lib/pgsql/11/data chown postgres:postgres /var/lib/pgsql/11/data chmod 0700 /var/lib/pgsql/11/data systemctl start postgresql-11 systemctl start gigaflow