How to take backup of PostgreSQL 9.4 database to remote server using pg_basebackup

hemantho7 Unconfirmed, Community Member, Lectora® Accessibility Group (LAUG) Member, eLearning Brothers® Partner Posts: 1 ☆ Roadie ☆
We want to take the logical and base backup on different server machine in the network. Currently both backups are running on same server machine causing space issues. We have the scripts in place what are the necessary changes we need to make in the scripts to implement the same. Do we need to run the script on DB server machine and direct the backup on other network machine or do we need to run the script of another network machine (Network machine have the same version of PostgreSQL installed on it). Please guide me through the standard procedure under best practice


  • carlfink
    carlfink Community Member Posts: 1,102 ✭ Legend ✭
    You aren't giving enough information. What scripts, for instance?

    To solve the actual problem, why not just use some kind of remote storage, which could be anything from a SAN to Amazon's cloud storage infrastructure?