Thank you for your response.
2024년 11월 21일 (목) 오후 3:54, Adrian Klaver 님이 작성:
> On 11/20/24 22:44, 김주연 wrote:
> > Hello, I am currently using PostgreSQL 11.10 and would like to know if
> > the CVE-2024-10979 vulnerability affects this version.
>
> Postgres 11 is past EOL, see:
>
> https://www.post
On 11/20/24 22:44, 김주연 wrote:
Hello, I am currently using PostgreSQL 11.10 and would like to know if
the CVE-2024-10979 vulnerability affects this version.
Postgres 11 is past EOL, see:
https://www.postgresql.org/support/versioning/
If it does impact my version, I would like to know which ve
Hello, I am currently using PostgreSQL 11.10 and would like to know if the
CVE-2024-10979 vulnerability affects this version.
If it does impact my version, I would like to know which version I should
upgrade to.
On 11/19/24 08:11, Paul Foerster wrote:
Hi,
the PostgreSQL 15.9 release notes instruct to look out for especially detached
partitions with foreign key constraints. I'm in the process of updating our
databases from 15.8 to 15.9 now and found a case where the select statement
returns a constrai
i dont get why you think all memroy will be used.
When you say
shared_buffers = 16GB
effective_cache_size = 48GB
...then this is using only 16GB for shared buffers.
The effective _cache_size doesn't cause any memory to.be allocated. It's
just a hint to optomizer
On Wed, 20 Nov 2024, 11:16
On 2024-11-19 16:47:40 -0500, Catherine Frock wrote:
> I am trying to restore a previously backed up database .sql file that was
> created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was
> using).
>
> In response to Ron: Do I need to use PG16 instead of pgAdmin4?
As Ron already
On 11/19/24 00:40, 張宸瑋 wrote:
Sorry for the inconvenience, but I used make and make install to build
the credcheck--2.8.0.sql sources zip file. I would like to ask how I can
update and apply the changes to the system, as I modified the files in
credcheck/test/expected/06_reuse_interval.out and
On Wed, Nov 20, 2024 at 7:57 PM Tom Lane wrote:
> but I wonder if you could be failing to close out the SELECT statement before
> issuing ALTER.
Thanks! This led me to check some debug details, and in fact we don't
close the portal, only the statement. (Besides a bug in the debug
log...)
Now I
Istvan Soos writes:
> The following minimal reproduction case can be used locally:
> Setup:
> CREATE TABLE a (
> a_id INTEGER PRIMARY KEY NOT NULL,
> a_other_id INTEGER NOT NULL
> );
> CREATE TABLE b (other_id INTEGER PRIMARY KEY NOT NULL);
> BEGIN;
> SELECT * FROM a;
> ALTER TABLE a ADD CON
Reply to list also
Ccing list
On 11/20/24 9:36 AM, Violetta wrote:
What exactly did you delete, the entire package or just pgAdmin4?
I deleted the entire package.
How did you delete/uninstall it?
I deleted everything that was in the automatically created folder
I don't use Mac OS
Hi,
I'm developing the Dart client for Postgresql, which is using the
extended query protocol by default. I have received a report which
shows a difference in locking behavior inside a transaction, depending
which protocol we are using.
My main question: is this something that is implemented in a
On Wed, Nov 20, 2024 at 9:09 AM Sreejith P wrote:
>
>
>
> Queries were taking 20 ms started taking 60 seconds. So have done SQL
> analyse to understand about query plan. There we found that query planner
> taking seq scan instead in index scan.
>
> I would like to add one ore point. A delete que
On 11/20/24 05:26, Thomas Schweikle wrote:
Am Mo., 18.Nov..2024 um 19:43:36 schrieb Laurenz Albe:
On Mon, 2024-11-18 at 17:22 +, Thomas Schweikle wrote:
Had installed PostgreSQL 16.5 on Windows 10:
How exactly is the Windows service defined?
Perhaps you need to use an absolute path for t
On 11/20/24 06:26, Levente Birta wrote:
Hi
I'm trying to update postgresql 14.13->14.14, but there is a libllvm
18.1 dependency.
I have enabled the pgdg-centos8-sysupdates repo, but as I see there is
no llvm 18, only 16/17.
Is something that I miss?
See:
https://yum.postgresql.org/news/roc
On Tue, Nov 19, 2024 at 8:48 AM Ron Johnson wrote:
> It's trivial to specify columns when a table-returning function is the
> FROM clause, but how does one specify columns when the table-returning
> function is a column in a SELECT clause?
>
You don't/cannot. And with lateral you shouldn't find
On 11/20/24 00:54, Subhash Udata wrote:
Dear PostgreSQL Community,
I have a query related to the recent security vulnerability,
*CVE-2024-10979*, concerning the PL/Perl extension.
From the advisory, it appears the vulnerability impacts systems
utilizing the PL/Perl extension. My question is
On 11/19/24 11:57, Violetta wrote:
Hi, I got an error, opening pgAdmin, after installation from EDB host.
Please take a look at it. This is how I got it incrementally:
1. First time I downloaded postgreSQL v17.0 from the site
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Adrian: Yes, db_2017 is the name I originally gave the database in the
PostgreSQL 9.6 server. I can't remember if I used pg_dump or pg_dumpall.
Ron: Okay, I think it finally worked!
Thank you both for your help.
--
Arden
On Tue, Nov 19, 2024 at 6:00 PM Adrian Klaver
wrote:
> On 11/19/24 14:1
Hi
I'm trying to update postgresql 14.13->14.14, but there is a libllvm
18.1 dependency.
I have enabled the pgdg-centos8-sysupdates repo, but as I see there is
no llvm 18, only 16/17.
Is something that I miss?
All this on rocky linux 8, up to date.
Thanks
Levi
Assuming a machine with:
* 16 CPU cores
* 64GB RAM
Set to 500 max connections
A tool like this: https://pgtune.leopard.in.ua/
Will output recommended settings:
max_connections = 500
shared_buffers = 16GB
effective_cache_size = 48GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
> On 20 Nov 2024, at 6:32 PM, Daniel Gustafsson wrote:
>
>> On 20 Nov 2024, at 11:50, Sreejith P wrote:
>
>> We are using PostgresQL 10 in our production database. We have around 890
>> req /s request on peak time.
>
> PostgreSQL 10 is well out of support and does not receive bugfixes or
Docker databases do not perform well under heavy load.
Everything can be configured to improve performance but going through the
Docker disk access layer will significantly decrease performance.
On Wednesday, November 20, 2024 at 06:06:36 AM GMT-5, Koen De Groote
wrote:
That explains a lot.
Am Mo., 18.Nov..2024 um 19:43:36 schrieb Laurenz Albe:
> On Mon, 2024-11-18 at 17:22 +, Thomas Schweikle wrote:
>> Had installed PostgreSQL 16.5 on Windows 10:
>>
>> Install directory: "C:\PRGS\pgSQL\16"
>> DB-Directory: "C:\DB\pgSQL\16\data"
>>
>> Environment variable "PGDATA" is set to "
Make sure to run analyze on the entire database, possibly using vacuumdb would
be faster.
Also, check for invalid indexes.
Efrain J. Berdecia
On Wednesday, November 20, 2024 at 08:02:36 AM EST, Daniel Gustafsson
wrote:
> On 20 Nov 2024, at 11:50, Sreejith P wrote:
> We are using Pos
> On 20 Nov 2024, at 11:50, Sreejith P wrote:
> We are using PostgresQL 10 in our production database. We have around 890
> req /s request on peak time.
PostgreSQL 10 is well out of support and does not receive bugfixes or security
fixes, you should plan a migration to a supported version soon
On 11/20/24 12:50, Sreejith P wrote:
Hi,
We are using PostgresQL 10 in our production database. We have around
890 req /s request on peak time.
We have 1 primary and 4 slave databases as well in the same postgres
cluster.
2 days back we applied some patches in the primary server and
rest
That explains a lot.
I have the default of 2 max_parallel_maintenance_workers set, should I set
this to 0?
I realize this is of course an improvement, but working with docker
containers, I'd like to avoid taking /dev/shm away from regular queries.
I assume setting max_parallel_maintenance_worker
Hi,
We are using PostgresQL 10 in our production database. We have around 890
req /s request on peak time.
We have 1 primary and 4 slave databases as well in the same postgres
cluster.
2 days back we applied some patches in the primary server and restarted. We
didn't do anything on the secondar
Am Mo., 18.Nov..2024 um 18:48:56 schrieb Adrian Klaver:
> On 11/18/24 09:22, Thomas Schweikle wrote:
>> Hi!
>>
>> Had installed PostgreSQL 16.5 on Windows 10:
>
> Using what installer?
postgresql-16.5-1-windows-x64.exe as found on
https://www.enterprisedb.com/downloads/postgres-postgresql-downlo
PLEASE DEAR FRIEND SEND BIGGER MESSAGES! WE DON'T MIND!
On 19/11/2024 20:57, Violetta wrote:
Hi, I got an error, opening pgAdmin, after installation from EDB host.
Please take a look at it. This is how I got it incrementally:
1. First time I downloaded postgreSQL v17.0 from the site
https://www.
On Fri, Nov 15, 2024 at 4:38 PM Philip Couling wrote:
>
> Is there a solid reason why adding a check constraint does not use existing
> indexes for validation.
>
can you give an sql example (except not-null)
where indexes can be used for check constraint validation?
i am not sure I understand it
Dear PostgreSQL Community,
I have a query related to the recent security vulnerability,
*CVE-2024-10979*, concerning the PL/Perl extension.
>From the advisory, it appears the vulnerability impacts systems utilizing
the PL/Perl extension. My question is:
- If we do not use the PL/Perl extensio
Thanks for the suggestion of directly updating the system catalog, that may
be the “best” option.
“*Most likely your query is not exactly the same as the check constraint.
Think about NULL and similar.*”
No that’s not sufficient to explain it. The SELECT is obviously the
negation of the check con
33 matches
Mail list logo
