![]() On the server that is currently running the database: I'm posting this as a solution on here because it details every step I had to take, feel free to add recommendations or improvements after reading other answers on here and doing some more research.įor Postgres 12 and Ubuntu 18.04 I had to do these actions: I chose to go this route because it backs up the entire database cluster (users, databases, etc.). # systemctl start is an example using pg_basebackup On the target server: # systemctl stop pg_basebackup -h SRC_IP -U postgres -D VERSION/NAME -progress You might want to resort to a more secure option.Ĭhanges 1, 2, 3 require server restart, change 4 requires reload. This grants access to the pg cluster to anyone from the DST_IP machine.
0 Comments
Leave a Reply. |