Hi, I’ve recently uploaded my Django app to a Dokku droplet, and I want to know how I can make it to work with a dump of a database I have.
I’ve tried restoring to Postgres my dump but it’s not working, but, even if I where to restore data from dump, I still don’t know how can I make my app to use that database.
Could you tell me (baby steps) how can I make my Django app work with a Postgres database in Dokku droplet?
Thanks a lot!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
@Andrew SB <br> <br>It’s been a while, but I wanted to thank you for all your help and effort answering my question. <br> <br>Thanks
This answer over on StackExchange seems relevant: <br> <br>http://stackoverflow.com/a/22763027 <br> <br>
The dump was created from Heroku where original app exists (I want to migrate)
When I run the command I get <br> <br> PostgreSQL custom database dump - v1.12-0
That seems like you are getting the import commands correct, but you are now hitting another error with charterer encoding. What’s the encoding of your database dump? Run: <br> <br><pre> <br>file youfile.sql <br></pre> <br> <br>
EDIT: When I try to restore
I have a myApp.dump, How could I make it so it becomes a .sql?? <br> <br>When I try I get: <br> <br>invalid command ?4???b@???:??I0j_8?s?A?x??r7??ء4?p?m???c???.?(^???4?~?hslSA?QA?[4?[ir??O <br> ???W?Sq7?uFО? <br>invalid command ?/??(?1?Y=??S?+?٠???3?.M?!??Ku??H_?HT??>9 <br>invalid command <綑j??m?H7?} <br>invalid command |?A??c?e? <br> :4V?? <br>invalid command ???uj?f??K?-o??VqY??z;M???~?7g,?G??? <br>ERROR: invalid byte sequence for encoding “UTF8”: 0xea8e51 <br> <br>-----> myApp database restored <br>root@*****:~/myApp/myApp#
@Sascuash: <br> <br>You’d need to install the plugin yourself. Check out that GitHub link for more information, but basically what you need to do is: <br> <br><pre> <br>cd /var/lib/dokku/plugins/ <br>git clone https://github.com/Kloadut/dokku-pg-plugin.git postgresql <br>dokku plugins-install <br></pre> <br> <br>Then to set it up for the first time, you can run: <br> <br><pre> <br>dokku postgresql:create appname <br>dokku postgresql:restore appname < dump_file.sql <br></pre> <br> <br>If you’d rather just access the docker container the app is running directly, you can get a interactive shell with: <br> <br><pre> <br>docker run -i -t dokku/appname /bin/bash <br></pre>
Yes, I’m using the PostgreSQL plugin for Dokku. Now I’m following https://github.com/Kloadut/dokku-pg-plugin tutorial
When I do it I find it answers with: <br> <br> Unknown (or too old) PostgreSQL container <br> <br>I’m not sure if I’m using the PostgreSQL plugin for Dokku, when I started the droplet, I selected the Dokku option (instead of Linux distribution, I selected it from application option), so I’m not sure where it comes from. <br> <br>