On 7/16/2024 9:57 PM, Christophe Pettus wrote:
On Jul 16, 2024, at 21:45, imndl...@gmx.com wrote: Or, does Postgres
expect to be able to access any media however it wants (i.e., R/w),
regardless of the expected access patterns of the data stored there?
Well, yes and no.
PostgreSQL will not res
Hi,
I am new to this community.
I have one question.
Is there any planned release of postgresql 14 for Sles15SP6.
Could you please help me with this.
Regards,
Akram.
Hi ,
I am trying pgbackrest(2.52.1) with postgresql( version 16) on a lab
setup on RHEL-9. Both PostgreSQL server and a remote Repository host
configured with pgbackrest and everything working fine as specified in the
documentation.
note: here I am running postgres server and pgbackrest ever
Hi,
Your query:
1. Is it possible to use PgBackrest with EnterpriseDB(EDB -16) for the
backup and recovery process? Or pgback works only with the community
PostgreSQL database ?
Answer: Yes, you can use pgBackRest with EPAS-16 (EDB Postgres Advanced
Server); it is fully supported. You can find
On 7/17/24 03:37, Akram Hussain wrote:
Hi,
I am new to this community.
I have one question.
Is there any planned release of postgresql 14 for Sles15SP6.
Your subject says 'Support of Postgresql 15 ...' which version do you want?
Could you please help me with this.
Regards,
Akram.
--
Ad
Adrian Klaver writes:
> On 7/17/24 03:37, Akram Hussain wrote:
>> Is there any planned release of postgresql 14 for Sles15SP6.
> Your subject says 'Support of Postgresql 15 ...' which version do you want?
The answer's the same either way. The prebuilt packages the PG
community makes for SUSE ar
Thanks, I'll check it out.
Also is there any python client for the connection to pgprewarm?
Is the existing Postgresql python client will support the pgprewarm cache
usage also?
On Tue, Jul 16, 2024 at 9:01 PM Kashif Zeeshan
wrote:
> Hi Pradeep
>
> pgprewarm Extension is available for Postgres
>
I am having trouble using require_auth
(https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH).
Using golang sqlx.Connect on the client side, the connection fails and my
Postgresql 16 server logs the following:
2024-07-17 14:42:07.285 UTC [115] FATAL: unrecognized c
"Gaisford, Phillip" writes:
> Using golang sqlx.Connect on the client side, the connection fails and my
> Postgresql 16 server logs the following:
> 2024-07-17 14:42:07.285 UTC [115] FATAL: unrecognized configuration
> parameter "require_auth"
require_auth is a connection parameter, like host
On Wednesday, July 17, 2024, Gaisford, Phillip
wrote:
> I am having trouble using require_auth (https://www.postgresql.org/
> docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH).
>
>
>
> Using golang sqlx.Connect on the client side, the connection fails and my
> Postgresql 16 server logs the f
Hi
On Wed, Jul 17, 2024 at 5:21 PM KK CHN wrote:
> Hi ,
>
> I am trying pgbackrest(2.52.1) with postgresql( version 16) on a lab
> setup on RHEL-9. Both PostgreSQL server and a remote Repository host
> configured with pgbackrest and everything working fine as specified in the
> documentation
Interesting…
So what would a connection URI using require_auth properly look like? Here’s
what I have been trying:
url:
"postgres://postgres:postgres@localhost:5432/aioli?require_auth=password&application_name=aioli-controller&sslmode=disable&sslrootcert=",
From: Tom Lane
Date: Wednesday, Ju
El día miércoles, julio 17, 2024 a las 10:50:33a. m. -0400, Tom Lane escribió:
> Adrian Klaver writes:
> > On 7/17/24 03:37, Akram Hussain wrote:
> >> Is there any planned release of postgresql 14 for Sles15SP6.
>
> > Your subject says 'Support of Postgresql 15 ...' which version do you want?
>
What does "python client will support the pgprewarm cache usage" mean?
Read the pgprewarm docs.
On Wed, Jul 17, 2024 at 11:10 AM pradeep t wrote:
> Thanks, I'll check it out.
> Also is there any python client for the connection to pgprewarm?
> Is the existing Postgresql python client will suppo
> On Jul 12, 2024, at 06:18, pradeep t wrote:
> Shall I use the Postgresql database for a semantic cache like the Redis
> semantic cache?
If you mean this feature:
https://redis.io/docs/latest/integrate/redisvl/user-guide/semantic-caching/
... there is no direct equivalent in Postg
"Gaisford, Phillip" writes:
> So what would a connection URI using require_auth properly look like? Here’s
> what I have been trying:
> url:
> "postgres://postgres:postgres@localhost:5432/aioli?require_auth=password&application_name=aioli-controller&sslmode=disable&sslrootcert=",
Hm, that look
I've been noticing a growing trend of blog posts written mostly, if not
entirely, with AI (aka LLMs, ChatGPT, etc.). I'm not sure where to raise
this issue. I considered a blog post, but this mailing list seemed a better
forum to generate a discussion.
The problem is two-fold as I see it.
First,
st 17. 7. 2024 v 19:22 odesílatel Greg Sabino Mullane
napsal:
> I've been noticing a growing trend of blog posts written mostly, if not
> entirely, with AI (aka LLMs, ChatGPT, etc.). I'm not sure where to raise
> this issue. I considered a blog post, but this mailing list seemed a better
> forum
Hi Greg
I agree with you on the misuse of AI based tools, as per my experience with
Postgres the solutions suggested wont work at times.
Its not bad to get help from these tools but put all the solutions from
there is counter productive.
I think People should take care while using these tools whil
I think Tom is right.
I am using v5.6 of https://github.com/jackc/pgx
I quick read of the code reveals no awareness of require_auth, so I have filed
an issue with the project.
From: Tom Lane
Date: Wednesday, July 17, 2024 at 1:11 PM
To: Gaisford, Phillip
Cc: pgsql-general@lists.postgresql.org
On 7/17/24 10:21, Greg Sabino Mullane wrote:
I've been noticing a growing trend of blog posts written mostly, if not
entirely, with AI (aka LLMs, ChatGPT, etc.). I'm not sure where to raise
this issue. I considered a blog post, but this mailing list seemed a
better forum to generate a discussio
On Fri, 12 Jul 2024 at 02:08, Dimitrios Apostolou wrote:
> I can't help but see this as a bug. I see many issues:
>
> * postgres is not reading from partitions in parallel, but one after the
>other. It shouldn't need all this memory simultaneously.
I don't know for Hash Aggregate, but for nod
Sorry for the typo.
My intention was Postgresql version 14 on Sles15sp6.
Any help would be appreciated
Regards,
Akram.
On Wed, 17 Jul, 2024, 4:07 pm Akram Hussain, wrote:
> Hi,
>
> I am new to this community.
>
> I have one question.
>
> Is there any planned release of postgresql 14 for Sles15
On 7/17/24 15:43, Akram Hussain wrote:
Sorry for the typo.
My intention was Postgresql version 14 on Sles15sp6.
Any help would be appreciated
As Tom Lane pointed out there is this:
https://zypp.postgresql.org/howtozypp/
There is also:
https://build.opensuse.org/package/show/server:database
Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems the
two files above have disappeared. Does anyone know where I can find them?
Needed for a project to work with PostgreSQL
13.
Thanks.
On Wed, 2024-07-17 at 20:36 -0400, H wrote:
> Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems
> the two files above have disappeared. Does anyone know where I can find them?
> Needed for a project to work with PostgreSQL
> 13.
>
> Thanks.
I should have added that I sea
On 7/17/24 17:36, H wrote:
Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems the
two files above have disappeared. Does anyone know where I can find them?
Needed for a project to work with PostgreSQL
13.
Are they not in?:
https://yum.postgresql.org/13/redhat/rhel-7-
On Wed, 2024-07-17 at 17:58 -0700, Adrian Klaver wrote:
> On 7/17/24 17:36, H wrote:
> > Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems
> > the two files above have disappeared. Does anyone know where I can find
> > them? Needed for a project to work with
> > PostgreSQ
Hi
I tried to connect with psql + client sslmode = require + server requiring
ssl with PG17 and trace_connection_negotiation = "on". So "SSLRequest
accepted" is logged twice with two different PID. I believe the PID 15553
is psql and 15554 is the PG backend. How do you explain the two connections
Hao Zhang writes:
> I tried to connect with psql + client sslmode = require + server requiring
> ssl with PG17 and trace_connection_negotiation = "on". So "SSLRequest
> accepted" is logged twice with two different PID. I believe the PID 15553
> is psql and 15554 is the PG backend.
Certainly not:
Hi
Do new inserts block while performing vacuum freeze operations ?
when autovacuum runs , it will freeze the transaction ID (TXID) of the
table it's working on. This means that any transactions that started before
autovacuum began will be allowed to complete.but new transactions will be
blocked
Hi
On Thu, Jul 18, 2024 at 10:26 AM Durgamahesh Manne <
maheshpostgr...@gmail.com> wrote:
> Hi
>
> Do new inserts block while performing vacuum freeze operations ?
>
Generally, VACUUM FREEZE does not block inserts as PG uses Multi-Version
Concurrency Control (MVCC) which allows multiple transacti
On Wednesday, July 17, 2024, Durgamahesh Manne
wrote:
> when autovacuum runs , it will freeze the transaction ID (TXID) of the
> table it's working on.
>
This statement is incorrect. A table as a whole does not have a txid.
Freezing makes it so individual tuples get assigned an always-in-the-pa
On Wednesday, July 17, 2024, Durgamahesh Manne
wrote:
>
> Could you please provide more clarity on this? Which lock triggers on the
> tables are being used by freeze?
>
https://www.postgresql.org/docs/current/explicit-locking.html
Share update exclusive
David J.
34 matches
Mail list logo
