On 4/19/22 00:06, David G. Johnston wrote:
On Monday, April 18, 2022, bhargav kamineni wrote:
Hi Team,
It seems vacuum is behaving somewhat weird on postgres database ,
observing below HINTS on the vacuum logs
WARNING: oldest xmin is far in the past
HINT: Close open t
Other details:
postgres=> select version();
version
-
PostgreSQL 13.5 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-
On Monday, April 18, 2022, bhargav kamineni wrote:
> Hi Team,
>
> It seems vacuum is behaving somewhat weird on postgres database ,
> observing below HINTS on the vacuum logs
>
> WARNING: oldest xmin is far in the past
>
> HINT: Close open transactions soon to avoid wraparound problems.
>
> You
Hi Team,
It seems vacuum is behaving somewhat weird on postgres database , observing
below HINTS on the vacuum logs
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 transactions, or
Dear Adrian,
If we set parameter "PG-WAL = replica" in PG13 conf file , there is any
issue in replication through PG_WAL and pg_log_archive log.
https://www.postgresql.org/docs/13/runtime-config-wal.html
Regards,
Ram Pratap.
-Original Message-
From: Ram Pratap Maurya
"Pete O'Such" writes:
> Yup, FIPS-mode is on for both ends. I'd love a pointer to docs or other
> resources for figuring out what the path forward looks like.
You could switch to SCRAM passwords, if you don't need to support any
clients using pre-v10 libpq.
regards, tom l
Yup, FIPS-mode is on for both ends. I'd love a pointer to docs or other
resources for figuring out what the path forward looks like.
Thanks for the fast and insightful diagnostic tip..
-Pete O'Such
On Mon, Apr 18, 2022 at 5:08 PM Tom Lane wrote:
> Adrian Klaver writes:
> > On 4/18/22 13:12,
Dear Adrian,
We have two replica system one is Slave and other id DR server .
Salve server replicate from PG_WAL and DR system replicate from
pg_log_archive.
Can you please suggest what changes need to required in PG13 conf file.
Regards,
Ram Pratap.
-Original Message-
From: Adrian
Hi Stephen, and thanks! Please see below...
> Greetings,
> * Jerry Sievers (gsiever...@comcast.net) wrote:
> Suppose we have a DB cluster with an additional tablespace and we are
> able to make an atomic SAN snapshot of *only* the main cluster
> volume...
> The additional tablespace contains on
Adrian Klaver writes:
> On 4/18/22 13:12, Pete O'Such wrote:
>> I'm unable to authenticate with psql to a PG 11 database on server A
>> from server B which has PG 14.1 installed. So it's psql 14.1 not
>> authenticating to PG 11. Other clients can and do authenticate to the
>> PG 11 database,
On 4/18/22 13:12, Pete O'Such wrote:
I'm unable to authenticate with psql to a PG 11 database on server A
from server B which has PG 14.1 installed. So it's psql 14.1 not
authenticating to PG 11. Other clients can and do authenticate to the
PG 11 database, it only seems to fail with the psql
I'm unable to authenticate with psql to a PG 11 database on server A from
server B which has PG 14.1 installed. So it's psql 14.1 not authenticating
to PG 11. Other clients can and do authenticate to the PG 11 database, it
only seems to fail with the psql 14.1 client.
The PG 11 server uses md5.
> On 18 Apr 2022, at 14:51, Pól Ua Laoínecháin wrote:
>
> Hi Alban, and many thanks for your input.
>
>> My first question is why you’re using a recursive CTE here? This doesn’t
>> appear to be hierarchical data (such as a tree), unless perhaps you intended
>> to actually traverse the HTML d
Greetings,
* Jerry Sievers (gsiever...@comcast.net) wrote:
> Suppose we have a DB cluster with an additional tablespace and we are
> able to make an atomic SAN snapshot of *only* the main cluster
> volume...
>
> The additional tablespace contains only UNLOGGED relations.
>
> We cannot snap that
Hi Adrian,
Command \l gives the list of db available DBs in the cluster including
template0 and template1, I can connect to other DBs and run queries as
well.
My motive is just to upgrade pgsql from 9.6 to 13 using the pg_upgrade
command.
Regards,
Ajay
On Mon, Apr 18, 2022 at 9:48 AM Adrian Kla
Thanks Adrian,
1. What if we re-create template0 and template1?
2. how to restore them if we have a folder backup of the data directory?
Regards,
Ajay
On Sun, Apr 17, 2022 at 9:29 PM Adrian Klaver
wrote:
> On 4/16/22 22:30, Ajay Kajla wrote:
> > Hello All,
> >
> >
> > I'm facing the followin
On 4/17/22 22:54, Ajay Kajla wrote:
Hi Adrian,
Command \l gives the list of db available DBs in the cluster including
template0 and template1, I can connect to other DBs and run queries as
well.
My motive is just to upgrade pgsql from 9.6 to 13 using the pg_upgrade
command.
Do you have fi
On 4/18/22 04:34, Ram Pratap Maurya wrote:
Hi Support,
We have upgraded postgresql DB from version 11 to 13 . after upgrade to
13 huge archive log generate in system .
Before upgrade per day 120GB to 150 GB log generated but after upgrade
per day approx. 250 to 300 GB log generated.
Whe
On 16/4/22 6:39 π.μ., Michael Paquier wrote:
On Thu, Apr 14, 2022 at 06:19:44PM +0300, Achilleas Mantzios wrote:
What issue/bug tracking is PostgreSQL itself using?
What continuous build system (CI/CD) is PostgreSQL itself using?
Any tool that you ppl or the PostgreSQL infrastructure use that
li
Hi Alban, and many thanks for your input.
> My first question is why you’re using a recursive CTE here? This doesn’t
> appear to be hierarchical data (such as a tree), unless perhaps you intended
> to actually traverse the HTML document hierarchy?
This is basically an exercise on my part.
The
On 17/4/22 19:28, cecile rougnaux wrote:
I upgraded my system to Catalina 10.15.7 and now I get an error with
dyld : image not found when trying to install postgresql :
[...]
dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.70.dylib
Referenced from: /usr/local/Cellar/postgresql/
On 4/18/22 07:34, Ram Pratap Maurya wrote:
Hi Support,
We have upgraded postgresql DB from version 11 to 13 . after upgrade
to 13 huge archive log generate in system .
Before upgrade per day 120GB to 150 GB log generated but after
upgrade per day approx. 250 to 300 GB log generated.
Ca
Hi Support,
We have upgraded postgresql DB from version 11 to 13 . after upgrade to 13
huge archive log generate in system .
Before upgrade per day 120GB to 150 GB log generated but after upgrade per day
approx. 250 to 300 GB log generated.
Can you please suggest why huge archive log generate
> On 18 Apr 2022, at 11:56, Pól Ua Laoínecháin wrote:
(…)
> All of the code below is available on the fiddle here:
>
> https://dbfiddle.uk/?rdbms=postgres_13&fiddle=0cc20c9081867131260e6e3550bd08ab
(…)
> OK, grand, now I wish to perform a RECURSIVE CTE on it. So, I start by
> trying someth
Hi all,
We use PostgreSQL as. our primary data persistence layer and are looking
for a tool to document the database as well as capture additional info.
Looking for suggestions.
The tool should be able to scan the database (PostgreSQL) and generate a
list of entities and attributes and persist thi
Hi all,
I've been working on a recursive query (I've already written a few, so
I'm not a complete newbie..
All of the code below is available on the fiddle here:
https://dbfiddle.uk/?rdbms=postgres_13&fiddle=0cc20c9081867131260e6e3550bd08ab
I have a table called line
SELECT
idx, length, s
26 matches
Mail list logo
