Difference between revisions of "Moving the PostgreSQL Database to a New Location in Linux"
From Observer GigaFlow Support | VIAVI Solutions Inc.
m (Niall moved page Postgres/Copying DB To New Server/ to Moving the PostgreSQL Database to a New Location in Linux) |
Kevin Wilkie (Talk | contribs) |
||
(One intermediate revision by one user not shown) | |||
Line 1: | Line 1: | ||
− | [[Category: | + | [[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