Postgresql migration (from local machine to digital ocean)

Asked Dec 01 '17 at 17:28

Active Dec 01 '17 at 17:28

Viewed 79 times

I want to move my local Postgresql database (preloaded with data) into my digitalocean droplet.

2 challenges I'm facing:

the /data/base/25760 is the folder with my data, do I SCP this directly into Digital Ocean Root/home/django/django-project?
How do I link the database to the droplet using the settings.py file? I'm getting errors: FATAL: password authentication failed for user "root"

From my search, it looks like users are not advised to load their local databases directly into their VPS, maybe I'm wrong about this. thanks very much!

asked Dec 01 '17 at 17:28

myexp factory

You can't simply copy a file, that's not how databases like Postgres work. You need to expert your data locally and import it to your production db. – Daniel Roseman Dec 01 '17 at 21:14
that sounds reasonable; can you give me some direction how this might work specifically? – myexp factory Dec 02 '17 at 03:34

Postgresql migration (from local machine to digital ocean)

0 Answers0