RE: oldest WAL files not removed

Hy Kyotaro, Thanks for this explanation. I joined the files to be complete. Have a good day, Olivier 30/08/2021 20:4016 777 216 0001008E0088 30/08/2021 20:5816 777 216 0001008E0089 30/08/2021 21:0916 777 216 0001008E008A 30/08/2021

calling store procedure / insert statement never complete

Hi Mladen, I missed previous emails, so I am creating a new one. I think the problem is coming from front-end side. when I run store procedure, job in pg_locks is done, data is inserted, log table shows that job completed with number of insert. However, store procedure in front-end side is still

Re: oldest WAL files not removed

At Wed, 1 Sep 2021 12:48:51 +0200, wrote in > Hi, > > > > Looking at WAL folder after a crash, I noticed that new files after > restarting overwrite the more recent files before the crash and not the > oldest, which was what I expected. > > Is that normal ? I got only one file marked .dele

Re: datfrozenxid not dropping after vacuum

Hi Alvaro, thanks for the quick reply. I'm scheduled to do my patching maintenance at the end of this month - but at this point I don't think I'm going to make it. Other than patching, is there a work around? For example, in #2 above: >The fix for 2) is simpler, >simply always remove both th

Re: datfrozenxid not dropping after vacuum

On 2021-Sep-01, Matthew Tice wrote: [ problem table is pg_database ] > My primary, read/write database is Postgresql 10.4 (CentOS 7) while my > standby databases have been patched to 10.17. Hmm, I think there was a bug in the early 10.x versions where advancing the xid age of shared tables would

datfrozenxid not dropping after vacuum

Hi, Starting this morning at 0830 local time I noticed that my datfrozenxid starts moving past the `autovacuum_freeze_max_age` value of 2. When we encountered this in the past the solution has been to do one of the following: 1. This is related an error similar to ``` found xmin 2675436

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

After running: REINDEX TABLE pg_catalog.pg_attribute ; Le mer. 1 sept. 2021 à 17:54, FOUTE K. Jaurès a écrit : > Hello Tom, > > Thank You for your Answer. It solves the problem. > Thank you very much for your support. > > Le mer. 1 sept. 2021 à 16:46, Tom Lane a écrit : > >> =?UTF-8?Q?FOUTE_K=2

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

Hello Tom, Thank You for your Answer. It solves the problem. Thank you very much for your support. Le mer. 1 sept. 2021 à 16:46, Tom Lane a écrit : > =?UTF-8?Q?FOUTE_K=2E_Jaur=C3=A8s?= writes: > > For all table except the pg_catalo table. > > The dump on the database is not possible too. (pg_d

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

=?UTF-8?Q?FOUTE_K=2E_Jaur=C3=A8s?= writes: > For all table except the pg_catalo table. > The dump on the database is not possible too. (pg_dump: error: invalid > column numbering in table "xx") It seems that pg_attribute is messed up. If you are really lucky, it might be only a problem in pg

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

On Wed, Sep 1, 2021 at 8:29 AM FOUTE K. Jaurès wrote: > I already restart the server (x3) > > Ok. During server startup (or shutdown for that matter) are there any warnings or errors in the log file? Is there anything in the server logs from around the time this started to occur? You haven't c

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

For all table except the pg_catalo table. The dump on the database is not possible too. (pg_dump: error: invalid column numbering in table "xx") Le mer. 1 sept. 2021 à 16:27, Adrian Klaver a écrit : > On 9/1/21 8:08 AM, FOUTE K. Jaurès wrote: > > Hello, > > > > I have a strange issue in a pr

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

I already restart the server (x3) Le mer. 1 sept. 2021 à 16:25, David G. Johnston a écrit : > On Wed, Sep 1, 2021 at 8:08 AM FOUTE K. Jaurès > wrote: > >> Any idea how to solve this issue is really appreciated >> > > Have you restarted the server? > > In pg_attribute for one of the problema

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

On 9/1/21 8:08 AM, FOUTE K. Jaurès wrote: Hello, I have a strange issue in a production database on a customer and need to help to know how to solve the problem. Any select on the table other than pg_catalog table throws the error FATAL: catalog is missing 1 attribute(s) for To be clear t

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

On Wed, Sep 1, 2021 at 8:08 AM FOUTE K. Jaurès wrote: > Any idea how to solve this issue is really appreciated > Have you restarted the server? In pg_attribute for one of the problematic tables are all of the columns present that should be (i.e., is this a catalog contents error or, say, a

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

> On Sep 1, 2021, at 8:14 AM, FOUTE K. Jaurès wrote: > > No, I am using PostgreSQL 12 (Server and Client) > > Le mer. 1 sept. 2021 à 16:12, Rob Sargent > a écrit : > > >> On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès > > wrote: >> >

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

No, I am using PostgreSQL 12 (Server and Client) Le mer. 1 sept. 2021 à 16:12, Rob Sargent a écrit : > > > On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès wrote: > > Hello, > > I have a strange issue in a production database on a customer and need to > help to know how to solve the problem. > > Any

Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

> On Sep 1, 2021, at 8:08 AM, FOUTE K. Jaurès wrote: > > Hello, > > I have a strange issue in a production database on a customer and need to > help to know how to solve the problem. > > Any select on the table other than pg_catalog table throws the error FATAL: > catalog is missing 1 attr

Re:

Hi, On Wed, Sep 1, 2021 at 9:37 AM obi reddy wrote: > > Windows version:10 > Postgresql version:13. > > On Wed, 1 Sep 2021, 6:47 pm Igor Korot, wrote: >> >> Hi, >> >> On Wed, Sep 1, 2021 at 7:57 AM obi reddy wrote: >> > >> > 1.How to set replication in windows machine. Did you see this: https:

PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent

Hello, I have a strange issue in a production database on a customer and need to help to know how to solve the problem. Any select on the table other than pg_catalog table throws the error FATAL: catalog is missing 1 attribute(s) for Any idea how to solve this issue is really appreciated

Re:

Windows version:10 Postgresql version:13. On Wed, 1 Sep 2021, 6:47 pm Igor Korot, wrote: > Hi, > > On Wed, Sep 1, 2021 at 7:57 AM obi reddy wrote: > > > > 1.How to set replication in windows machine. > > 2. How to take incremental backup in windows machine. > > What Windows version do you use?

Re:

Hi, On Wed, Sep 1, 2021 at 7:57 AM obi reddy wrote: > > 1.How to set replication in windows machine. > 2. How to take incremental backup in windows machine. What Windows version do you use? What PostgreSQL version? Thank you. > > Thank you &Regards > Obireddy.G > > On Wed, 1 Sep 2021, 6:21 pm

Re:

1.How to set replication in windows machine. 2. How to take incremental backup in windows machine. Thank you &Regards Obireddy.G On Wed, 1 Sep 2021, 6:21 pm Igor Korot, wrote: > Hi, > > > > On Wed, Sep 1, 2021, 07:32 obi reddy wrote: > >> Hi everyone >> >> is there any one working on PostgreSQ

Re:

Hi, On Wed, Sep 1, 2021, 07:32 obi reddy wrote: > Hi everyone > > is there any one working on PostgreSQL windows machine. > You mean server installed on Windows? Or client? If the client - which one? And what is your question? Thank you. > Thank you & Regards > Obireddy.G >

[no subject]

Hi everyone is there any one working on PostgreSQL windows machine. Thank you & Regards Obireddy.G

Re: New Server for PostgreSQL

Hello, Planning to go for a new database server.   Should opt for more cores or higher GHz ?   Using one base server (with SQL Server) which is ageing.  Now switched to PostgreSQL.   More load will be there during festival seasons (Deepavali) only and we need to plan for that load only.   There

oldest WAL files not removed

Hi, Looking at WAL folder after a crash, I noticed that new files after restarting overwrite the more recent files before the crash and not the oldest, which was what I expected. Is that normal ? I got only one file marked .deleted. Does that happens when a WAL file hase been completed updat

Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0

On 05.10.20 14:35, Tom Lane wrote: > Mario Emmenlauer writes: >> I get reproducibly the error: >> 2020-10-05 11:48:19.720 CEST [84731] WARNING: dup(0) failed after 0 >> successes: Bad file descriptor > > Hmph. That code loop assumes that stdin exists to be duplicated, > but maybe if it had bee

Question about creation of a new PostgreSQL Extension.

To who it may concern, I am trying to get a project completed to enhance PostgreSQL arithmetic and elementary functions prowess by means of two new High Precision mixed decimal number types in a self installing extension. Hopefully, I want this to be a free or low cost project. Is there an