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.
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
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
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
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
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
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
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 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
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 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
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 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
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
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
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
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
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,
"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
> 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
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
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?
>
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
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
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
"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
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
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
>
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
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
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
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,
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.
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
34 matches
Mail list logo
