flink / dokku-psql-single-container Goto Github PK

View Code? Open in Web Editor NEW

This project forked from ohardy/dokku-psql

51.0 51.0 9.0 72 KB

Plugin for dokku that provides a Postgresql server in a single container

License: MIT License

Shell 100.00%

dokku-psql-single-container's People

Stargazers

Watchers

Forkers

krisrang sherbondy puttu rincewind zren yoyostile martim00 darklow dumbbond

dokku-psql-single-container's Issues

Database creation failed: role does not exist

I'm not sure if this is a problem with what I'm doing or with the plugin.

I created a fresh dokku 0.3.19 droplet on digital ocean, set up hostnames etc. (I'm using sub domains for my apps).

I deployed my app 'asc' to the server.
Installed 'dokku-psql-single-container'

Then ran $ dokku psql:create asc

root@asc:~# dokku psql:create asc
-----> Creating database asc
ERROR:  syntax error at or near "asc"
LINE 1: CREATE USER asc WITH PASSWORD '4f6a617109a235e0e5778bc20c22b...
                    ^
createdb: database creation failed: ERROR:  role "asc" does not exist
ERROR:  syntax error at or near "asc"
LINE 1: GRANT ALL PRIVILEGES ON DATABASE asc TO asc;
                                         ^
-----> Setting config vars for asc

It seems as though the databse exists but the role doesn't:

root@asc:~# dokku psql:dump asc
pg_dump: [archiver (db)] connection to database "asc" failed: FATAL:  role "asc" does not exist
root@asc:~# dokku psql:create asc
Database for asc already exists
root@asc:~# dokku psql:list
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(3 rows)

Am I missing something? Thanks

/home/dokku/.psql-sc/db_testing_app: Permission denied

When using this plugin with Dokku v0.3.16 I get the following error:

dokku@production:~$ dokku psql:create testing_app
/var/lib/dokku/plugins/psql-sc/commands: line 33: /home/dokku/.psql-sc/db_testing_app: Permission denied
/var/lib/dokku/plugins/psql-sc/commands: line 34: /home/dokku/.psql-sc/pass_testing_app: Permission denied
chmod: cannot access ‘/home/dokku/.psql-sc/db_testing_app’: No such file or directory
chmod: cannot access ‘/home/dokku/.psql-sc/pass_testing_app’: No such file or directory
-----> Creating database testing_app
ERROR:  role "testing_app" already exists
createdb: database creation failed: ERROR:  database "testing_app" already exists
-----> Setting config vars for testing_app

Continuous archiving?

I was looking for a way to incrementally backup PostgreSQL, and came to this feature here http://www.postgresql.org/docs/9.1/static/continuous-archiving.html Maybe it is useful to add commands to this plugin to enable that?

Currently we have psql:dump and psql:restore for backup and restoring. They are great and simple. However, they both operate on a single database (which, in itself, is often desirable), and all operate on a complete backup for the database. In addition to this, I think it'd be useful to have a incremental backup solution for the all databases at once (just for disaster recovery case).

It could be something that works like:

psql:archive_enable: write PostgreSQL config to enable continuous archiving, and initiate the base backup
psql:archive_disable: disable continuous archiving, and (optionally) delete the archive
psql:archive_path: gives a path that the user can use rsync on to extract the archive files out of the container
psql:archive_restore: restore the databases from the archive files

And for disaster recovery, the user can rsync the archive files back to psql:archive_path, and then run psql:archive_restore.

I can write a PR to implement this if it sounds like something useful :)

dokku 0.5.x help gets corrupted by this plugin

After you install dokku 0.5.x and this plugin, dokku's help gets truncated.

ssh [email protected] help
Usage: dokku [--quiet|--trace|--rm-container|--rm|--force] COMMAND <app> [command-specific-options]

Primary help options, type "dokku COMMAND:help" for more details, or dokku help --all to see all commands.

Commands:

    apps             List your apps
    checks           Show zero-downtime status
    config           Display all global or app-specific config vars
    docker-options   Display app's Docker options for all phases (or comma separated phase list)
    domains          List domains
    enter            Connect to a specific app container
    events           Show the last events (-t follows)
    help             Print the list of commands
    logs             Show the last logs for an application
    ls               Pretty listing of deployed applications and containers
    plugin           Print active plugins
    proxy            Show proxy for app
    ps               List processes running in app container(s)
    run              Run a command in the environment of an application
    shell            Spawn dokku shell
    tags             List all app image tags
    trace            Enable dokku tracing
    url              Show the first URL for an application (compatibility)
    urls             Show all URLs for an application
    version          Print dokku's version

Community plugin commands:

    apps:link <app-source> <app-target>     Set in <app-target> variable APP_SOURCE_NAME_URL with access url
    apps:unlink <app-source> <app-target>   Unset in <app-target> APP_SOURCE_NAME_URL
    mongo:clone <name> <new-name>           Create container <new-name> then copy data from <name> into <new-name>
    mongo:connect <name>                    Connect via telnet to a MongoDB service
    mongo:create <name>                     Create a MongoDB service
    mongo:destroy <name>                    Delete the MongoDB service and stop its container if there are no links left
    mongo:export <name>                     Export a dump of the MongoDB service database
    mongo:expose <name> [port]              Expose a MongoDB service on custom port if provided (random port otherwise)
    mongo:import <name> < <file>            Import a dump into the MongoDB service database
    mongo:info <name>                       Print the connection information
    mongo:link <name> <app>                 Link the MongoDB service to the app
    mongo:list                              List all MongoDB services
    mongo:logs <name> [-t]                  Print the most recent log(s) for this service
    mongo:promote <name> <app>              Promote service <name> as MONGO_URL in <app>
    mongo:restart <name>                    Graceful shutdown and restart of the MongoDB service container
    mongo:start <name>                      Start a previously stopped MongoDB service
    mongo:stop <name>                       Stop a running MongoDB service
    mongo:unexpose <name>                   Unexpose a previously exposed MongoDB service
    mongo:unlink <name> <app>               Unlink the MongoDB service from the app
    psql:admin_console                      Launch a postgresql console as admin user
    psql:console <app>                      Launch a postgresql console for <app>
    psql:create <app>                       Create a Postgresql database for <app>
    psql:delete <app>                       Delete Postgresql database for <app>
    psql:dump <app> > <filename.dump>       Dump <app> database to PG dump format
    psql:link <source> <target>             Link <source> app DB to <target> app
    psql:list                               List all databases
    psql:restart                            Restart the Postgresql docker container
    psql:restore <app> < <filename.*>       Restore database to <app> from any non-plain-text format exported by pg_dump
column: Invalid or incomplete multibyte or wide character

Errors for psql plugin while listing all plugins

$ dokku plugin
  ps                   0.4.0 enabled    dokku core ps plugin

cat: /var/lib/dokku/plugins/available/psql/plugin.toml: No such file or directory
panic: interface conversion: interface is nil, not map[string]interface {}

goroutine 1 [running]:
runtime.panic(0x5ffd60, 0xc21004a0c0)
        /usr/lib/go/src/pkg/runtime/panic.c:266 +0xb6
main.TomlGet(0xc21000a030, 0x2, 0x2)
        /tmp/tmp/plugn/plugn.go:30 +0x1d1
github.com/progrium/go-basher.(*Context).HandleFuncs(0xc21000f320, 0xc21000a000, 0x5, 0x5, 0x0)

[ ... ] More golang error stack until next plugin

Can't list databases, asks for password

Hard to say when it stopped working or was it working while ago, but for a while I can't list psql databases anymore.

If I run sudo dokku psql:list it asks for some kind of password, which I have no idea about. Is this expected behaviour? I just want a list of all databases that plugin has created.
Thank you.

$ sudo dokku psql:list
Password for user postgres:

dokku version: 0.5.6
plugin version: latest

Upgrade from 9.3 to 9.4

Is there a recommended way to do this or should I experiment?

can't pgadmin into the database

Hi,

I am trying to connect to the database with pgadmin. I have a MacOS running dokku via vagrant. I tried this option:

dokku config:set --global PSQL_SC_BIND_IP=0.0.0.0

I also defined this port mapping in Virtualbox:

external:5432 --> internal:5432

It still did not work. So I used vagrant ssh to get into the machine. I can see the docker image:

vagrant@dokku:~$ sudo docker ps | grep psql
d1d0d74ce9fa        postgres:9.3                  "/docker-entrypoint.s"   11 weeks ago        Up 28 minutes       5432/tcp            psql-single-container

I guess what is missing is a mapping from this Linux itself into the docker image. This would normally be doable in docker by passing the mapping from external port to internal port. How can I override this in your docker container?

Thanks!

DATABASE_URL should use symbolic hostname

I have noticed that this plugin injects DATABASE_URL (nice) but with a hardcoded IP (not nice):

DATABASE_URL: postgresql://core_server:7484fa2a31bb01b29d5f274f4a559d27081d8db0f24372ddb88acb098f1a9b91@172.17.0.1:5432/co

According to "The Docker Book":

"Tip Remember how we mentioned that container IP addresses change when a container is restarted? Well since Docker version 1.3 if the linked container is restarted then the IP address in the /etc/hosts file will be updated with the new IP address."

Can't we use links and the symbolic name and therefore avoid IPs in DATABASE_URL, which would make us survive a reboot? There is a redis plugin that seems to follow this approach:

https://github.com/sekjun9878/dokku-redis-plugin/blob/master/libconfig

Search for REDIS_URL. It always injects the hostname "redis" in /etc/hosts, thanks to the way the linked container is hooked in.

According to the docker book, the hostname used is the alias for the link. Example:

sudo docker run -p 4567 --name webapp2 --link redis:db ...

So, here the "db" hostname will be injected into /etc/hosts of the container where we are hooking the link.

I will experiment with a patch for this in my PostGIS fork, ok?

"dokku psql:dumpall" for backups

Would be convenient to be able to crontab a single job to back up all databases, so you don't miss it when you add new ones.

There is a pg_dumpall – this seems to work:

docker exec psql-single-container su postgres -c "pg_dumpall" > /tmp/big.dump

dokku 0.3.17 deb's postinst changes owner of /home/dokku/.psql-sc/data

After upgrading dokku 0.3.17 deb, postgres causes permission errors.

Owner of /home/dokku/.psql-sc/data is 999 normally.
But sshcommand create dokku /usr/local/bin/dokku in dokku.postinit makes its owner dokku.
https://github.com/progrium/dokku/blob/713a8d4f312d03f3c7ef0a7dc0c08eeaab917150/debian/postinst#L12
https://github.com/progrium/sshcommand/blob/e6d1655ffb4e381910d14eeb92dd9b32456a5fd2/sshcommand#L26

After upgrading, I restore permissions using chown -R 999 /home/dokku/.psql-sc/data now.

Where to find password for psql:admin_console or how can I reset it?

I've been using this plugin for many months now.
And now realised i need superuser privileges to create specific extension.
But I can't find superuser password to run dokku psql:admin_console
Is there a file somewhere to look for it, or to reset it?
Thank you.

Add helpful error on "dokku psql:restore x y.dump" without "<"

I misread the docs and forgot the "<". That appears to just do nothing, silently waiting for input on the command-line.

Maybe the plugin could notice that situation and provide a helpful message?

How can I pass --data-only --table when doing a dump?

How can I perform a dump as described in https://feeding.cloud.geek.nz/posts/restoring-single-table-from-postgres/ , passing --data-only and --table ?

I would like to pass these parameters on dump and, in some cases, on restore as well (when restoring from full dumps).

If you can provide an example, that would be great. Thanks!

dump command waits for enter

I tried using the dump command but it wouldn't return me to a prompt, I had to hit enter first. This makes it hard to use in scripts.

Removing the -i flag from the docker exec command seems to fix this and then it works as expected.

Could you remover the -i flag please, or is there a reason for it?

https://github.com/Flink/dokku-psql-single-container/blob/master/commands#L89

No data provided on stdin.

hi there,

i've uploaded a .dump file on my server root path and I am trying to restore the DB of my app from that file.

from my l command you can see that the file exists.

Doesn't work with .dump or .sql file. The file was created from pg_dump zeitschild-dev -f zeitschild-dev.sql

Consider deprecating

This and your memcached plugins are covered by the official ones ;)

Linking a db container with multiple app containers

In my use case, I am trying to deploy two separate apps sharing access to one database (one as the backend, another as a db-read-only fronted).

I wonder if there is any way currently to link a PostgreSQL container with multiple app containers?

Feature: Configure PSQL_ROOT in ENV

I am deploying postgresql on SSD partition therefore i must modify you repo functions file after cloning.
It would be very useful if PSQL_ROOT could be configurable same way as postgresql version by ENV.

PS. Thank you for this nice and useful plugin.

error when restoring into an app with a slightly different name

I use the app named softdispdjango-dev for development and then softdispdjango for demos. Do, I dumped the database from "softdispdjango-dev" and tried to restore into softdispdjango. Unfortunately I get errors:

vagrant@dokku-vagrant:~$ dokku psql:restore softdispdjango < /vagrant/softdispdjango-dev-2015-12-04.dump
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2013; 2606 16478 FK CONSTRAINT user_id_refs_id_c0d12874 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT user_id_refs_id_c0d12874;

pg_restore: [archiver (db)] Error from TOC entry 2021; 2606 16488 FK CONSTRAINT user_id_refs_id_4dc23c39 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT user_id_refs_id_4dc23c39;

pg_restore: [archiver (db)] Error from TOC entry 2019; 2606 16483 FK CONSTRAINT user_id_refs_id_40c41112 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT user_id_refs_id_40c41112;

pg_restore: [archiver (db)] Error from TOC entry 2025; 2606 16630 FK CONSTRAINT system_id_refs_id_c87b3e5b softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_healthsnapshot DROP CONSTRAINT system_id_refs_id_c87b3e5b;

pg_restore: [archiver (db)] Error from TOC entry 2026; 2606 16650 FK CONSTRAINT system_id_refs_id_743dd05c softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_newrelicsnapshot DROP CONSTRAINT system_id_refs_id_743dd05c;

pg_restore: [archiver (db)] Error from TOC entry 2023; 2606 16611 FK CONSTRAINT system_id_refs_id_53a5e0ae softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incident DROP CONSTRAINT system_id_refs_id_53a5e0ae;

pg_restore: [archiver (db)] Error from TOC entry 2022; 2606 16636 FK CONSTRAINT parent_id_refs_id_52ae967c softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_system DROP CONSTRAINT parent_id_refs_id_52ae967c;

pg_restore: [archiver (db)] Error from TOC entry 2024; 2606 16616 FK CONSTRAINT incident_id_refs_id_a42b464e softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incidentupdate DROP CONSTRAINT incident_id_refs_id_a42b464e;

pg_restore: [archiver (db)] Error from TOC entry 2017; 2606 16433 FK CONSTRAINT group_id_refs_id_f4b32aac softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT group_id_refs_id_f4b32aac;

pg_restore: [archiver (db)] Error from TOC entry 2027; 2606 16699 FK CONSTRAINT dashbo_client_system_id_54d93b3e0ad1525d_fk_dashboard_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashbo_client_system_id_54d93b3e0ad1525d_fk_dashboard_sys...
pg_restore: [archiver (db)] Error from TOC entry 2028; 2606 16704 FK CONSTRAINT dashb_service_system_id_3e039a9228c1383c_fk_dashboard_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashb_service_system_id_3e039a9228c1383c_fk_dashboard_sys...
pg_restore: [archiver (db)] Error from TOC entry 2015; 2606 16508 FK CONSTRAINT content_type_id_refs_id_d043b34a softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT content_type_id_refs_id_d043b34a;

pg_restore: [archiver (db)] Error from TOC entry 2014; 2606 16503 FK CONSTRAINT content_type_id_refs_id_93d2d1f8 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT content_type_id_refs_id_93d2d1f8;

pg_restore: [archiver (db)] Error from TOC entry 2020; 2606 16463 FK CONSTRAINT auth_user_user_permissions_permission_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_permission_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 2018; 2606 16448 FK CONSTRAINT auth_user_groups_group_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_group_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 2016; 2606 16418 FK CONSTRAINT auth_group_permissions_permission_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_permission_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 1989; 1259 16544 INDEX django_session_session_key_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_session_session_key_like" does not exist
    Command was: DROP INDEX public.django_session_session_key_like;

pg_restore: [archiver (db)] Error from TOC entry 1986; 1259 16545 INDEX django_session_expire_date softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_session_expire_date" does not exist
    Command was: DROP INDEX public.django_session_expire_date;

pg_restore: [archiver (db)] Error from TOC entry 1948; 1259 16533 INDEX django_admin_log_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_admin_log_user_id" does not exist
    Command was: DROP INDEX public.django_admin_log_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1945; 1259 16534 INDEX django_admin_log_content_type_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_admin_log_content_type_id" does not exist
    Command was: DROP INDEX public.django_admin_log_content_type_id;

pg_restore: [archiver (db)] Error from TOC entry 2010; 1259 16709 INDEX dashboard_systemdependency_cae6e9f0 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_systemdependency_cae6e9f0" does not exist
    Command was: DROP INDEX public.dashboard_systemdependency_cae6e9f0;

pg_restore: [archiver (db)] Error from TOC entry 2009; 1259 16710 INDEX dashboard_systemdependency_7dad87f4 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_systemdependency_7dad87f4" does not exist
    Command was: DROP INDEX public.dashboard_systemdependency_7dad87f4;

pg_restore: [archiver (db)] Error from TOC entry 1992; 1259 16641 INDEX dashboard_system_parent_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_system_parent_id" does not exist
    Command was: DROP INDEX public.dashboard_system_parent_id;

pg_restore: [archiver (db)] Error from TOC entry 2006; 1259 16655 INDEX dashboard_newrelicsnapshot_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_newrelicsnapshot_system_id" does not exist
    Command was: DROP INDEX public.dashboard_newrelicsnapshot_system_id;

pg_restore: [archiver (db)] Error from TOC entry 1998; 1259 16621 INDEX dashboard_incidentupdate_incident_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_incidentupdate_incident_id" does not exist
    Command was: DROP INDEX public.dashboard_incidentupdate_incident_id;

pg_restore: [archiver (db)] Error from TOC entry 1997; 1259 16610 INDEX dashboard_incident_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_incident_system_id" does not exist
    Command was: DROP INDEX public.dashboard_incident_system_id;

pg_restore: [archiver (db)] Error from TOC entry 2003; 1259 16635 INDEX dashboard_healthsnapshot_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_healthsnapshot_system_id" does not exist
    Command was: DROP INDEX public.dashboard_healthsnapshot_system_id;

pg_restore: [archiver (db)] Error from TOC entry 1981; 1259 16543 INDEX auth_user_username_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_username_like" does not exist
    Command was: DROP INDEX public.auth_user_username_like;

pg_restore: [archiver (db)] Error from TOC entry 1974; 1259 16541 INDEX auth_user_user_permissions_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_user_permissions_user_id" does not exist
    Command was: DROP INDEX public.auth_user_user_permissions_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1971; 1259 16542 INDEX auth_user_user_permissions_permission_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_user_permissions_permission_id" does not exist
    Command was: DROP INDEX public.auth_user_user_permissions_permission_id;

pg_restore: [archiver (db)] Error from TOC entry 1968; 1259 16539 INDEX auth_user_groups_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_groups_user_id" does not exist
    Command was: DROP INDEX public.auth_user_groups_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1965; 1259 16540 INDEX auth_user_groups_group_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_groups_group_id" does not exist
    Command was: DROP INDEX public.auth_user_groups_group_id;

pg_restore: [archiver (db)] Error from TOC entry 1949; 1259 16535 INDEX auth_permission_content_type_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_permission_content_type_id" does not exist
    Command was: DROP INDEX public.auth_permission_content_type_id;

pg_restore: [archiver (db)] Error from TOC entry 1957; 1259 16537 INDEX auth_group_permissions_permission_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_permissions_permission_id" does not exist
    Command was: DROP INDEX public.auth_group_permissions_permission_id;

pg_restore: [archiver (db)] Error from TOC entry 1954; 1259 16536 INDEX auth_group_permissions_group_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_permissions_group_id" does not exist
    Command was: DROP INDEX public.auth_group_permissions_group_id;

pg_restore: [archiver (db)] Error from TOC entry 1962; 1259 16538 INDEX auth_group_name_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_name_like" does not exist
    Command was: DROP INDEX public.auth_group_name_like;

pg_restore: [archiver (db)] Error from TOC entry 1991; 2606 16531 CONSTRAINT south_migrationhistory_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.south_migrationhistory" does not exist
    Command was: ALTER TABLE ONLY public.south_migrationhistory DROP CONSTRAINT south_migrationhistory_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1988; 2606 16520 CONSTRAINT django_session_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_session" does not exist
    Command was: ALTER TABLE ONLY public.django_session DROP CONSTRAINT django_session_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2008; 2606 16675 CONSTRAINT django_migrations_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_migrations" does not exist
    Command was: ALTER TABLE ONLY public.django_migrations DROP CONSTRAINT django_migrations_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1985; 2606 16500 CONSTRAINT django_content_type_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1983; 2606 16502 CONSTRAINT django_content_type_app_label_model_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_app_label_model_key;

pg_restore: [archiver (db)] Error from TOC entry 1947; 2606 16397 CONSTRAINT django_admin_log_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT django_admin_log_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1994; 2606 16570 CONSTRAINT dashboard_systemstatus_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_system DROP CONSTRAINT dashboard_systemstatus_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2012; 2606 16698 CONSTRAINT dashboard_systemdependency_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashboard_systemdependency_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2005; 2606 16649 CONSTRAINT dashboard_newrelicsnapshot_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_newrelicsnapshot DROP CONSTRAINT dashboard_newrelicsnapshot_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2000; 2606 16609 CONSTRAINT dashboard_incidentupdate_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incidentupdate DROP CONSTRAINT dashboard_incidentupdate_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1996; 2606 16587 CONSTRAINT dashboard_incident_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incident DROP CONSTRAINT dashboard_incident_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2002; 2606 16629 CONSTRAINT dashboard_healthsnapshot_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_healthsnapshot DROP CONSTRAINT dashboard_healthsnapshot_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1980; 2606 16477 CONSTRAINT auth_user_username_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_username_key;

pg_restore: [archiver (db)] Error from TOC entry 1976; 2606 16462 CONSTRAINT auth_user_user_permissions_user_id_permission_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_user_id_permission_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1973; 2606 16460 CONSTRAINT auth_user_user_permissions_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1978; 2606 16475 CONSTRAINT auth_user_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1970; 2606 16447 CONSTRAINT auth_user_groups_user_id_group_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_user_id_group_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1967; 2606 16445 CONSTRAINT auth_user_groups_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1953; 2606 16405 CONSTRAINT auth_permission_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1951; 2606 16407 CONSTRAINT auth_permission_content_type_id_codename_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_content_type_id_codename_key;

pg_restore: [archiver (db)] Error from TOC entry 1964; 2606 16430 CONSTRAINT auth_group_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1959; 2606 16415 CONSTRAINT auth_group_permissions_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1956; 2606 16417 CONSTRAINT auth_group_permissions_group_id_permission_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_group_id_permission_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1961; 2606 16432 CONSTRAINT auth_group_name_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_name_key;

pg_restore: [archiver (db)] Error from TOC entry 1937; 2604 16526 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.south_migrationhistory" does not exist
    Command was: ALTER TABLE public.south_migrationhistory ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1943; 2604 16670 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_migrations" does not exist
    Command was: ALTER TABLE public.django_migrations ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1936; 2604 16498 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE public.django_content_type ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1928; 2604 16391 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE public.django_admin_log ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1944; 2604 16696 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE public.dashboard_systemdependency ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1938; 2604 16568 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE public.dashboard_system ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1942; 2604 16647 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE public.dashboard_newrelicsnapshot ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1940; 2604 16604 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE public.dashboard_incidentupdate ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1939; 2604 16582 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE public.dashboard_incident ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1941; 2604 16627 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE public.dashboard_healthsnapshot ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1934; 2604 16458 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1933; 2604 16443 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE public.auth_user_groups ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1935; 2604 16473 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE public.auth_user ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1930; 2604 16403 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE public.auth_permission ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1931; 2604 16413 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE public.auth_group_permissions ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1932; 2604 16428 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE public.auth_group ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 187; 1259 16521 SEQUENCE south_migrationhistory_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "south_migrationhistory_id_seq" does not exist
    Command was: DROP SEQUENCE public.south_migrationhistory_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 188; 1259 16523 TABLE south_migrationhistory softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "south_migrationhistory" does not exist
    Command was: DROP TABLE public.south_migrationhistory;

pg_restore: [archiver (db)] Error from TOC entry 186; 1259 16513 TABLE django_session softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_session" does not exist
    Command was: DROP TABLE public.django_session;

pg_restore: [archiver (db)] Error from TOC entry 199; 1259 16665 SEQUENCE django_migrations_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_migrations_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_migrations_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 200; 1259 16667 TABLE django_migrations softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_migrations" does not exist
    Command was: DROP TABLE public.django_migrations;

pg_restore: [archiver (db)] Error from TOC entry 184; 1259 16493 SEQUENCE django_content_type_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_content_type_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_content_type_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 185; 1259 16495 TABLE django_content_type softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_content_type" does not exist
    Command was: DROP TABLE public.django_content_type;

pg_restore: [archiver (db)] Error from TOC entry 170; 1259 16386 SEQUENCE django_admin_log_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_admin_log_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_admin_log_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 171; 1259 16388 TABLE django_admin_log softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_admin_log" does not exist
    Command was: DROP TABLE public.django_admin_log;

pg_restore: [archiver (db)] Error from TOC entry 201; 1259 16691 SEQUENCE dashboard_systemdependency_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_systemdependency_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_systemdependency_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 202; 1259 16693 TABLE dashboard_systemdependency softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_systemdependency" does not exist
    Command was: DROP TABLE public.dashboard_systemdependency;

pg_restore: [archiver (db)] Error from TOC entry 189; 1259 16563 SEQUENCE dashboard_system_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_system_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_system_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 190; 1259 16565 TABLE dashboard_system softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_system" does not exist
    Command was: DROP TABLE public.dashboard_system;

pg_restore: [archiver (db)] Error from TOC entry 197; 1259 16642 SEQUENCE dashboard_newrelicsnapshot_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_newrelicsnapshot_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_newrelicsnapshot_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 198; 1259 16644 TABLE dashboard_newrelicsnapshot softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_newrelicsnapshot" does not exist
    Command was: DROP TABLE public.dashboard_newrelicsnapshot;

pg_restore: [archiver (db)] Error from TOC entry 193; 1259 16599 SEQUENCE dashboard_incidentupdate_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_incidentupdate_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_incidentupdate_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 194; 1259 16601 TABLE dashboard_incidentupdate softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_incidentupdate" does not exist
    Command was: DROP TABLE public.dashboard_incidentupdate;

pg_restore: [archiver (db)] Error from TOC entry 191; 1259 16577 SEQUENCE dashboard_incident_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_incident_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_incident_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 192; 1259 16579 TABLE dashboard_incident softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_incident" does not exist
    Command was: DROP TABLE public.dashboard_incident;

pg_restore: [archiver (db)] Error from TOC entry 195; 1259 16622 SEQUENCE dashboard_healthsnapshot_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_healthsnapshot_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_healthsnapshot_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 196; 1259 16624 TABLE dashboard_healthsnapshot softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_healthsnapshot" does not exist
    Command was: DROP TABLE public.dashboard_healthsnapshot;

pg_restore: [archiver (db)] Error from TOC entry 180; 1259 16453 SEQUENCE auth_user_user_permissions_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_user_permissions_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_user_permissions_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 181; 1259 16455 TABLE auth_user_user_permissions softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user_user_permissions" does not exist
    Command was: DROP TABLE public.auth_user_user_permissions;

pg_restore: [archiver (db)] Error from TOC entry 182; 1259 16468 SEQUENCE auth_user_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 178; 1259 16438 SEQUENCE auth_user_groups_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_groups_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_groups_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 179; 1259 16440 TABLE auth_user_groups softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user_groups" does not exist
    Command was: DROP TABLE public.auth_user_groups;

pg_restore: [archiver (db)] Error from TOC entry 183; 1259 16470 TABLE auth_user softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user" does not exist
    Command was: DROP TABLE public.auth_user;

pg_restore: [archiver (db)] Error from TOC entry 172; 1259 16398 SEQUENCE auth_permission_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_permission_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_permission_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 173; 1259 16400 TABLE auth_permission softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_permission" does not exist
    Command was: DROP TABLE public.auth_permission;

pg_restore: [archiver (db)] Error from TOC entry 174; 1259 16408 SEQUENCE auth_group_permissions_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_group_permissions_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_group_permissions_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 175; 1259 16410 TABLE auth_group_permissions softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_group_permissions" does not exist
    Command was: DROP TABLE public.auth_group_permissions;

pg_restore: [archiver (db)] Error from TOC entry 176; 1259 16423 SEQUENCE auth_group_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_group_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_group_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 177; 1259 16425 TABLE auth_group softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_group" does not exist
    Command was: DROP TABLE public.auth_group;

pg_restore: [archiver (db)] Error from TOC entry 203; 3079 11756 EXTENSION plpgsql 
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension plpgsql
    Command was: DROP EXTENSION plpgsql;

pg_restore: [archiver (db)] Error from TOC entry 5; 2615 2200 SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of schema public
    Command was: DROP SCHEMA public;

pg_restore: [archiver (db)] could not execute query: ERROR:  schema "public" already exists
    Command was: CREATE SCHEMA public;



pg_restore: [archiver (db)] Error from TOC entry 2174; 0 0 COMMENT SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of schema public
    Command was: COMMENT ON SCHEMA public IS 'standard public schema';



pg_restore: [archiver (db)] Error from TOC entry 2175; 0 0 COMMENT EXTENSION plpgsql 
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension plpgsql
    Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';



WARNING: errors ignored on restore: 114

Is there a way to override the user/owner?

How to expose postgresql container to public?

Currently i see that 5432/tcp port is exposed for local connections.

CONTAINER ID        IMAGE                     COMMAND                CREATED             STATUS              PORTS               NAMES
104c2a2acf76        postgres:9.4              "/docker-entrypoint.   3 days ago          Up 21 hours         5432/tcp            psql-single-container

But i guess i need to bind it to exactly 0.0.0.0:5432->5432/tcp in order to make postgresql listen public.
When i was using original ohardy/dokku-psql repo the exposed ports looked like this:

716104709bf7        ohardy/postgresql:latest      "manage start"         11 weeks ago        Up 11 weeks         0.0.0.0:5432->5432/tcp             sharp_carson

Could you please help me what do i need to change to make my postgresql container to be available in public? Is it somehow configurable?

Thanks.

Not all pg_dump output formats supported by psql:restore

It says in the commands info for psql:restore

psql:restore     <app> < <filename.*> Restore database to <app> from any format exported by pg_dump

But not all formats exported by pg_dump are supported. I dumped to a sql script file, and this is what happens when I try to run psql:restore

pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

PostGIS?

Thank you for this plugin!

I wanted to have the same thing but with PostGIS support. If I am not mistaken, all I need to do is override the docker image in your functions file, right? So, a few considerations:

can you use an env var for the postgre docker image and fallback to your current hardcoded value? This would allow people like me to use PostGIS without having to fork your project just to change your functions file.
any recommendations on a good PostGIS docker image? There are so many, and I am not sure they would all be compatible with your plugin. Example: https://github.com/kartoza/docker-postgis

Thanks!

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.