This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
postgresql [2018/07/24 15:44] mstraub [Incremental Backups on Localhost] |
postgresql [2018/08/27 13:41] mantis |
||
---|---|---|---|
Line 58: | Line 58: | ||
==== Setting a password for user postgres ==== | ==== Setting a password for user postgres ==== | ||
<code sql> | <code sql> | ||
- | alter user postgres with password 'password'; | + | \password postgres |
</code> | </code> | ||
Line 729: | Line 729: | ||
sudo -u postgres pgbackrest --set=20180724-144511F --stanza=STANZANAME --log-level-console=detail restore | sudo -u postgres pgbackrest --set=20180724-144511F --stanza=STANZANAME --log-level-console=detail restore | ||
+ | You can also copy the contents of ''/var/lib/pgbackrest'' to a different device and restore it there. | ||
Log files can be found in ''/var/log/pgbackrest''. | Log files can be found in ''/var/log/pgbackrest''. |