| From: | Chuck Martin <clmartin(at)theombudsman(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | getting pg_basebackup to use remote destination |
| Date: | 2018-12-29 19:04:37 |
| Message-ID: | CAFw6=U3TkX=qGEshwUS4iipx3E2SUcP5=G7L6v2AgBGywiOHnA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I thought I knew how to do this, but I apparently don't. I have to set up a
new server as a standby for a PG 11.1 server. The main server has a lot
more resources than the standby. What I want to do is run pg_basebackup on
the main server with the output going to the data directory on the new
server. But when I give this command:
pg_basebackup -D "ssh root(at)10(dot)0(dot)1(dot)16:/mnt/dbraid/data" -P -v -X s
it instead writes to my root drive which doesn't have the space, so it
fails and deletes the partial backup.
While I think I could figure out how to backup to a local directory then
rsync it to the new server, I'd like to avoid that due to the 750GB size.
Is there a way to tell pg_basebackup to use a remote destination for
output? Or do I have to run pg_basebackup on the standby server?
And while I'm asking, has anyone yet written a guide/tutorial for PG 11
replication? Everything I find online is very old.
Chuck Martin
Avondale Software
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-12-29 20:38:04 | Re: getting pg_basebackup to use remote destination |
| Previous Message | Glenn Schultz | 2018-12-29 18:34:31 | Recursive CTE |