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) |
|||
Line 1: | Line 1: | ||
[[Category:Database]] | [[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