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: stackoverflow.com/a/37674134/3886053 — Ezequiel Tolnay
– Ezequiel Tolnay, Commented Jul 25, 2016 at 5:53

Community · Accepted Answer · 2017-05-23 11:44:22Z

0

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.

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Jul 25, 2016 at 3:14

Neo X

9577 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related