How to remote access PostgreSQL database and get its dump to local?

Question

I need to access the remote database server(linux) and also take its dump to my local(mac).

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'test-name',
    'USER': 'test-user',
    'PASSWORD': 'pwd',
    'HOST': 'test.amazonaws.com',
    }
}

This may come in handy: http://stackoverflow.com/a/37674134/3886053 — Ezequiel Tolnay, Jul 25 '16 at 05:53

score 0 · Answer 1 · edited May 23 '17 at 11:44

In local bash, you can connect and dump the remote database with pg_dump command, see Copying PostgreSQL database to another server

Using Python is similar, except that you need to use psycopg2 module to connect and send commands to database server. You may find this post useful Postgresql Database Backup Using Python

Alternatively, if you need to execute the script in the database server, a better idea would be dump it remotely, then fetch it to local machine.

How to remote access PostgreSQL database and get its dump to local?

1 Answers1