Skip to main content
28 questions
Newest Active Bountied Unanswered
0 votes
1 answer
450 views

My setup with PostgreSQL 14 streaming replication, includes pgBackRest for archiving to a dedicated repository server. Both archive commands and archive recovery work from this repository. Despite the ...
argdenis's user avatar
  • 23
0 votes
1 answer
571 views

I am taking backups of my PostgreSQL database with PgBackrest, performing a full backup once a week and incremental backups for five days. I store the backups on a separate backup server, apart from ...
Abdullah Ergin's user avatar
  • 3
0 votes
0 answers
105 views

I use pgBackRest 2.38 for postgresql 13 database backup and restore, I got a strange issue for point-in-time recovery. Once the point-in-time-recovery is done the pgbackrest kick starts postgresql ...
jobin george's user avatar
  • 181
0 votes
0 answers
117 views

I am using pgbackrest for a postgresql database backup and restore, do you know which database or pgbackrest parameters can be used to adjust the performance of postgresql database point in time ...
Eric's user avatar
  • 37
0 votes
0 answers
773 views

I am doing backup with pgbackrest in the database server every day at night, I was testing to restore the backup in another server, the restore was successfully however the database cant start ...
Deo Felix's user avatar
  • 1
0 votes
0 answers
793 views

I use pgbackrest 2.43 for postgresql 14.6 database backup and restore, I got a strange issue for point-in-time recovery. Below are steps I followed to perform the test. (1) First run a full database ...
Eric's user avatar
  • 37
0 votes
0 answers
456 views

I’m looking at archiving data with TimescaleDB. Typically, I want to have TimescaleDB running on a box with little disk space and continuously archive it to an S3 bucket. To do so, I’m using ...
WillowOfTheBorder's user avatar
  • 45
0 votes
1 answer
2k views

I´m trying to implement the TLS server feature available with pgBackRest to use a secure connection between the DB server and the repo server, replacing the previous SSH passwordless setup (that was ...
rook's user avatar
  • 29
0 votes
2 answers
5k views

This question is a follow up on a previous question I posted about efficient ways to max up Postgres pg_wal directory (for training purposes) : How to bloat pg_wal?. I'm now wondering what are the ...
rook's user avatar
  • 29
3 votes
2 answers
5k views

I am setting up pgbackrest to save wal archives to S3. I have two machines. When I used to take backup on the localhost, I am able to save it to S3. However, when I initiate backup from 'backup server'...
Swaym's user avatar
  • 41
1 vote
0 answers
974 views

I'm trying to backup/restore from one postgres instance on one virtual machine to another postgres on another vm. How to give paths in pg_hba.conf? [global] repo1-path=/var/lib/pgsql/12/backups/ log-...
krishna-chavan's user avatar
  • 51
4 votes
1 answer
747 views

jq is an amazing tool and it does a lot. as input I have [ { "backup": [ { "timestamp": { "start": 1642144383, "stop": 1642144386 }, ...
user avatar
0 votes
1 answer
82 views

As input I have: [ { "backup": [ { "timestamp": { "start": 1642144383, "stop": 1642144386 }, "info": { "size": ...
user avatar
0 votes
2 answers
185 views

I have a json formatted overview of backups, generated using pgbackrest. For simplicity I removed a lot of clutter so the main structures remain. The list can contain multiple backup structures, I ...
user avatar
6 votes
1 answer
3k views

As far as I understood WAL archiving is pushing the WAL logs to a storage place as the WAL files are generated Incremental backup is pushing all the WAL files created since the last backup So, ...
Patanouk's user avatar
  • 141

15 30 50 per page
1
2