Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pg-basebackup]

19 questions
6
votes
2 answers

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 been closed on server 'pg' Waiting for the WAL file…
Saurabh Nanda
  • 333
  • 1
  • 4
  • 16
4
votes
1 answer

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 for this and it looks like: local replication …
user2288360
  • 41
  • 1
  • 2
3
votes
3 answers

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 around in the WAL Archive directory. Let the…
John K. N.
  • 18,854
  • 14
  • 56
  • 117
3
votes
1 answer

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 (streaming replication with pg_basebackup), and…
Andrew Zaharov
  • 33
  • 1
  • 3
2
votes
1 answer

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 max_wal_senders = 10 max_connections=100 checkpoint_segments =…
picardo
  • 280
  • 3
  • 6
  • 18
2
votes
1 answer

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 md5 host ${DB_NAME} ${DB_USER} …
picardo
  • 280
  • 3
  • 6
  • 18
2
votes
2 answers

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 masterhost -D /var/lib/postgresql/9.3/main -U rep…
Ponny
  • 121
  • 1
  • 4
2
votes
1 answer

Postgres backup PITR strategies

Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose the right option. Que: I'm new to postgres and…
Shiwangini
  • 380
  • 7
  • 24
2
votes
1 answer

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 a downstream replica or backup still needs…
mikelus
  • 343
  • 1
  • 3
  • 13
2
votes
2 answers

pg_basebackup with tablespaces defined

I have a database with the following tablespaces: pgwb=# \db List of tablespaces Name | Owner | Location ------------+-------+------------------------------------- bspace | pgwb |…
Wolfgang Brandl
  • 21
  • 3
2
votes
1 answer

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-08-09 15:53:38 CEST [10369]: [1-1] [postgres:…
RootOfProblem
  • 245
  • 2
  • 9
2
votes
1 answer

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 on the master database. The backup of the standby…
Stelios
  • 389
  • 1
  • 5
  • 14
2
votes
1 answer

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 -Ft -z -P -R -x and got bacup file base.tar.gz.…
t3mplar
  • 123
  • 1
  • 4
1
vote
1 answer

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.
Peter
  • 11
  • 1
1
vote
0 answers

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 command with a stream mode Restored using pg_probackup…
Alexander
  • 181
  • 1
  • 7
1
2