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.
Are you asking about how to "detach" a table from one database, and then attach it to another database?
