summaryrefslogtreecommitdiffstats
path: root/2024/talks/pgmacs.md
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--2024/talks/pgmacs.md125
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"]]