{"action":"created","issue":{"url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/568","labels_url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/568/labels{/name}","comments_url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/568/comments","events_url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/568/events","html_url":"https://github.com/puppetlabs/puppetlabs-postgresql/pull/568","id":59673513,"number":568,"title":"(MODULES-661) Add host parameter to psql commands","user":{"login":"petems","id":1064715,"avatar_url":"https://avatars.githubusercontent.com/u/1064715?v=3","gravatar_id":"","url":"https://api.github.com/users/petems","html_url":"https://github.com/petems","followers_url":"https://api.github.com/users/petems/followers","following_url":"https://api.github.com/users/petems/following{/other_user}","gists_url":"https://api.github.com/users/petems/gists{/gist_id}","starred_url":"https://api.github.com/users/petems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petems/subscriptions","organizations_url":"https://api.github.com/users/petems/orgs","repos_url":"https://api.github.com/users/petems/repos","events_url":"https://api.github.com/users/petems/events{/privacy}","received_events_url":"https://api.github.com/users/petems/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-03-03T17:14:06Z","updated_at":"2015-03-06T13:00:44Z","closed_at":"2015-03-03T22:19:39Z","pull_request":{"url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/pulls/568","html_url":"https://github.com/puppetlabs/puppetlabs-postgresql/pull/568","diff_url":"https://github.com/puppetlabs/puppetlabs-postgresql/pull/568.diff","patch_url":"https://github.com/puppetlabs/puppetlabs-postgresql/pull/568.patch"},"body":"This allows you to use `postgres_pqsl` commands to be run against a specified host. The ultimate goal being that you can use `puppetlabs-postsgresql` to run against remote instances, especially things such as Amazons RDS service.\n\nThis PR will be further extended to do things like allow remote `table_grant` and the like."},"comment":{"url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/comments/77555064","html_url":"https://github.com/puppetlabs/puppetlabs-postgresql/pull/568#issuecomment-77555064","issue_url":"https://api.github.com/repos/puppetlabs/puppetlabs-postgresql/issues/568","id":77555064,"user":{"login":"petems","id":1064715,"avatar_url":"https://avatars.githubusercontent.com/u/1064715?v=3","gravatar_id":"","url":"https://api.github.com/users/petems","html_url":"https://github.com/petems","followers_url":"https://api.github.com/users/petems/followers","following_url":"https://api.github.com/users/petems/following{/other_user}","gists_url":"https://api.github.com/users/petems/gists{/gist_id}","starred_url":"https://api.github.com/users/petems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petems/subscriptions","organizations_url":"https://api.github.com/users/petems/orgs","repos_url":"https://api.github.com/users/petems/repos","events_url":"https://api.github.com/users/petems/events{/privacy}","received_events_url":"https://api.github.com/users/petems/received_events","type":"User","site_admin":false},"created_at":"2015-03-06T13:00:44Z","updated_at":"2015-03-06T13:00:44Z","body":"@ColinHebert Yes, right now it was a very MVP implementation, I'm breaking up the larger \"Use the postgres module to fully provision a remote instance\" into smaller chunks.\r\n\r\n@tomhey's done some awesome work around adding a new `connection_options` hash using Postgres Environment variables (http://www.postgresql.org/docs/current/static/libpq-envars.html) which makes this a lot better, and is probably the best approach to properly implement it. Discussion's here if you're interested https://tickets.puppetlabs.com/browse/MODULES-661"}}