Help with "Create Extension unaccent"

2024-01-13 Thread Lan Xu
With CREATE EXTENSION unaccent, I’m getting the following: ERROR: extension "unaccent" has no installation script nor update path for version “1.0" But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql Thank you for your help! Lan

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread David Ventimiglia
I'm asking a question about technology. It has an answer. Whatever that answer is, it's independent of anyone's purpose. On Sat, Jan 13, 2024, 4:53 PM Ron Johnson wrote: > *No,* that's a technology problem. What is the purpose of storing them > back in the database using psql? > > On Sat, Jan

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread David Ventimiglia
It satisfies business constraints. On Sat, Jan 13, 2024, 5:01 PM Karsten Hilbert wrote: > Am Sat, Jan 13, 2024 at 05:53:14PM -0500 schrieb Ron Johnson: > > > *No,* that's a technology problem. What is the purpose of storing them > > back in the database using psql? > > Or even the end goal to

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread Karsten Hilbert
Am Sat, Jan 13, 2024 at 05:53:14PM -0500 schrieb Ron Johnson: > *No,* that's a technology problem. What is the purpose of storing them > back in the database using psql? Or even the end goal to be achieved by that ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread Ron Johnson
*No,* that's a technology problem. What is the purpose of storing them back in the database using psql? On Sat, Jan 13, 2024 at 4:34 PM David Ventimiglia < davidaventimig...@hasura.io> wrote: > The business problem I'm trying to solve is: > > "How do I capture logical decoding events with the

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread David Ventimiglia
The business problem I'm trying to solve is: "How do I capture logical decoding events with the wal2json output encoder, filter them with jq, and pipe them to psql, using pg_recvlogical?" On Sat, Jan 13, 2024, 1:04 PM Ron Johnson wrote: > I think this might be an A-B problem. Tell us the

Re: multiple missing providers from pgdg-common

2024-01-13 Thread Joseph G
> > sudo rpm -qp > https://dl.fedoraproject.org/pub/epel/8/Everything/x86_64/Packages/a/armadillo-12.6.6-1.el8.x86_64.rpm > --provides > armadillo = 12.6.6-1.el8 > armadillo(x86-64) = 12.6.6-1.el8 > libarmadillo.so.12()(64bit) sudo rpm -qp >

Re: multiple missing providers from pgdg-common

2024-01-13 Thread Joseph G
the is the RPM that I'm trying to install, here is the output for the requirements: sudo rpm -qp takserver-*.noarch.rpm --requires > warning: takserver-5.0-RELEASE31.noarch.rpm: Header V4 RSA/SHA512 > Signature, key ID 6851f5b5: NOKEY > rpmlib(VersionedDependencies) <= 3.0.3-1 >

Re: multiple missing providers from pgdg-common

2024-01-13 Thread Devrim Gündüz
What's that ? On 13 January 2024 20:26:19 CET, Joseph G wrote: >> >> Problem: package from @commandline requires postgis33_15, but none of >> the providers can be installed >> - package postgis33_15-3.3.1-1.rhel8.x86_64 from pgdg15 requires >> gdal35-libs >= 3.5.2, but none of the

multiple missing providers from pgdg-common

2024-01-13 Thread Joseph G
> > Problem: package from @commandline requires postgis33_15, but none of > the providers can be installed > - package postgis33_15-3.3.1-1.rhel8.x86_64 from pgdg15 requires > gdal35-libs >= 3.5.2, but none of the providers can be installed > - package postgis33_15-3.3.1-1.rhel8.x86_64

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread Ron Johnson
I think this might be an A-B problem. Tell us the "business problem" you are trying to solve, not the problem you're having with your solution to the "business problem". (If you've already mentioned it, please restate it.) On Sat, Jan 13, 2024 at 11:49 AM David Ventimiglia <

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread Adrian Klaver
On 1/13/24 08:48, David Ventimiglia wrote: Thanks.  I'm aware of all of those other alternatives, but the thing is, I'm not trying to answer this broader question: /"What are some options for capturing change events in PostgreSQL?"/ / / Rather, I'm trying to answer a narrower question: /"How

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread David Ventimiglia
Thanks. I'm aware of all of those other alternatives, but the thing is, I'm not trying to answer this broader question: *"What are some options for capturing change events in PostgreSQL?"* Rather, I'm trying to answer a narrower question: *"How does one capture output from pg_recvlogical and

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

2024-01-13 Thread Adrian Klaver
On 1/12/24 21:23, David Ventimiglia wrote: Let me just lay my cards on the table.  What I'm really trying to do is capture change events with logical decoding and then send them back into the database into a database table.  To do that, I believe I need to process the event records into SQL