Skip to content

Instantly share code, notes, and snippets.

View erichanson's full-sized avatar

Eric Hanson erichanson

View GitHub Profile
@erichanson
erichanson / gist:5a71256e7fc84bc8272d7c3e32963feb
Created February 8, 2019 11:37
Aquameta just ate itself
eric@phoenix:~/aquameta$ dropdb aquameta; createdb aquameta ; cat extension-to-bundle.sql | psql -a aquameta
create extension if not exists plpythonu;
CREATE EXTENSION
create extension if not exists multicorn schema public;
CREATE EXTENSION
create extension if not exists hstore schema public;
CREATE EXTENSION
create extension if not exists hstore_plpythonu schema public;
CREATE EXTENSION
create extension if not exists dblink schema public;
core@surinam ~ $ ls
db_deploy
core@surinam ~ $ cd db_deploy/
core@surinam ~/db_deploy $ ls
LICENSE README.md build.sh code data deps surinam.etcd
core@surinam ~/db_deploy $ cat build.sh
#!/bin/bash
docker build -rm -t "spacebase:deps" deps
docker build -rm -t "spacebase:code" code
docker build -rm -t "spacebase:data" data
ebook:~ eric$ ping aquameta.org
ping: cannot resolve aquameta.org: Unknown host
ebook:~ eric$ nslookup
> server ns1.linode.com
Default server: ns1.linode.com
Address: 69.93.127.10#53
> aquameta.org
;; connection timed out; no servers could be reached
> ^D
ebook:~ eric$ nslookup
{"status_code": 400, "message": "query string argument of EXECUTE is null\nCONTEXT: PL/pgSQL function www.row_update(text,text,text,text,json) line 3 at EXECUTE statement\nSQL statement \"SELECT (select www.row_update(path_parts[2], path_parts[3], path_parts[4], path_parts[6], data))\"\nPL/pgSQL function www.request(text,text,json,json) line 33 at RETURN\n", "title": "Bad Request"}
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+-------
spy | affiliation | table | eric
spy | affiliationrel | table | eric
spy | agent | table | eric
spy | language | table | eric
spy | languagerel | table | eric
spy | mission | table | eric
spy | securityclearance | table | eric
List of relations
Schema | Name | Type | Owner
---------+----------+-------+-------
sailors | boats | table | eric
sailors | reserves | table | eric
sailors | sailors | table | eric
Table "sailors.sailors"
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAveqLtq1kMODRrM5Vt8RkPDinUJgJ6CALs6p9qcMwRYKYsg2T6zwbfh29Y+GKuZEor9bLf6KD9LzvHAmd47XtPW/tt+N4VxydKnmKuglg5DRtsEysHtFRUZ2z1iLbgWOExfEppbLTNdkQdTrIPyfXijP2OyqzWJ3HCJfpi5ELxft/y3F89UMYcQk18Z3aDUYtbNPsIGrhw4QQ8kVyg6YTBFuHeBnjEcuHbMmfwzQ3P5EXRpmvJ/WuZlGw+4Z0aJ+sTg4mnT4j/h08TR1yLUSzwseiIOOtkUgapgBixAdsAYfz9+dbpJN+QOYeWYTDYNtTQ4jD6K/E3OwHhOu/nqiVww== codezstick
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAq0Xt33EBi5izL2V0TvXhBB4yXQr+PXRIBOlYiWkZOr/gINLQ5zgbtt5EZwJMO7pGc/I5FL/W+8hM/G8Ubd0BxBjxat+7M4VjwQgRXeYfGAZQP2rGrz5joU8aHUfL+WPEVhTuBznNsGIK8HWPFtwBgvJOrkTwmOR9qvH60PkwGPG4LJfZVbdHhRwENgoRr/o3/D04x6/U9sYK71SQWbL3Gwa4PMFSJHPhitmUyUMHrTgWoRPpMQDgDTrQZ6xcIdD8MUp+xxAWZ2xDL6Z0/URzdWS98dYaV3hYfeVJyeY2dFHiiAkr7zOGVrexW9coyajjFa47sms/hALDsBiOT/TrmQ== eric@ericbook.aquameta.com