Timeline for Querying remote postgres from org
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 30, 2018 at 7:31 | comment | added | stardiviner | About TRAMP multi-hops SSH connection password, they can be stored in auth-sources, .netrc etc. | |
| May 29, 2018 at 23:03 | comment | added | iLemming | oh. it seems not related to the command... it has something to do with the number of rows. I guess by default it allows limited number of rows to be transferred. Maybe there's a way to extend that? | |
| May 29, 2018 at 22:33 | vote | accept | iLemming | ||
| May 29, 2018 at 22:33 | comment | added | iLemming |
oh, no... it actually worked, just tried this: #+begin_src sql :engine postgresql :dir /ssh:uat|ssh:sql-machine: :dbpassword "PASSWORD" :dbhost uat-green-rds-postgres.amazonaws.com :dbuser postgresql :database kafka_connect_postgresql :cmdline "-p 5432" select * from bank_transaction limit 1; #+end_src It didn't work previously because of \d command. Although it works locally, you can't expect it to work for remote DBs. Sql statements work fine.
|
|
| May 29, 2018 at 21:59 | comment | added | iLemming |
I've tried setting :dbpassword header as explained in here: orgmode.org/worg/org-contrib/babel/languages/ob-doc-sql.html, and now getting: gzip: (stdin): unexpected end of file
|
|
| May 29, 2018 at 20:53 | comment | added | iLemming | I think this should work, but it doesn't work for me, because there's one missing piece: the password. I need to find a way to set it and voila | |
| Mar 22, 2018 at 13:50 | history | answered | stardiviner | CC BY-SA 3.0 |