Timeline for How can I create readonly user for backups in PostgreSQL?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 11 at 16:41 | comment | added | Peter Mølgaard Pallesen |
Found out you need to use CREATE ROLE backup WITH IN ROLE pg_read_all_data LOGIN PASSWORD '<password> and if you are using the postgres database you need to specify the database pg_dump postgres://backup:<password>@<database_uri>/postgres > dump.sql
|
|
| May 30, 2023 at 0:46 | comment | added | AlexITC |
Unfortunately, this did not worked for me until I executed 2 operations: CREATE USER dbuser; and GRANT pg_read_all_data TO dbuser;
|
|
| Dec 13, 2021 at 17:26 | comment | added | pieca |
in order to use pg_basebackup I needed to also add REPLICATION role
|
|
| S Dec 1, 2021 at 15:34 | review | First answers | |||
| Dec 1, 2021 at 16:05 | |||||
| S Dec 1, 2021 at 15:34 | history | answered | F30 | CC BY-SA 4.0 |