How can RHEL automate copying data from a remote Postgres database to a local MariaDB database?

Question

linux

Created a user, granted select rights to the necessary tables, opened access to connect to the database. Checked the remote connection with navicat, it works. It is necessary to receive data from one database to another every few minutes for further processing and use. Please tell me how this can be automated. No experience in scripting. But I'm ready to receive them, though I have no idea what to take.
Maybe the query itself can directly connect to the source database and receive data without third-party tools (such as insert into ... as select ...), but then how to automate this?

Answer 1

Привет,
В вашем случае, автоматизация - это создание скрипта. Внесите в этот скрипт все команды, которые вы выполняете руками, в нужной вам последовательности. Чего уж проще то...