how to install plprofiler

Hello, I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below error could not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32 Could you please l

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On Fri, Oct 28, 2022 at 5:26 PM Bryn Llewellyn wrote: > > And I simply decided to follow its spirit with "bob" mapping to "alice", > thus: > > *# MAPNAME SYSTEM-USERNAME PG-USERNAME* > > > *...bllewellbob alice* > Here's my "pg_hba.conf": > > > *...* > >

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> > > > *sudo systemctl stop postgresql**sudo * > *systemctl start postgresql**pg_ctl reload -D /etc/postgresql/11/main/* > > (I know that I could've used "systemctl restart ".) Like I said elsewhere, > the "reload" seems to be superfluous. But it costs nothing to do it. > > Actually, you only n

"peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

Adrian, thank you for your reply to my « Seeking the correct term of art for the (unique) role that is usually called "postgres"... » thread here: https://www.postgresql.org/message-id/e75abfa8-72af-701c-cf6f-5336a1a35...@aklaver.com

Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12

On 2022-10-28 17:23:02 +0300, Kristjan Mustkivi wrote: > By the way, index rebuild while completing successfully did not fix > the indexes - the data in the tables was still missing even after the > successful rebuild command. This is surprising. As I understand it, REINDEX scans the complete tabl

Re: ERROR: could not find pathkey item to sort

On Fri, Oct 28, 2022 at 7:15 PM Tom Lane wrote: > > > I think it's most likely a bug in parquet_fdw. We have tests of similar > cases in postgres_fdw, and they work fine. Thanks Tom. I'll lookup the net to see how similar errors were solved in the past to understand what was being sent to postg

Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12

On Fri, Oct 28, 2022 at 2:41 AM Peter J. Holzer wrote: > > > Up until 11.17, the source of the docker images was tag "postgres:11" > > (from https://hub.docker.com/_/postgres), for 11.17 the tag became > > "postgres:11-bullseye" but as far as i could tell it was just a > > difference of tagging po

Re: ERROR: could not find pathkey item to sort

Vijaykumar Sampat Jain writes: > I came across this error/crash when using partitioning of a table with > foreign tables (parquet_fdw) as partitions. > It might be an issue with parquet_fdw nothing with postgresql, but I am not > able to figure out why it crashes around the sorted option set. I t

ERROR: could not find pathkey item to sort

Hello, ref: https://github.com/adjust/parquet_fdw#basic-usage and https://github.com/adjust/parquet_fdw/issues/58 I came across this error/crash when using partitioning of a table with foreign tables (parquet_fdw) as partitions. It might be an issue with parquet_fdw nothing with postgresql, but I