Our max xid are over 500m and climbing. Auto vacuuming and
manual vacuuming are returning
autovacuuming to prevent wraparound.
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
You might also need to commit or roll back old prepared transact
Hello
How can this error be resolved?
PGE-XX000: ERROR: Problem with the SSL CA cert (path? access rights?)
Is there any postgresql documentation on this ?
Kind regards
Johnathan T.
Johnathan Tiamoh writes:
> How can this error be resolved?
> PGE-XX000: ERROR: Problem with the SSL CA cert (path? access rights?)
> Is there any postgresql documentation on this ?
No, because it's not a Postgres error: there is no such message
string anywhere in our source code. You should sta
Hi Team,
I am facing some problem because of unavailability of PostgreSQL installer
greater then 10 version of PostgreSQL in my case I need postgreSQL-14.0 version
installer but unfortunately now not available.
Why we used the PostgreSQL -10 version to install the PostgreSQL with the
install
On 11/8/23 11:04, Shashikanth Bhardwaj wrote:
Hi Team,
I am facing some problem because of unavailability of PostgreSQL installer
greater then 10 version of PostgreSQL in my case I need postgreSQL-14.0
version installer but unfortunately now not available.
Which OS?
Where are you looking
Hi everyone,
When using logical replication with the pgoutput plugin, on PG 16,we do the
following:
1) SELECT * FROM pg_logical_slot_peek_binary_changes('test_slot_v1', null,
null,'publication_names', 'cdc', 'proto_version', '4', 'streaming', 'false')
2) Get LSN of last row (Commit)
3) SELE
Hello Bruce,
I do not see parameters starting with auto_explain. in configuration file
and also do I need to enable logging collector. Please guide me on this.
On Fri, 3 Nov, 2023, 11:24 pm Bruce Momjian, wrote:
> On Fri, Nov 3, 2023 at 10:44:12AM -0700, Adrian Klaver wrote:
> >
> > On 11/3/23
On 11/8/23 09:04, Shashikanth Bhardwaj wrote:
Hi Team,
I am facing some problem because of unavailability of PostgreSQL
installer greater then 10 version of PostgreSQL in my case I need
postgreSQL-14.0 version installer but unfortunately now not available.
Why we used the PostgreSQL -10 ver
On Wed, 2023-11-08 at 09:09 -0500, Craig Milhiser wrote:
> Our max xid are over 500m and climbing. Auto vacuuming and manual vacuuming
> are returning
>
> autovacuuming to prevent wraparound.
> WARNING: oldest xmin is far in the past
> HINT: Close open transactions soon to avoid wraparound prob
I found this in a blog
(https://buttondown.email/jaffray/archive/sql-scoping-is-surprisingly-subtle-and-semantic/):
CREATE TABLE aa (a INT);
INSERT INTO aa VALUES (1), (2), (3);
CREATE TABLE xx (x INT);
INSERT INTO xx VALUES (10), (20), (30);
SELECT (SELECT sum(a) FROM xx LIMIT 1) FROM
Laurenz Albe writes:
> I found this in a blog
> (https://buttondown.email/jaffray/archive/sql-scoping-is-surprisingly-subtle-and-semantic/):
> CREATE TABLE aa (a INT);
> INSERT INTO aa VALUES (1), (2), (3);
> CREATE TABLE xx (x INT);
> INSERT INTO xx VALUES (10), (20), (30);
> SELECT (
Finally, we used the Windows tool Gflags.exe and found that other software
terminated the postgres process.
Replied Message
| From | yangsr3411 |
| Date | 10/30/2023 19:07 |
| To | pgsql-general |
| Cc | |
| Subject | Fw: Server process exited with exit code 4 |
it doesn't seem like a
Hi everyone,
Does anyone here know if the default PostgreSQL images set NUMA policies?
I am assuming not? Is there an easy way to make them do this?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Wed, 2023-11-08 at 16:36 -0500, Tom Lane wrote:
> Laurenz Albe writes:
> > I found this in a blog
> > (https://buttondown.email/jaffray/archive/sql-scoping-is-surprisingly-subtle-and-semantic/):
> > CREATE TABLE aa (a INT);
> > INSERT INTO aa VALUES (1), (2), (3);
> > CREATE TABLE xx (x
14 matches
Mail list logo
