Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tC4Kx-00Abrv-45 for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2024 21:58:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tC4Kt-00BsG2-OL for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2024 21:58:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tC4Kt-00BsFt-7N; Fri, 15 Nov 2024 21:58:39 +0000 Received: from mout.kundenserver.de ([212.227.126.130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tC4Kp-0028yQ-Fm; Fri, 15 Nov 2024 21:58:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=msym.fr; s=s1-ionos; t=1731707914; x=1732312714; i=msalais@msym.fr; bh=lh6WwkbfbgZG40dwPK0yE74GqFFgGn3c9hW9vEX//Z8=; h=X-UI-Sender-Class:From:To:Cc:References:In-Reply-To:Subject:Date: Message-ID:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=Ykt7ASSSu8JZljh+unfZ1qjktWg1c0UwYr2CbWPPHqVg7wLaBhE3lQcI1Hw8xeOB Sd2HPLhUhri0n0xebZWwTJ65eexGcDlC8lGXpFAn3sID1vlw+mNDcJKKYiqsopLaz xcnf3mCXzKTh4bwHDNNJQe34mFarCo82VZS0Qr3a7RYwoiaPNbRPXX6H+9d0de+M/ b2aRtyn1Yb3nogBJ2zFBgD21K4u4HzenOVp34fm9kVnLco2/0Q7B0KfjE7qDij9I0 8b4r4HttxoDHRoh2nUQa/OEY0kfcllTN7Q4T8dkDMtuCpEzZb7KmwtVlhZRbDIz+6 +V24E6tYcHnG6wkJPg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from msim1 ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue011 [212.227.15.168]) with ESMTPSA (Nemesis) id 1MYvse-1tGS534568-00IsKH; Fri, 15 Nov 2024 22:58:34 +0100 From: To: "'Erik Serrano'" , "'Samed YILDIRIM'" Cc: "'Pgsql-admin'" , "'pgsql-admin'" References: In-Reply-To: Subject: RE: PostgreSQL historical database Date: Fri, 15 Nov 2024 22:58:31 +0100 Message-ID: <001401db37a9$832a4db0$897ee910$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01DB37B1.E4EF03D0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQI7JBVCSTy86/A4VQhV4xfMyoTG0AGuolvJAll3ojex2MjvEA== Content-Language: fr X-Provags-ID: V03:K1:bbieULv6PcpdH9e8HyY3p0VWKjkX56XHmQsTGg4OWCkBcG9Wy0m dt1gB2PbpZz5qIhS3pm/w5TY+EFNqAdPiSyFtF4k527zNJaxQ50bG4Xw++HrBYwc9UiA2BC BLUcR3Y1Uzusu/aEwcsxo3GY2Kers7Ww6FkZCDBIXkvBiL44ztO1dXkS83pH0G62pL8nqZR EL2R2Dbp+FPdqN8OnuQ8w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:umIrYZ2vlC4=;9j3pN5/9fOcUYjkYGzuj59+3tnG jTEoBl+OkIGZVHDCIsyryLk/eEYFpf5k+zcNc078OBYouOHVjXp8d46ZrIeSktMeCgEfOO7yy ylAX5H1NvDJywyUAZMOsHFDSeJfLNF0/sUl/e7U83my28XTWdsxoAG8B1r7EzhEV/djc5wiFk 7zRKghcu5OG15mNfkQYqTaM6CaJZ7A2W8qu34/9MUkxKgBkDPwKlsCW883ttaWwM122hQl1O8 yPDEEGhqw1XHpywq+70MmxN4sMCdXlHJ/YH8Sgb9afJ5d3tJ/uo16lAPvfzpJze6Bz8k3xi8c Su5pSRTl20CrXPU0d3OBG7KzYquYImbxYileobcjTe5v26NNZ4RHNjpA7UN05pYiKN5eEVffb yPJyshtteBwdjQefIfJ941sVrkzRbjd/Zp/T+C1wJqRBlAVJKCotViYhb0KI1lP78ifDzu3kj +VuqNyan2vqvzeNbac6B9HdS/BgyMmQizJwDJDFD7jaL3a2guGBp5Ta9SOwPAiB8+SntoWeXe wGe4scHi5arkWBnl/6KXV8b2osNko5So184qYwmGFvweTEBUeyI5tEG+z8EMfozvm//9J3JFB 2bEaSuJLOXGuTJ2pxT63c56SJsisSZvzdzlzrJLgnPonsgQMqUIwY63ow8J977AI0qkH2Vfdz 5n5ArVKZogn4CcmR0JnF3wuwmOU9+wj62qD/FEOQhuKMdP7Fxe5ueWc9sToZil8OPLqfWbbte O5gYHKEwBviOysU3XBgjry8BXaSkvaxw7vstgwQEWhvQuAXJ4/wiOLz8iHo+aJGHIRsHeKCqU m86oNqoV/rsSy6UMI3yRag7IFkbFkmS9E7dKRGNK75E1NsuHJXmrh3zaM4XHqv22mD List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0015_01DB37B1.E4EF03D0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, =20 For your purpose, you should study using partitioning and postgres_fdw. =20 Regards =20 Michel SALAIS De : Erik Serrano =20 Envoy=C3=A9 : mardi 5 novembre 2024 18:31 =C3=80 : Samed YILDIRIM Cc : Pgsql-admin ; pgsql-admin = Objet : Re: PostgreSQL historical database =20 =20 Dear Sirs, I'll tell you a little about what I need. Normally, during the day, = records are made or recorded in the main database, which at the end of = the day are consolidated (accounting closings) and are recorded in the = database. In order not to make the main database grow without measure = (which will only maintain the range between 3 months to 1 year). For = this reason, this data must be transferred to another database so that = it lasts over time and can be consulted by other areas. (This action is = done humanly every day of the year at the end of the day) Therefore, the project seeks to be able to carry out this extraction of = the consolidated data to another database, but automatically. I was thinking of doing this with some triggers or with jobs that allow = me to carry out these actions. I also thought of creating a replication = of only the consolidated tables to the new historical database server, = but I have not yet defined the method. That's why I need to know if there is a tool that allows me to create = this database. I hope this clarifies a little the scope of the new historical database. Thank you very much in advance Regards =20 =20 Erik R. Serrano Saavedra Data Base Administrator =20 =20 =20 El mar, 5 nov 2024 a las 12:37, Samed YILDIRIM ( >) escribi=C3=B3: Hello Erik, =20 It is not very clear for me what you are looking for. But, pg_bitemporal = may be answer for you. I recommend to you to check the repository below. = If this is not what you want, can you elaborate a little more? =20 https://github.com/hettie-d/pg_bitemporal =20 Best regards. Samed YILDIRIM =20 On Tue, 5 Nov 2024, 17:31 Erik Serrano, > wrote: Dear, Along with greetings, I would like to ask if there is any product, way = (architecture), system that allows me to create a historical database = from a main transactional database in PostgreSQL. I thank you in advance for any contributions that help me to approach = this new project. Thank you very much, Guys, Regards =20 Erik R. Serrano Saavedra Data Base Administrator =20 ------=_NextPart_000_0015_01DB37B1.E4EF03D0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

For your purpose, you should study = using partitioning and postgres_fdw.

 

Regards

 

Michel = SALAIS

De : Erik Serrano = <eserranos@gmail.com>
Envoy=C3=A9 : mardi 5 = novembre 2024 18:31
=C3=80 : Samed YILDIRIM = <samed@reddoc.net>
Cc : Pgsql-admin = <pgsql-admin@lists.postgresql.org>; pgsql-admin = <pgsql-admin@postgresql.org>
Objet : Re: PostgreSQL = historical database

 

 

Dear Sirs,

I'll tell you a little about = what I need. Normally, during the day, records are made or recorded in = the main database, which at the end of the day are consolidated = (accounting closings) and are recorded in the database. In order not to = make the main database grow without measure (which will only maintain = the range between 3 months to 1 year). For this reason, this data must = be transferred to another database so that it lasts over time and can be = consulted by other areas. (This action is done humanly every day of the = year at the end of the day)
Therefore, the project seeks to be able = to carry out this extraction of the consolidated data to another = database, but automatically.

I was thinking of doing this with = some triggers or with jobs that allow me to carry out these actions. I = also thought of creating a replication of only the consolidated tables = to the new historical database server, but I have not yet defined the = method.

That's why I need to know if there is a tool that allows = me to create this database.

I hope this clarifies a little the = scope of the new historical database.

Thank you very much in = advance
Regards

 

 

Erik R. Serrano = Saavedra

    =   Data Base = Administrator

 

 

 

El = mar, 5 nov 2024 a las 12:37, Samed YILDIRIM (<samed@reddoc.net>) = escribi=C3=B3:

Hello Erik,

 

It is not very clear for me what you are looking for. = But, pg_bitemporal may be answer for you. I recommend to you to check = the repository below. If this is not what you want, can you = elaborate a little more?

 

 

Best regards.
Samed = YILDIRIM

 

On = Tue, 5 Nov 2024, 17:31 Erik Serrano, <eserranos@gmail.com> = wrote:

Dear,

Along with greetings, I would like to ask = if there is any product, way (architecture), system that allows me to = create a historical database from a main transactional database in = PostgreSQL.

I thank you in advance for any contributions that = help me to approach this new project.

Thank you very much, = Guys,
Regards


 

Erik R. Serrano = Saavedra

    =   Data Base = Administrator

 

= ------=_NextPart_000_0015_01DB37B1.E4EF03D0--