MIME-Version: 1.0
References: 
 <CA+dvXXuiL4+SRCZ5fqTr4WZ+pHhRaC9e=D7APBcZ2JGJZMiy6w@mail.gmail.com>
In-Reply-To: 
 <CA+dvXXuiL4+SRCZ5fqTr4WZ+pHhRaC9e=D7APBcZ2JGJZMiy6w@mail.gmail.com>
From: Samed YILDIRIM <samed@reddoc.net>
Date: Tue, 5 Nov 2024 17:37:34 +0200
Message-ID: 
 <CAAo1mbnMTFf9pAyoY7dGGR5xKmZcEd6-nRZ9xyNNa3d5DoJLyg@mail.gmail.com>
Subject: Re: PostgreSQL historical database
To: Erik Serrano <eserranos@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cf319606262c2e55"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAo1mbnMTFf9pAyoY7dGGR5xKmZcEd6-nRZ9xyNNa3d5DoJLyg%40mail.gmail.com>
Precedence: bulk

--000000000000cf319606262c2e55
Content-Type: text/plain; charset="UTF-8"

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?

https://github.com/hettie-d/pg_bitemporal

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*
>
>

--000000000000cf319606262c2e55
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Hello Erik,</div><div dir=3D"auto"><br></div><div di=
r=3D"auto">It is not very clear for me what you are looking for. But, pg_bi=
temporal may be answer for you. I recommend to you to check the repository =
below. If this is not what=C2=A0you want, can you elaborate a little=C2=A0m=
ore?</div><div dir=3D"auto"><br></div><div dir=3D"auto"><a href=3D"https://=
github.com/hettie-d/pg_bitemporal">https://github.com/hettie-d/pg_bitempora=
l</a></div><div><br></div><div data-smartmail=3D"gmail_signature">Best rega=
rds.<br>Samed YILDIRIM</div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Tue, 5 Nov 2024, 17:31 Erik Serrano, &lt;<=
a href=3D"mailto:eserranos@gmail.com">eserranos@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-=
left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>Dear,<br><br>Al=
ong with greetings, I would like to ask if there is any product, way (archi=
tecture), system that allows me to create a historical database from a main=
 transactional database in PostgreSQL.<br><br>I thank you in advance for an=
y contributions that help me to approach this new project.<br><br>Thank you=
 very much, Guys,<br>Regards</div><br clear=3D"all"><div><div dir=3D"ltr" c=
lass=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr=
"><div dir=3D"ltr"><div dir=3D"ltr"><div><br><i><b><br></b></i></div><div><=
i><b><font size=3D"4">Erik R. Serrano Saavedra</font></b></i></div><div><i =
style=3D"font-size:12.8px"><b>=C2=A0 =C2=A0 =C2=A0=C2=A0Data Base Administr=
ator</b></i></div><div><i><b>=C2=A0</b></i></div><div><i><font style=3D"fon=
t-size:12pt" face=3D"Times New Roman" size=3D"3"><b>
</b></font></i><i><font style=3D"font-size:12pt" face=3D"Times New Roman" s=
ize=3D"3"><b><font style=3D"font-size:10pt" size=3D"2"></font></b></font></=
i></div></div></div></div></div></div></div>
</blockquote></div>

--000000000000cf319606262c2e55--