| FazBrowse GitHub Viewer | Trending | | Home |
| Tools: [Download Repo ZIP] [Original HTTPS Page] |
Cick here for Video Demo https://youtu.be/WZps_MYYvV8
bash~ mkdir -p /var/lib/pgsql/wals/ bash~ mkdir -p /var/lib/pgsql/backups/ bash~ chown postgres:postgres -R /var/lib/pgsql/backups/ bash~ chown postgres:postgres -R /var/lib/pgsql/wals/
wal_level=archive archive_mode=on archive_command = 'test ! -f /var/lib/pgsql/wals/%f && cp %p /var/lib/pgsql/wals/%f'
bash~ service postgresql restart
su - postgres
psql -c "SELECT pg_start_backup('label');" postgres
tar -C /var/lib/pgsql/data/ -czvf /var/lib/pgsql/backups/pg_basebackup_backup.tar.gz .
psql -c "SELECT pg_stop_backup();" postgres
bash~ su - postgres bash~ createdb mydb bash~ psql -s mydb
bash~ /etc/init.d/postgresql stop
bash~ cd /var/lib/pgsql/ bash~ rm -rf data/
bash~ /etc/init.d/postgresql initdb bash~ /etc/init.d/postgresql start
bash~ /etc/init.d/postgresql stop
bash~ tar xvf /var/lib/pgsql/backups/pg_basebackup_backup.tar.gz -C /var/lib/pgsql/data
bash~ cd /var/lib/pgsql/data bash~ cat recovery.conf restore_command = 'cp /var/lib/pgsql/wals/%f %p'
bash~ /etc/init.d/postgresql start
bash~ cd /var/lib/pgsql/data bash~ cat recover.done
| Back | FazBrowse Home | New Git URL |