Re: Proposed Translations of Updated Code of Conduct Policy

Hi, Le mar. 19 juil. 2022 à 08:49, Stefan Fercot a écrit : > Hi, > > There's a typo in the french translation. "consécutis" should be " > consécutifs". > > And per consistency, I'd suggest to not mix "mandat" and "termes" to speak > about the same thing. I believe it would be better to replace "

Re: Proposed Translations of Updated Code of Conduct Policy

Hi, There's a typo in the french translation. "consécutis" should be "consécutifs". And per consistency, I'd suggest to not mix "mandat" and "termes" to speak about the same thing. I believe it would be better to replace "(3) termes consécutis" by "(3) mandats consécutifs". -- Kind Regards, S

Migrating from Oracle - Implicit Casting Issue

On Monday, July 18, 2022, Karthik K L V wrote: > Hi Team, > > We are migrating from Oracle 12c to Aurora Postgres 13 and running into > implicit casting issues. > > Oracle is able to implicitly cast the bind value of prepared statements > executed from the application to appropriate type - String

Migrating from Oracle - Implicit Casting Issue

Hi Team, We are migrating from Oracle 12c to Aurora Postgres 13 and running into implicit casting issues. Oracle is able to implicitly cast the bind value of prepared statements executed from the application to appropriate type - String -> Number, String -> Date, Number -> String etc. when there

Re: equivalent thing of mtr in mysql

> On Jul 18, 2022, at 20:03, merryok wrote: > > I've read the doc, and it doesn't help too much. > Finally I've found START_CRIT_SECTION and END_CRIT_SECTION. It's like > mtr.start(), mtr.commit() in mysql. May I ask why many places are wrapped > into START_CRIT_SECTION/END_CRIT_SECTION duri

Re: Getting the table ID

On Mon, Jul 18, 2022 at 8:11 PM Igor Korot wrote: > > There is a pg_namespace table - is this where the schema should come from? > If yes - how? > Looking at that table I don't see any unique fields... > Or is this something that is hidden? > Catalogs don't have all of the same metadata that use

Getting the table ID

Hi, guys, In the database theory each table is identified as "schema_name"."table_name". When I tried to look at how to get the table id inside the PostgreSQL, I saw that I needed to look at the pg_class table. SELECT oid FROM pg_class WHERE relname = "table_name"; However that query will give

Re: equivalent thing of mtr in mysql

I've read the doc, and it doesn't help too much. Finally I've found START_CRIT_SECTION and END_CRIT_SECTION. It's like mtr.start(), mtr.commit() in mysql. May I ask why many places are wrapped into START_CRIT_SECTION/END_CRIT_SECTION during a single dml operation ? And if Assert(CritSectionCount >

Re: postgis

On 7/18/22 11:48, Marc Millas wrote: Hi, postgres 12. I may use whatever repo. I install postgres from postgresql.org... You pretty much need to install from the same repo for PostGIS. Otherwise you will most likely run into compatibility issues. From here: https://apt.postgresql.org/pub/r

Re: pg_receivewal/xlog to ship wal to cloud

On Mon, 2022-07-18 at 15:55 -0400, neslişah demirci wrote: > Hi all,  > > Wondering if anyone has any experience of using pg_receivewal/xlog > to ship wal files to GCP/S3? > I use archive_command to send WAL to S3. It works fine. I do gzip them before uploading, as they are usually pretty compre

Re: pg_receivewal/xlog to ship wal to cloud

Or downloading from cloud experience? neslişah demirci , 18 Tem 2022 Pzt, 15:55 tarihinde şunu yazdı: > Hi all, > > Wondering if anyone has any experience of using pg_receivewal/xlog to ship > wal files to GCP/S3? > > Could you please share ideas or issues you had? > > Thanks. > -- Best, Nesli

pg_receivewal/xlog to ship wal to cloud

Hi all, Wondering if anyone has any experience of using pg_receivewal/xlog to ship wal files to GCP/S3? Could you please share ideas or issues you had? Thanks.

Re: PostgreSQL 14.4 ERROR: out of memory issues

=?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= writes: > postgres=# show shared_buffers ; > shared_buffers > > 10GB > (1 row) Oh! In that case, there is absolutely nothing to see here. This chunk: > 7fd9b0551000 10827040K rw-s- zero (deleted) must be your shared-memory region, and it'

Re: PostgreSQL 14.4 ERROR: out of memory issues

po 18. 7. 2022 v 20:26 odesílatel Aleš Zelený napsal: > > po 18. 7. 2022 v 16:25 odesílatel Tom Lane napsal: > >> =?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= writes: >> > after some time, I've found a process consuming over 1GB of memory" >> > -bash-4.2$ grep RssAnon /proc/*/status | sort -nk2 | tail >> >

Re: postgis

Hi, postgres 12. I may use whatever repo. I install postgres from postgresql.org... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Jul 18, 2022 at 7:15 PM Adrian Klaver wrote: > On 7/18/22 10:08, Marc Millas wrote: > > Hi, > > > > I would like to install postgis 3.04 on a

Re: PostgreSQL 14.4 ERROR: out of memory issues

po 18. 7. 2022 v 16:25 odesílatel Tom Lane napsal: > =?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= writes: > > after some time, I've found a process consuming over 1GB of memory" > > -bash-4.2$ grep RssAnon /proc/*/status | sort -nk2 | tail > > /proc/17048/status:RssAnon: 1053952 kB > > > Here are memory con

Re: postgis

On 7/18/22 10:08, Marc Millas wrote: Hi, I would like to install postgis 3.04 on a debian 11. digging into various web sites, I didnt found the name of that packet. can someone help ? Should have added to previous response, what version of Postgres? thanks Marc MILLAS Senior Architect +33

Re: postgis

On 7/18/22 10:08, Marc Millas wrote: Hi, I would like to install postgis 3.04 on a debian 11. digging into various web sites, I didnt found the name of that packet. can someone help ? Where did you install Postgres from, the Debian or the Postgres community repos? thanks Marc MILLAS Se

postgis

Hi, I would like to install postgis 3.04 on a debian 11. digging into various web sites, I didnt found the name of that packet. can someone help ? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: PostgreSQL 14.4 ERROR: out of memory issues

=?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= writes: > after some time, I've found a process consuming over 1GB of memory" > -bash-4.2$ grep RssAnon /proc/*/status | sort -nk2 | tail > /proc/17048/status:RssAnon: 1053952 kB > Here are memory contexts for PID 17048: > TopMemoryContext: 422592 total in 14 blo

Re: PostgreSQL 14.4 ERROR: out of memory issues

Hello, čt 14. 7. 2022 v 23:31 odesílatel Aleš Zelený napsal: > > > Dne čt 14. 7. 2022 23:11 uživatel Tomas Vondra < > tomas.von...@enterprisedb.com> napsal: > >> >> >> On 7/14/22 21:25, Aleš Zelený wrote: >> > >> > st 13. 7. 2022 v 2:20 odesílatel Michael Paquier > >

Re: More than one Cluster on single server (single instance)

On 7/18/22 04:46, Guillaume Lelarge wrote: Hi, [snip] It would make things easier for you to use a single cluster, and as many databases as you want in this cluster. It would make *PITR* restoration *of a single database* (or small set of databases) impossible (since such backups -- and ther

Re: More than one Cluster on single server (single instance)

On 7/18/22 02:55, Daulat wrote: Hello Team, We are planning to create multiple clusters on a single server (single instance) with PostgreSQL V.10 to run multiple applications. Version (9,6, 10, 111, 12...) does not matter. I don't know if it is a good idea to use a single machine to run n

Re: More than one Cluster on single server (single instance)

On 7/18/22 03:55, Daulat wrote: Please share your thoughts on this approach? How can we create multiple clusters under a single postgres version? You can use Docker images. How can we identify/allocate the resources to parameters like shared_buffers, effective_cache_size, work_mem etc in cas

Re: More than one Cluster on single server (single instance)

Hi, Le lun. 18 juil. 2022 à 09:55, Daulat a écrit : > > Hello Team, > > We are planning to create multiple clusters on a single server (single > instance) with PostgreSQL V.10 to run multiple applications. > > Planning to create a database cluster on a release 10 sounds already like a bad idea,

More than one Cluster on single server (single instance)

Hello Team, We are planning to create multiple clusters on a single server (single instance) with PostgreSQL V.10 to run multiple applications. I don't know if it is a good idea to use a single machine to run n clusters but we are looking to minimize the cost of servers and other resources. Plea