Skip to content

Instantly share code, notes, and snippets.

@chocobn69

chocobn69/gist:c31ccba7efa87b885fc3

Created November 2, 2015 14:00
Show Gist options
  • Save chocobn69/c31ccba7efa87b885fc3 to your computer and use it in GitHub Desktop.
Save chocobn69/c31ccba7efa87b885fc3 to your computer and use it in GitHub Desktop.
Download ZIP
move xlog to new partition (new disk)
Raw
gistfile1.txt
sudo pg_ctlcluster 9.4 main stop
sudo cp /datas/postgresl/9.4/main/pg_xlog/* /xlog/9.4/
sudo chown -R postgres:postgres /xlog/9.4/
sudo mv /datas/postgresl/9.4/main/pg_xlog/ /datas/postgresl/9.4/main/pg_xlog_old/
sudo ln -s /xlog/9.4/ /datas/postgresl/9.4/main/pg_xlog
sudo chown -R /xlog/9.4/
sudo pg_ctlcluster 9.4 main start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment