All Questions
Tagged with backup postgresql
357 questions
0
votes
0
answers
14
views
wal-g/postgresql: How to turn continuous into punctual backups for sparsifying archival?
I would like to implement a backup scheme in which for the past week, I have daily full backups with complete WAL logs for point-in-time-recovery. Past a week, I would like to keep only daily ...
0
votes
1
answer
44
views
pg_basebackup duration of 500G
How long should the duration of a pg_basebackup of around 500G usually should be?
Currently it takes about 7hrs.
What could be done to speed up this process?
We create the backup locally and move it ...
0
votes
1
answer
185
views
How can I manually backup a large Azure Flexible Postgres database?
I have a large (3TB+) single database on a Azure Postgres Flexible Server. This is a managed service, so it takes backups automatically and the frequency can be adjusted. As a disaster recovery/...
2
votes
2
answers
212
views
Barman incremental backups and a recovery window: what is actually stored?
I'm planning on setting up streaming backups + WAL streaming with Barman from a PostgreSQL 17 instance. From my reading of the documentation, I don't quite understand what will happen in the scenario ...
0
votes
1
answer
76
views
Is pg_basebackup Performance Limited by Files Page Cache?
I have PostgreSQL 15 running in a Kubernetes Pod using the Zalando Spilo image, managed by Patroni. The container has a memory limit of 16 GB, and the database size is 40 GB (data dir on disk). When I ...
0
votes
0
answers
57
views
Postgres 16 pg_basebackup not working due to system identifier mismatch
I am using the Alpine docker image for Postgres 16 for this experiment.
I have one container which is running and has some tables.
I create a second container which is also running but has no tables.
...
0
votes
1
answer
188
views
Postgresql 17 take automatic daily incremental backups
Postgresql 17 added a new feature to make incremental backups. I want to use this to make daily incremental backups, however I am struggling to find a good method for automatization, as the build in ...
0
votes
0
answers
82
views
Does TimescaleDB/PostgreSQL work well with Azure Disk backup?
I'm investigating improvements to a self-hosted TimescaleDB in Microsoft Azure. We have Timescale running in an AKS cluster, with a Standard SSD Azure Disk mounted as its persistent storage. Thus far ...
0
votes
0
answers
23
views
Newb question: finding my hosted databases
Apologies if this is a really stupid question. I'm very new to SQL databases and I need some help. I work at a book store with a website hosted on an AWS EC2 instance. Nobody touched their website for ...
0
votes
1
answer
315
views
Barman using old pg_start_backup on Postgresql-15 [closed]
I'm trying to backup my server using barman but it's taking error on backup
here's the check
root@barman:~# barman check My_server
Server Postgres_UniContent:
PostgreSQL: OK
...
0
votes
0
answers
46
views
PITR Backup solution for PostgreSQL running under Windows
I am new to PostgreSQL and come from a SQL Server world. I am trying to create a transactional log backup process for PostgreSQL to run under Windows. I believe the terminology is PITR and Archiving ...
0
votes
0
answers
124
views
Taking backup of a large database that writes nearly 20 GB of data every day
as I mentioned in the title, how should I back up a 10 TB PostgreSQL database to which a lot of data is written every day?
If I need to give a little more detail, the data I mentioned is partitioned ...
0
votes
0
answers
190
views
Postgres Barman archive command failed
For production environment, I am using this archive command in my postgresql server.
barman-wal-archive backup pg /var/lib/edb-pge/15/data/pg_wal/%f
Now when I manually run this command on my ...
0
votes
1
answer
143
views
How do I restore a PostgreSQL/TimescaleDB pg_basebackup tar on Windows? postgresql-x64-15 immediately stops on start
I'm going thru the various online processes to expand the pg_basebackup tar file into the C:\Program Files\PostgreSQL\15\data, such as Restore data from tar file for unix, but when restoring on ...
1
vote
2
answers
853
views
postgres backup start stop from psql and linux cli
I want to perform below steps
Put DB in backup mode
Take snapshot of volume
Stop backup mode
But when I try as below, at #3 I get "Did you call pg_backup_start()?" error.
Looks like start ...