Re: Fwd: error in the example given for numeric data types

2023-07-15 Thread Peter J. Holzer
On 2023-07-15 12:08:26 +0530, Priyank Rajvansh wrote: > Page: https://www.postgresql.org/docs/15/datatype-numeric.html > Description: > > article 8.1.2 states the following: > > ''We use the following terms below: The precision of a numeric is the total > count of significant digits in the whole

Re: Rocky Linux 9 and postgres10

2023-07-15 Thread Daniel Gallo
Thank you for your answer. On Sat, Jul 15, 2023, 14:02 Adrian Klaver wrote: > On 7/15/23 09:37, Daniel Gallo wrote: > > Good afternoon! I am writing to ask you the following question. > > Can postgres10 be installed on rocky linux 9? > > https://yum.postgresql.org/packages/#pg10 > > > PostgreSQL

Re: Toasted column values during replication

2023-07-15 Thread Chandy G
Using pgoutput - aws rds 13* version and seeing this behavior when using it with debezium 2.0.0 version. Best. On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe wrote: On Fri, 2023-06-30 at 17:06 +, Chandy G wrote: > For instance :  Can the postgres internal component (

Re: error in the example given for numeric data types

2023-07-15 Thread David G. Johnston
On Sat, Jul 15, 2023 at 10:50 AM Priyank Rajvansh < rajvansh.priy...@gmail.com> wrote: > > First of all thanks for your reply.This mean that this was a bug in the > previous versions right? > No, it means that a prior version limitation has been lifted, so a definition that was previously undefin

Re: pg_restore mostly idle on restoring a large number of tables

2023-07-15 Thread Tom Lane
Boris Sagadin writes: > restoring a 1.5TB database with about 800k tables on i3.4xlarge AWS > instace, PgSQL V12.15 on Ubuntu. > Running pg_restore with -j 16, I noticed the pg_restore is busy for an hour > or so with IO at 80%+ and then most of processes start idling and only a > few doing some

Re: error in the example given for numeric data types

2023-07-15 Thread Priyank Rajvansh
First of all thanks for your reply.This mean that this was a bug in the previous versions right? Secondly, I would love to connect with you as I am a college student and I want to be a contributor to open source software so can we connect on some platform? I really need someone to guide me Thankin

Re: Rocky Linux 9 and postgres10

2023-07-15 Thread Adrian Klaver
On 7/15/23 09:37, Daniel Gallo wrote: Good afternoon! I am writing to ask you the following question. Can postgres10 be installed on rocky linux 9? https://yum.postgresql.org/packages/#pg10 PostgreSQL 10 This version is now End-Of-Life. Please upgrade to a supported version as soon as possi

Re: Rocky Linux 9 and postgres10

2023-07-15 Thread David G. Johnston
On Sat, Jul 15, 2023 at 9:37 AM Daniel Gallo wrote: > > Can postgres10 be installed on rocky linux 9? > > PostgreSQL has been running successfully on Linux basically forever so it indeed should work just fine. Whether you will have to build from source or can find an installer is another matter.

Rocky Linux 9 and postgres10

2023-07-15 Thread Daniel Gallo
Good afternoon! I am writing to ask you the following question. Can postgres10 be installed on rocky linux 9? Although I know that it is a version that has already finished its life cycle, we are in migration processes We have a system with centos 7.5 and postgres 10 and the infrastructure group wa

Re: pg_restore mostly idle on restoring a large number of tables

2023-07-15 Thread Ron
On 7/13/23 02:41, Boris Sagadin wrote: Hi, restoring a 1.5TB database with about 800k tables on i3.4xlarge AWS instace, PgSQL V12.15 on Ubuntu. Running pg_restore with -j 16, I noticed the pg_restore is busy for an hour or so with IO at 80%+ and then most of processes start idling and only

Re: error in the example given for numeric data types

2023-07-15 Thread Tom Lane
jian he writes: >> practice=# create table t1(height numeric(3,5)); >> ERROR: NUMERIC scale 5 must be between 0 and precision 3 > it works in pg15, not in pg14. > see my test: https://dbfiddle.uk/wgfjCx7j Indeed. The quoted documentation text is different between v15 and prior versions. Observ

Re: error in the example given for numeric data types

2023-07-15 Thread jian he
> Page: https://www.postgresql.org/docs/15/datatype-numeric.html "docs/15" means this url pointer to pg version 15. > practice=# create table t1(height numeric(3,5)); > ERROR: NUMERIC scale 5 must be between 0 and precision 3 > LINE 1: create table t1(height numeric(3,5)); > Please look into th