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: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 5 Nov 2024 12:01:55 -0500
Message-ID: 
 <CANzqJaA8OP3ukTPunDoa1d+xz7P8TqU9HntXB0y8QopRq2ugoQ@mail.gmail.com>
Subject: Re: PostgreSQL historical database
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000067c43106262d5cbe"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaA8OP3ukTPunDoa1d%2Bxz7P8TqU9HntXB0y8QopRq2ugoQ%40mail.gmail.com>
Precedence: bulk

--00000000000067c43106262d5cbe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 5, 2024 at 10:31=E2=80=AFAM 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 fro=
m
> a main transactional database in PostgreSQL.
>

Are you asking about how to "detach" a *table* from one database, and then
attach it to another database?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Nov 5, 2024 at 10:31=E2=80=AFAM E=
rik Serrano &lt;<a href=3D"mailto:eserranos@gmail.com">eserranos@gmail.com<=
/a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"ltr"><div>Dear,<br><br>Along with gre=
etings, I would like to ask if there is any product, way (architecture), sy=
stem that allows me to create a historical database from a main transaction=
al database in PostgreSQL.</div></div></blockquote><div><br></div><div>Are =
you asking about how to &quot;detach&quot; a <b>table</b>=C2=A0from one dat=
abase, and then attach it to another database?</div></div><div><br></div><s=
pan class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter=
 sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redact=
ed&gt; crustacean!</div></div></div></div></div></div>

--00000000000067c43106262d5cbe--