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: | Raw Message | Whole Thread | 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 |