How to make backups/dumps to Postgresql? What is a free and easy solution, which is used by many?

The base is small. Just let it be 1Gb

How better and easier to make backups/dumps? pg_dump or pg_dump_all? In what format?


Or this:

*What are 2-3 tools used by most as the de-facto?*
June 3rd 19 at 20:59
4 answers
June 3rd 19 at 21:01
Solution
Depends on the requirements bekapa.
If you need point in time recovery, i.e. the ability to restore the state of the cluster to some arbitrary transaction - it is pg_basebackup + WAL files.
To collect designer manually - there is a barman. If bekapit want somewhere in the s3 - it is easier to be wal-e or wal-g
One base separately so bekapit and restore will not work, only the whole instance as a whole. Volume backup = volume of the entire instance + volume of all WAL basebackup from the beginning to the desired point of recovery, the number of wal depends on your writing load.

If enough logical snapshot of the data, for example, every day, then Yes, pg_dump. Restore, respectively, only at the beginning of the lifting of the dump.
Typically done pg_dumpall -g to preserve the global cluster data - user, tablespace, database names and a separate pg_dump for those bases that have bekapit.
The format is often custom made, because he was a staff shrinks and allows using pg_restore to restore specific objects from the dump, not just the whole thing as text using psql. For GB base makes no sense, but for bigger databases it makes sense to do the format of the directory in multiple threads.
ok

what to use pg_dump or pg_dumpall? - Frances_Watsi commented on June 3rd 19 at 21:04
I repeat: usually both are used simultaneously. pg_dumpall -g for global data of a cluster and a separate pg_dump to save images of separate databases that must bekapit. Rolled out if necessary, accordingly in the reverse order, first the global data from pg_dumpall -g, then one of the snapshots pg_dump in a database, you need the data for those databases.

pg_dumpall in its purest form to use, too. But if you need to restore a separate plate - it will be somewhat uncomfortable. - Ignacio_Romaguera commented on June 3rd 19 at 21:07
well what a cluster - I even do not know these words. if they knew, would not ask this question.

I have one base. all. nothing fancy is not necessary.

what to use? - Frances_Watsi commented on June 3rd 19 at 21:10
The cluster in the terminology of postgresql one running postgresql instance. - Ignacio_Romaguera commented on June 3rd 19 at 21:13
June 3rd 19 at 21:03
For a database this size will fit pg_dump.
June 3rd 19 at 21:05
Use backup.github.io/backup/v4/installation for backups, stable flight for several years.

Don't think this is the solution that uses the most. But a good thing
June 3rd 19 at 21:07
Barman - excellent Tulsa
https://www.pgbarman.org

Find more questions by tags PostgreSQLBacking up