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 1t8LWi-003cgn-Pu for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2024 15:31:28 +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 1t8LWg-00FEAJ-8V for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2024 15:31:26 +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 1t8LWf-00FE9g-TQ for pgsql-admin@lists.postgresql.org; Tue, 05 Nov 2024 15:31:26 +0000 Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t8LWc-000LHn-91 for pgsql-admin@postgresql.org; Tue, 05 Nov 2024 15:31:25 +0000 Received: by mail-lj1-x230.google.com with SMTP id 38308e7fff4ca-2fb5638dd57so53075971fa.0 for ; Tue, 05 Nov 2024 07:31:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730820683; x=1731425483; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=lHa7ARmL1Dajj00Qe9o0+SXeK+hOQm+AkyPvEmzN8q0=; b=P3fZs6m6TyFI7I7hbWaWca8ft6iaGzG7fEqK06BWW/A5Q3Ozw8yCDCVNYD1xAvRb/5 +9tclQvwyX2JSpWyKvFJKL1Zo/F3EClyjHnRzz9+cKdR3jJoiNaekPqrPP+VIAJyHKgk wifjKymeiYWmiQFWxdFWcZf7ZNbgo7M18RhYw2eOvlio4nJd2n4G3ZGW6KnneX2F6+xE GUx2pvWzkH4DpgUPGkryXd6P9Inu9YW5KUYGKZad2Jp540uUGONHPmu1OrVwMwTKPSE9 bYvy6Ln0fjCiXWLixT3oLqOpZZTNU5Gydj2eRf24F/k9v+OYS23DjDY1e0yYr4j/1vK8 nuUQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730820683; x=1731425483; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=lHa7ARmL1Dajj00Qe9o0+SXeK+hOQm+AkyPvEmzN8q0=; b=GZz0W11iv2dQORFj1tKHKLphKzMpAa3XizAIMJzkA5RIdlIoorO+kCAF6zlXVPusVp xiLZnBFw4juKvcsa1jEZdy2JKyMLdrRiHAlnDlMcC4/XnPVcV81mSj8rSV2AV0DTvgrr kmcOa/gzS0JboSc6ERM/f9ETlASky6F0ANTYuiDEvotjh9/8BofSynEuNcVg6F9JTKLs zaEKfXDcRBWfTBwGuNxf9YPDXkSvVl88EH9BdFQjDZmI/c/p8CbteUSQqlYYJP3FlvaS Zt9qfVHBFTNPJwSBPxxNIVowaeuMFGNpJa3S3iBBKbexVpRX3ZKco7pUbgiiBnRYC3rs MXsQ== X-Forwarded-Encrypted: i=1; AJvYcCXOg6Drom7OU1zPr/HClRbSMPxpQco3QZ+za9tIQe7Ts9tBrp4xvp21a8yjC3So2hnrso+LQh+RFiUGUA==@postgresql.org X-Gm-Message-State: AOJu0YzEozz8HkZoiCRSXcrE0nLlRF2sszvLid9wu7Uc01P45/hqhwGg ckyMY0LvJgIPbyirog+WJMZdeK8aVSrEFXxkh3EbzJFokp7qJyNUpXBv64oK9Z/BJyIB4dPmkGU KEsrZpNgbz8lYHHcsCGJk0tiA3uBpQNlK X-Google-Smtp-Source: AGHT+IFW1rTSSllpf9vL/A9jTEgAtdEy3BGuedCBOllDF/y5pFBI3jov1lgr6gtLzpWqdKQUsh9s2xEW/5cp3DJ4EPE= X-Received: by 2002:a05:651c:1992:b0:2fa:bb65:801a with SMTP id 38308e7fff4ca-2fcbdffc9camr175736701fa.26.1730820682306; Tue, 05 Nov 2024 07:31:22 -0800 (PST) MIME-Version: 1.0 From: Erik Serrano Date: Tue, 5 Nov 2024 12:31:11 -0300 Message-ID: Subject: PostgreSQL historical database To: Pgsql-admin , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f05e8e06262c176d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f05e8e06262c176d Content-Type: text/plain; charset="UTF-8" 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* --000000000000f05e8e06262c176d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Dear,

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

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

Thank you very much, Guys,
Regards



Erik R. Serrano = Saavedra
=C2=A0 = =C2=A0 =C2=A0=C2=A0Data Base Administrator
=C2=A0
--000000000000f05e8e06262c176d--