Need help with dokku-pg-plugin?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

Kloadut
199 Stars 79 Forks 100 Commits 28 Opened issues

Description

PostgreSQL plugin for Dokku

Services available

!
?

Need anything else?

Contributors list

No Data

PostgreSQL plugin for Dokku

Project: https://github.com/progrium/dokku

Warning: This plugin is under development and still only tested with the below dependencies

Requirements

  • Docker version
    0.7.2
    or higher
  • Dokku version
    0.2.1
    or higher

Installation

cd /var/lib/dokku/plugins
git clone https://github.com/Kloadut/dokku-pg-plugin postgresql
dokku plugins-install

Commands

$ dokku help
    postgresql:console                         Open a PostgreSQL console
    postgresql:create                          Create a PostgreSQL container
    postgresql:delete                          Delete specified PostgreSQL container
    postgresql:dump  > dump_file.sql           Dump database data
    postgresql:info                            Display database informations
    postgresql:link                       Link an app to a PostgreSQL database
    postgresql:list                                Display list of PostgreSQL containers
    postgresql:logs                            Display last logs from PostgreSQL container
    postgresql:restore  < dump_file.sql        Restore database data from a previous dump

Simple usage

Create a new DB: ``` $ dokku postgresql:create foo # Server side $ ssh [email protected]rver postgresql:create foo # Client side

-----> PostgreSQL container created: postgresql/foo

   Host: 172.17.42.1
   User: 'root'
   Password: 'RDSBYlUrOYMtndKb'
   Database: 'db'
   Public port: 49187
Deploy your app with the same name (client side):

$ git remote add dokku [email protected]:foo $ git push dokku master

Link your app to the database
```bash
dokku postgresql:link app_name database_name

Advanced usage

Inititalize the database with SQL statements:

cat init.sql | dokku postgresql:create foo

Open a PostgreSQL console for specified database:

dokku postgresql:console foo

Deleting databases:

dokku postgresql:delete foo

Linking an app to a specific database:

dokku postgresql:link foo bar

PostgreSQL logs (per database):

dokku postgresql:logs foo

Database information:

dokku postgresql:info foo

List of containers:

dokku postgresql:list

Dump a database:

dokku postgresql:dump foo > foo.sql

Restore a database:

dokku postgresql:restore foo < foo.sql

In case Dokku says

pg_dump not found
when dumping or restoring database:
sudo apt-get install postgresql-client-9.3

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.