pgadmin-org / pgagent

pgAgent - A job scheduler for PostgreSQL
https://www.pgadmin.org/
Other
97 stars 41 forks source link

Cannot access to job's distant server from local PgAgent/PgAdmin #30

Closed tecumuman closed 1 year ago

tecumuman commented 1 year ago

Hello,

Can you help me please : i cannot access to the list job of my distant server from my local PgAgent/PgAdmin

Which points a i need to verify and share with you ?

Thank

tecumuman commented 1 year ago

Good morning,

For completion :

On my Ubuntu Server (23.04) I installed PostgreSql (in version 14) and PgAgent on which I created my periodic jobs.

I use PgAdmin4 to access my database and my objects/scripts/etc.

Locally (on the server) I have good access from PgAdmin to my databases and various objects including the PgAgents Tasks (jobs) and its underlying objects that I created: OK

From my Windows laptop on which I have also installed PgAdmin4, I can access my databases and various objects in the same way on a local network (LAN) including the PgAgents Tasks (jobs) and its underlying objects that I created: OK

On the other hand, still from PgAdmin4 of my Windows laptop, I try to access the same way outside (WAN -> when I am remote) to my databases and various objects including Tasks (jobs) PgAgents: I access to my databases and other DBMS objects BUT NOT to PgAgent objects -> the "PgAgent Tasks" item is present but none of the underlying objects I created: KOO

How to remedy this? I have checked my authentication and configuration files but I do not see anything abnormal? Did I forget something?

Thanking you in advance for your help.

Good day.

tecumuman commented 1 year ago

Good evening,

By dint of searching and going around in circles, I found: these are the connection parameters of PgAdmin (LAN and WAN): the server's targeted maintenance database was not on postgres on the WAN connection (while in LAN yes) but on that of the project, by specifying the postgres base (where logically PgAgent is installed) the jobs finally became accessible PgAdmin . Sorry ! However, I hope this feedback can help someone. Good evening.