Questions tagged [pg-basebackup]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

How to restore Postgres cluster from pg_probackup archive

I'm trying to configure continuous backup solution using pg_probackup tool. So far I did the following: Configured archive_command according to the docs Created backup using pg_probackup backup ...
0
votes
1answer
133 views

How to mount a pg_basebackup on a stand alone server to retrieve accidently deleted data

Had a bit of a brain fade the other day and deleted all the rows in one of the tables in our database and didn't realise until a couple of hours later. I have a pg_basebackup file system copy created ...
2
votes
1answer
191 views

How to make pg_basebackup use temporary replication slots

This article https://blog.hagander.net/another-couple-of-steps-on-my-backup-crusade-235/ states that temporary replication slots can be "used to prevent the wal on the server from being removed while ...
4
votes
2answers
3k views

Unable to receive WAL files with barman

I've been scratching my head to solve the following error, but haven't made much progress: $ barman switch-wal --force --archive --archive-timeout 180 pg The WAL file 0000000100000059000000FF has ...
2
votes
2answers
817 views

pg_basebackup with tablespaces defined

I have a database with the following tablespaces: pgwb=# \db List of tablespaces Name | Owner | Location ------------+-------+-----------------------------------...
1
vote
2answers
478 views

Incremental Backup. Base backup creation frequency?

So I'm trying to understand how Continuous Archiving and Point-In-Time-Recovery works. From what i've read there are some steps involved for the incremental backup and some steps for the recovery: ...
2
votes
1answer
214 views

commitlog broken after standby setup with pg_basebackup

I'm trying to replicate a database with pg_basebackup in order to use it as standby server. But when I'm trying to start up PostgreSQL I get the following errors and the server shuts down again: 2016-...
2
votes
1answer
423 views

Backup a hot standby database (streaming replication) whilst it is in recovery

Synchronous Streaming Replicating is set up between a master and a hot standby database. It seems like a good idea to perform daily backups on the standby database to avoid any performance issues ...
1
vote
2answers
5k views

PostgreSQL Write Ahead Logs Archive Mode

I'm trying to figure out various things surrounding PostgreSQL and how backups should work together with WAL and Commvault Simpana. Simpana is telling me that everything is ok, but leaves files lying ...
2
votes
1answer
2k views

Postgres restore unclear behaviour

I have following: 2 nodes one of which is current production db and another is for fail recovery. I made base backup on first node with following command pg_basebackup -h 127.0.0.1 -U postgres -D bckp ...
3
votes
1answer
3k views

Postgresql pg_basebackup from slave didnt save WAL's

Is it possible to shoot a backup with the pg_basebackup utility from the slave server (where of streaming replication with the help of this utility pg_basebackup)? I have a hot_standby server (...
2
votes
1answer
3k views

pg_basebackup fails with “ too many connections for role ”replication“”

I am trying to set up a standby server and keep getting this error. My primary server has more than enough connections to handle the load: listen_addresses = '*' wal_level = hot_standby ...
1
vote
1answer
6k views

pg_basebackup: could not connect to server: fe_sendauth: no password supplied

I'm trying to set up streaming replication between two Postgres servers. The master server's pg_hba.conf file is configured this way: host replication ${REP_USER} 0.0.0.0/0 ...
1
vote
1answer
89 views

Migrating from 32 bit using pg_basebackup

Has anyone migrated a 32 bit postgres 9.2 database to a 64 bit postgres 9.2? I'm trying to use pg_basebackup but I'm not sure whether this is the right approach.
2
votes
2answers
3k views

pg_basebackup giving “could not receive data from client: Connection reset by peer”

I'm trying to get data to a new slave box from my new master (previously the slave). I've tried the steps already and it worked previously. Now when I run the following command: pg_basebackup -h ...
4
votes
1answer
3k views

postgresql - a local replication entry doesn't work

Maybe it's just too early in the morning, but I can't seem to get pg_basebackup working for a local user. This is part of testing for an hourly backup automated script. I added a line to pg_hba.conf ...