Re: Empty query_id in pg_stat_activity

2024-12-12 Thread Erik Wienhold
On 2024-12-10 14:33 +0100, Costa Alexoglou wrote:
> On Fri, Dec 6, 2024 at 4:44 PM Erik Wienhold  wrote:
> > What's your Postgres version?
>  It was `16.1`, run with `16.6` and indeed the query_id is there.

Thanks!

Please reply to list as well.  CC'ed it now.

-- 
Erik




Re: Errors when restoring backup created by pg_dumpall

2024-12-12 Thread PopeRigby

On 12/10/24 21:22, Adrian Klaver wrote:

On 12/10/24 19:05, PopeRigby wrote:

On 12/9/24 16:31, Adrian Klaver wrote:

On 12/9/24 15:30, PopeRigby wrote:

On 12/9/24 15:23, Tom Lane wrote:

Adrian Klaver  writes:

You could file an issue here:
https://www.postgresql.org/account/login/?next=/account/submitbug/
Ask if the developers could use the mechanisms available here:
https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION 


This wouldn't really move the needle, since (a) there is not some
magic group of people that will become involved who aren't already
and (b) the requested fix seems exactly the same as the work
already in progress at [1].

What would help is to figure out why the proposed patch didn't
seem to work for you.  I continue to suspect that you didn't
really install the updated extension, but it's unclear.

    regards, tom lane

[1] 
https://www.postgresql.org/message-id/flat/3395418.1618352...@sss.pgh.pa.us


I compiled and installed PostgreSQL with the patch, and restarted 
it, so unless there are other steps I'm not sure what I could have 
done wrong.





What was the source of the patch?

This: 
https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch




If I am following correctly I believe you need this one:

https://www.postgresql.org/message-id/attachment/166859/v2-0002-Use-new-style-SQL-function-in-earthdistance-exten.patch 



It has the changes that include the schema qualifications. The one you 
used does not have those modifications.



Beautiful. How can I follow this so I know when it gets upstream?