Aiven-Open / Aiven-Open/pghoard

Discussion - restore backup using remote daemon

Aperta
#203 2 commenti 5 reazioni 0 assegnatari Vedi su GitHub
Lingua principale
Python
Stelle
1.4k
Fork
111
Merge medio
1g 5h
PR unite (30g)
2

Descrizione

I'm a little bit confused on how to best implement `pghoard` when it comes to managing multiple db servers. After playing around with local backups and restoring them to the same machine they were taken on, I then moved on to working on an environment that more closely matches our current setup.

Right now I have three AWS EC2 servers:
- Master Database
- Slave Database
- Dedicated PGHoard Server

I thought it would make sense to have a server dedicated to running the `pghoard` daemon taking basebackups and archiving WAL files with `pg_receivexlog`, but I then tried to spin up a new database server and restore from a basebackup and discovered that the `pghoard` webserver doesn't transfer WAL files remotely.

I'm curious to know how other people are implementing `pghoard`? When I restore, should I just start a local `pghoard` daemon and add a maintenance file so no backups are taken while I'm restoring? Is there a way to have a single remote `pghoard` daemon?

Thanks in advance.

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.