{"action":"created","issue":{"url":"https://api.github.com/repos/PecanProject/pecan/issues/425","labels_url":"https://api.github.com/repos/PecanProject/pecan/issues/425/labels{/name}","comments_url":"https://api.github.com/repos/PecanProject/pecan/issues/425/comments","events_url":"https://api.github.com/repos/PecanProject/pecan/issues/425/events","html_url":"https://github.com/PecanProject/pecan/issues/425","id":68745101,"number":425,"title":"Question about BETYdb load","user":{"login":"serbinsh","id":3067369,"avatar_url":"https://avatars.githubusercontent.com/u/3067369?v=3","gravatar_id":"","url":"https://api.github.com/users/serbinsh","html_url":"https://github.com/serbinsh","followers_url":"https://api.github.com/users/serbinsh/followers","following_url":"https://api.github.com/users/serbinsh/following{/other_user}","gists_url":"https://api.github.com/users/serbinsh/gists{/gist_id}","starred_url":"https://api.github.com/users/serbinsh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serbinsh/subscriptions","organizations_url":"https://api.github.com/users/serbinsh/orgs","repos_url":"https://api.github.com/users/serbinsh/repos","events_url":"https://api.github.com/users/serbinsh/events{/privacy}","received_events_url":"https://api.github.com/users/serbinsh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/PecanProject/pecan/labels/BETY","name":"BETY","color":"eb6420"},{"url":"https://api.github.com/repos/PecanProject/pecan/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"serbinsh","id":3067369,"avatar_url":"https://avatars.githubusercontent.com/u/3067369?v=3","gravatar_id":"","url":"https://api.github.com/users/serbinsh","html_url":"https://github.com/serbinsh","followers_url":"https://api.github.com/users/serbinsh/followers","following_url":"https://api.github.com/users/serbinsh/following{/other_user}","gists_url":"https://api.github.com/users/serbinsh/gists{/gist_id}","starred_url":"https://api.github.com/users/serbinsh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serbinsh/subscriptions","organizations_url":"https://api.github.com/users/serbinsh/orgs","repos_url":"https://api.github.com/users/serbinsh/repos","events_url":"https://api.github.com/users/serbinsh/events{/privacy}","received_events_url":"https://api.github.com/users/serbinsh/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-04-15T17:49:25Z","updated_at":"2015-04-15T18:52:38Z","closed_at":null,"body":"Hello again @robkooper and @dlebauer, @Viskari and I were finally able to get everything operating properly (I think) after overhauling the gcc/gfortran dn openmpi libs then re-compiling everything using a consistent gcc lib.  As such, I have made an attempt to load bety locally (see below).  Based on your experiences, does this look correct?  My one concern are the:\r\n\r\nERROR:  must be owner of extension plpgsql\r\nERROR:  must be owner of extension postgis\r\n\r\nReports.  Otherwise, it seems that all the data has been loaded.\r\n\r\nMy load command was as follows:\r\n\r\nsudo -u postgres CREATE=YES MYSITE=3 scripts/load.bety.sh\r\n\r\nDid I miss anything?  Do I need postgres or bety to take ownership of the plpgsql and postgis extensions?  Do I need to run this command from the postgres user rather than as sudo? \r\n\r\nThanks!\r\nS\r\n\r\n```\r\n[sserbin@test pecan]$ sudo -u postgres CREATE=YES MYSITE=3 scripts/load.bety.sh\r\n bety      \r\n  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\r\n                                 Dload  Upload   Total   Spent    Left  Speed\r\n100 4641k  100 4641k    0     0  4488k      0  0:00:01  0:00:01 --:--:-- 8691k\r\nLoading schema                    : NOTICE:  drop cascades to 4 other objects\r\nDETAIL:  drop cascades to extension postgis\r\ndrop cascades to extension postgis_topology\r\ndrop cascades to extension fuzzystrmatch\r\ndrop cascades to extension postgis_tiger_geocoder\r\nCREATE EXTENSION\r\nGRANT\r\nERROR:  must be owner of extension plpgsql\r\nERROR:  must be owner of extension postgis\r\nCREATED SCHEMA\r\nLoading  schema_migrations         : ADDED 35\r\nCleaning citations                 : DEL 0\r\nLoading  citations                 : ADD 779\r\nFixing   citations                 : SEQ 3000000001\r\nCleaning counties                  : DEL 0\r\nLoading  counties                  : ADD 3399\r\nFixing   counties                  : SEQ 3000000001\r\nCleaning covariates                : DEL 0\r\nLoading  covariates                : ADD 10475\r\nFixing   covariates                : SEQ 3000000001\r\nCleaning cultivars                 : DEL 0\r\nLoading  cultivars                 : ADD 517\r\nFixing   cultivars                 : SEQ 3000000001\r\nCleaning dbfiles                   : DEL 0\r\nLoading  dbfiles                   : ADD 814\r\nFixing   dbfiles                   : SEQ 3000000001\r\nCleaning ensembles                 : DEL 0\r\nLoading  ensembles                 : ADD 2\r\nFixing   ensembles                 : SEQ 3000000001\r\nCleaning entities                  : DEL 0\r\nLoading  entities                  : ADD 516\r\nFixing   entities                  : SEQ 3000000001\r\nCleaning formats                   : DEL 0\r\nLoading  formats                   : ADD 34\r\nFixing   formats                   : SEQ 3000000001\r\nCleaning inputs                    : DEL 0\r\nLoading  inputs                    : ADD 248\r\nFixing   inputs                    : SEQ 3000000001\r\nCleaning likelihoods               : DEL 0\r\nLoading  likelihoods               : ADD 0\r\nFixing   likelihoods               : SEQ 3000000001\r\nCleaning location_yields           : DEL 0\r\nLoading  location_yields           : ADD 23081\r\nFixing   location_yields           : SEQ 3000000001\r\nCleaning machines                  : DEL 0\r\nLoading  machines                  : ADD 13\r\nFixing   machines                  : SEQ 3000000001\r\nCleaning managements               : DEL 0\r\nLoading  managements               : ADD 4011\r\nFixing   managements               : SEQ 3000000001\r\nCleaning methods                   : DEL 0\r\nLoading  methods                   : ADD 37\r\nFixing   methods                   : SEQ 3000000001\r\nCleaning mimetypes                 : DEL 0\r\nLoading  mimetypes                 : ADD 417\r\nFixing   mimetypes                 : SEQ 3000000001\r\nCleaning models                    : DEL 0\r\nLoading  models                    : ADD 5\r\nFixing   models                    : SEQ 3000000001\r\nCleaning modeltypes                : DEL 0\r\nLoading  modeltypes                : ADD 3\r\nFixing   modeltypes                : SEQ 3000000001\r\nCleaning modeltypes_formats        : DEL 0\r\nLoading  modeltypes_formats        : ADD 9\r\nFixing   modeltypes_formats        : SEQ 3000000001\r\nCleaning pfts                      : DEL 0\r\nLoading  pfts                      : ADD 84\r\nFixing   pfts                      : SEQ 3000000001\r\nCleaning posterior_samples         : DEL 0\r\nLoading  posterior_samples         : ADD 0\r\nFixing   posterior_samples         : SEQ 3000000001\r\nCleaning posteriors                : DEL 0\r\nLoading  posteriors                : ADD 4\r\nFixing   posteriors                : SEQ 3000000001\r\nCleaning priors                    : DEL 0\r\nLoading  priors                    : ADD 216\r\nFixing   priors                    : SEQ 3000000001\r\nCleaning runs                      : DEL 0\r\nLoading  runs                      : ADD 23\r\nFixing   runs                      : SEQ 3000000001\r\nCleaning sessions                  : DEL 0\r\nLoading  sessions                  : ADD 9425\r\nFixing   sessions                  : SEQ 3000000001\r\nCleaning sites                     : DEL 0\r\nLoading  sites                     : ADD 1071\r\nFixing   sites                     : SEQ 3000000001\r\nCleaning species                   : DEL 0\r\nLoading  species                   : ADD 49708\r\nFixing   species                   : SEQ 3000000001\r\nCleaning treatments                : DEL 0\r\nLoading  treatments                : ADD 2481\r\nFixing   treatments                : SEQ 3000000001\r\nCleaning variables                 : DEL 0\r\nLoading  variables                 : ADD 488\r\nFixing   variables                 : SEQ 3000000001\r\nCleaning workflows                 : DEL 0\r\nLoading  workflows                 : ADD 8\r\nFixing   workflows                 : SEQ 3000000001\r\nCleaning traits                    : DEL 0\r\nLoading  traits                    : ADD 13050\r\nFixing   traits                    : SEQ 3000000001\r\nCleaning yields                    : DEL 0\r\nLoading  yields                    : ADD 6153\r\nFixing   yields                    : SEQ 3000000001\r\nCleaning users                     : DEL 0\r\nLoading  users                     : ADD 165\r\nFixing   users                     : SEQ 3000000001\r\nCleaning citations_sites           : DEL 0\r\nLoading  citations_sites           : ADD 1247\r\nCleaning citations_treatments      : DEL 0\r\nLoading  citations_treatments      : ADD 1949\r\nCleaning formats_variables         : DEL 0\r\nLoading  formats_variables         : ADD 61\r\nCleaning inputs_runs               : DEL 0\r\nLoading  inputs_runs               : ADD 0\r\nCleaning inputs_variables          : DEL 0\r\nLoading  inputs_variables          : ADD 31\r\nCleaning managements_treatments    : DEL 0\r\nLoading  managements_treatments    : ADD 9063\r\nCleaning pfts_priors               : DEL 0\r\nLoading  pfts_priors               : ADD 1475\r\nCleaning pfts_species              : DEL 0\r\nLoading  pfts_species              : ADD 200511\r\nCleaning posteriors_ensembles      : DEL 0\r\nLoading  posteriors_ensembles      : ADD 0\r\n```"},"comment":{"url":"https://api.github.com/repos/PecanProject/pecan/issues/comments/93530690","html_url":"https://github.com/PecanProject/pecan/issues/425#issuecomment-93530690","issue_url":"https://api.github.com/repos/PecanProject/pecan/issues/425","id":93530690,"user":{"login":"mdietze","id":3081466,"avatar_url":"https://avatars.githubusercontent.com/u/3081466?v=3","gravatar_id":"","url":"https://api.github.com/users/mdietze","html_url":"https://github.com/mdietze","followers_url":"https://api.github.com/users/mdietze/followers","following_url":"https://api.github.com/users/mdietze/following{/other_user}","gists_url":"https://api.github.com/users/mdietze/gists{/gist_id}","starred_url":"https://api.github.com/users/mdietze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdietze/subscriptions","organizations_url":"https://api.github.com/users/mdietze/orgs","repos_url":"https://api.github.com/users/mdietze/repos","events_url":"https://api.github.com/users/mdietze/events{/privacy}","received_events_url":"https://api.github.com/users/mdietze/received_events","type":"User","site_admin":false},"created_at":"2015-04-15T18:52:38Z","updated_at":"2015-04-15T18:52:38Z","body":"Shawn, the dump is different from where the database is stored and from opening up remote access to the database itself -- running dump.bety.sh should create a tar.gz file that you can post anywhere for us to download (http, ftp, etc), which could potentially even include rsync'ing it to another server that's not firewalled. Both ebi-forecast and psql-pecan run the dump on a cron job (for me the same cron job is running the upload of ebi-forecast).\r\n\r\nMore generally, how will you run the web utils if the firewall's blocking http and/or https?"}}