diff options
Diffstat (limited to '')
-rw-r--r-- | 2024/talks/pgmacs.md | 125 |
1 files changed, 63 insertions, 62 deletions
diff --git a/2024/talks/pgmacs.md b/2024/talks/pgmacs.md index bb0171d7..4c8f506f 100644 --- a/2024/talks/pgmacs.md +++ b/2024/talks/pgmacs.md @@ -55,13 +55,13 @@ in his spare time. connecting to the database server over the network. You can set up ssh tunnels, but that would be done separately from Tramp. Thanks :) - - \<NullNix\> you can tunnel arbitrary data over ssh - - \<NullNix\> ssh subsystems are the thing to look at, I + - you can tunnel arbitrary data over ssh + - ssh subsystems are the thing to look at, I think\... I might look at it - - \<NullNix\> (sftp works that way: basically you can put + - (sftp works that way: basically you can put arbitrary progams at the remote end\... like, oh, say, pgsql. transparently to the ssher.) - - \<jreicher\> Possibly PGmacs could setup the tunnel itself, + - Possibly PGmacs could setup the tunnel itself, using TRAMP? - With docker.el, kubel, etc, it's often possible to for example select a container/pod/whatever that is hosted on a machine @@ -94,64 +94,65 @@ in his spare time. ## Notes -- I have got 270 tables, and it stays there forever "loading" - tables, and nothing appears. -- Thanks for checking it out! You may have an authentication failure, - and PGmacs is not very good at showing that in the connect phase. - Switch to the \*Messages\* buffer and see whether there's an error - message there. - - This is happening with me as well. I noticed this error message - in Postgres Logs. It works if I open the postgres database. - - db-1 \| 2024-12-08 18:58:41.524 UTC \[48\] STATEMENT: - CREATE EXTENSION IF NOT EXISTS vector - - db-1 \| 2024-12-08 18:59:13.831 UTC \[50\] ERROR: could - not open extension control file - "/usr/share/postgresql/14/extension/vector.control": No - such file or directory - - In \*Messages\* buffer, this is what I see - - pg-bind: Wrong type argument: stringp, 97 -- OK, thanks for this feedback. It looks like your Postgres vector - extension is not well set up, but that really shouldn't be causing - a complete connection failure. You can comment out the line - (pg-vector-setup con) in function pgmacs-open in pgmacs.el and see - whether that helps - - - Let me try that and report back. - - I got this error: pg-do-startup: Process postgres not - running: failed with code 111 - - OK, that means that the network connection failed. There is - probably more error information in the backtrace - - Ah sorry, had stopped the pg. This time I got the same error - - pg-bind: Wrong type argument: stringp, 97 - - But it didn't try to load vector extensions (from pg logs). - - With toggle-debug-on-error, this is the backtrace - - [https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312](https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312) - - OK, thanks for that backtrace. I don't immediately see what - is wrong here. There is something strange about that - shared_urls table, it seems. Are you using pg-el from the - github repo? - - I created the github issue to continue the discussion: - [https://github.com/emarsden/pgmacs/issues/9](https://github.com/emarsden/pgmacs/issues/9) -- - - BTW I'm using the postgres docker image. - -- This is amazing! Image inline :o !! - -- I'm impressed by the inline images. Just sprinkle a little elisp - and voila. - -- A PostGIS point field -\> osm.el integration would be very cool -- Interesting idea, will look into that. -- \<sctb\> emarsden: Super slick Emacs/PG hacking and presentation! - Eat your heart out, MS Access -- \<NullNix\> another package I never knew I needed -- \<alzai\> Very cool, I'm currently using PG on a small project and - it's always a pain to leave emacs to do checks in the database. -- \<NullNix\> I just wish it had existed when I was doing massive db - work in the 90s/2000s -- \<gs-101\> Just installed it, to prevent me from forgetting about - it. - -\ - +- I have got 270 tables, and it stays there forever "loading" + tables, and nothing appears. +- Thanks for checking it out! You may have an authentication failure, + and PGmacs is not very good at showing that in the connect phase. + Switch to the \*Messages\* buffer and see whether there's an error + message there. + - This is happening with me as well. I noticed this error message + in Postgres Logs. It works if I open the postgres database. + - db-1 \| 2024-12-08 18:58:41.524 UTC \[48\] STATEMENT: + CREATE EXTENSION IF NOT EXISTS vector + - db-1 \| 2024-12-08 18:59:13.831 UTC \[50\] ERROR: could + not open extension control file + "/usr/share/postgresql/14/extension/vector.control": No + such file or directory + - In \*Messages\* buffer, this is what I see + - pg-bind: Wrong type argument: stringp, 97 +- OK, thanks for this feedback. It looks like your Postgres vector + extension is not well set up, but that really shouldn't be causing + a complete connection failure. You can comment out the line + (pg-vector-setup con) in function pgmacs-open in pgmacs.el and see + whether that helps + - - Let me try that and report back. + - I got this error: pg-do-startup: Process postgres not + running: failed with code 111 + - OK, that means that the network connection failed. There is + probably more error information in the backtrace + - Ah sorry, had stopped the pg. This time I got the same error + - pg-bind: Wrong type argument: stringp, 97 + - But it didn't try to load vector extensions (from pg logs). + - With toggle-debug-on-error, this is the backtrace + - [https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312](https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312) + - OK, thanks for that backtrace. I don't immediately see what + is wrong here. There is something strange about that + shared_urls table, it seems. Are you using pg-el from the + github repo? + - I created the github issue to continue the discussion: + [https://github.com/emarsden/pgmacs/issues/9](https://github.com/emarsden/pgmacs/issues/9) +- - - BTW I'm using the postgres docker image. + +- This is amazing! Image inline :o !! + +- I'm impressed by the inline images. Just sprinkle a little elisp + and voila. + +- A PostGIS point field -\> osm.el integration would be very cool +- Interesting idea, will look into that. +- Super slick Emacs/PG hacking and presentation! + Eat your heart out, MS Access +- another package I never knew I needed +- Very cool, I'm currently using PG on a small project and + it's always a pain to leave emacs to do checks in the database. +- I just wish it had existed when I was doing massive db + work in the 90s/2000s +- Just installed it, to prevent me from forgetting about + it. +- I just wish it had existed when I was doing massive db work in the 90s/2000s + - Better 20+ years late than never 😆 +- there is a grantback if you assign copyright to the FSF: you get all the rights you gave away right back again +- Thanks Eric, looks fantastic, and quite eager to look into those vtable enhancements myself (thanks for answering) [[!inline pages="internal(2024/info/pgmacs-after)" raw="yes"]] |