To-Do list
- Think about where you want to store your backup data.2. How much you can spend on it3. Think about if your data will increase over the time4. And how often do you need to reschedule your backup plan5. Company partners should be agreed on your data recovery plan.6. Decide IT team who will perform data backup.
PostgreSQL backup tool
PostgreSQL backup tool helps to restore dumped data. There is a well-experimented method to create a SQL command file. The idea is when feedback is provided to the server and this results in recreated database original form the same as it was before deletion. The utility program PGDUMP particularly for this purpose proposed by PostgreSQL. “pg_dumpdbname>dumpfile” is a command for PGDUMP.Steps:1. Signin to Data Base server2. move to postgres page3. Command Run4. pg_dumpdatabase_xyz>filename.sql5. to restore backup file in a directory6. Replace Filename with “f directory”If you are restoring your data, the PostgreSQL tool will do this too.Steps while using the PostgreSQL tool1. Create a backup text file2. plsqldatabase_name<filename.sql this will restore the text file.3. PG_restore will backup custom, tar or directory format.Commands• pg_restore -d database_namefilename.dump• pg_restore -d database_name filename.tar• pg_restore -d database_namedumpdirectoryNote if you want to restore gigantic data then Compress the file and use the below command method. use -Gzip to compress the files.Command• Pg_dumpdatabase_name | gzip> dumpname.gzThere is a shortcut key t save time alsoCommand for parallel file dump• pg_dump -F d -j 5 -f dumpdirectory Note: This can slow down your Database server If you want to back up remote data PostgreSQL backup tool has a command for this purpose too.Command:• pg_dump -U role -h 20.20.20.20 -p 7777 database_name
