Wednesday, February 8, 2012

Postgresql File System Level Backup Debian

In order to perform postgresql backup on debain, there are some modification on

sudo service apache2 stop
sudo service postgresql stop

sudo tar -cvpjf /a/path/postgres-`date +%y%m%d`.tar.bz2 -C /var/lib/postgresql/9.1/main .

# Prevent parent directories from being tarred
#   -C, --directory DIR
#           change to directory DIR

# -p, --preserve-permissions, --same-permissions
#           extract information about file permissions (default for superuser)

sudo service postgresql start
sudo service apache2 start

# when extract
#sudo tar -xvjf postgres-xxxxxx.tar.bz2

No comments:

Post a Comment