This article shows a flow to dump and restore DB data on PostgreSQL.
Dump DB data and compress the data.
PGPASSWORD=DB_PASSWORD pg_dump -U USER_NAME -h localhost -p 5432 DB_NAME -f DUMP_FILE_PATH
De-compress the compressed data and import the data to DB on PostgreSQL.
tar zxvf DUMP_FILE_PATH.tar.gz -C DUMP_FILE_PATH
The upper restore flow does not support to restore sequences on DB. So the following rake task repairs the sequences on DB.
./lib/tasks/db_restore.rake and set the following code.
namespace :db_repair do
After creating the upper file, please execute
🖥 Recommended VPS Service
VULTR provides high performance cloud compute environment for you.
Vultr has 15 data-centers strategically placed around the globe, you can use a VPS with 512 MB memory for just $ 2.5 / month ($ 0.004 / hour).
In addition, Vultr is up to 4 times faster than the competition, so please check it => Check Benchmark Results!!