Skip to content
This repository was archived by the owner on Aug 14, 2026. It is now read-only.
This repository was archived by the owner on Aug 14, 2026. It is now read-only.

To send output of query via mail using pgagent from three different databases hosted on three different servers #45

Description

@Motivation78

There are three different databases hosted on three different servers. There is a table and a procedure created for this table as well. It truncates it's dta and refreshes the table and then fill in new data in there from two different tables. Now the point is I wanted to send the output of the query, select * from table; via mail and also schedule the procedure to be called on its own each day. I did this using pgAdmin, created a bash script, procedure is called and output of the table is sent via mail. This is sorted.
Now I want the same thing to happen on all three servers, but instead of three different mails, I want to send one single mail containing output of query from all three tables in those three different databases hosted on three different servers. How can I achieve that using pgagent?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions