Hi to all, I'm a young padawan in RHEL PostgreSQL configurations. My past experience was in Windows Server with .bat scripts.
My Environment specs: Client OS: Win10 Pro PgAdmin 4.30 Remote Server with PG Remote OS: RHEL8.3 PG Version: 13.1 PG Agent: 4.0 Background history: I set up pgagent based on this adapted to pg_agent13 and documentation: https://www.pgadmin.org/docs/pgadmin4/development/using_pgagent.html https://stackoverflow.com/questions/52168081/systemd-unit-for-pgagent My job is a sh script that makes the daily backups. I test the script and run as expected on a remote server but when configure the job in PgAdmin Win10 Client using in the Code box /pathtoscript/script.sh isn´t working when I click on Run Now. I try to put: sh /pathtoscript/script.sh - Don't do anything to the folder of backups /pathtoscript/script.sh - Don't do anything to the folder of backups Checking the /var/log/pgagent_13.log I see that pgagent establish the connection and Execute the job: Wed Feb 3 10:04:00 2021 DEBUG: Creating DB connection: user=postgres hostaddr=127.0.0.1 port=5432 dbname=postgres Wed Feb 3 10:04:00 2021 DEBUG: Parsing connection information... Wed Feb 3 10:04:00 2021 DEBUG: Allocating new connection for the database with connection string: user=postgres dbname=postgres hostaddr=127.0.0.1 port=5432... Wed Feb 3 10:04:00 2021 DEBUG: Starting job: 1 Wed Feb 3 10:04:00 2021 DEBUG: Executing batch step1(part of job 1) Wed Feb 3 10:04:00 2021 DEBUG: Creating primary connection Wed Feb 3 10:04:00 2021 DEBUG: Parsing connection information... Wed Feb 3 10:04:00 2021 DEBUG: user: postgres Wed Feb 3 10:04:00 2021 DEBUG: dbname: postgres Wed Feb 3 10:04:00 2021 DEBUG: hostaddr: 127.0.0.1 Wed Feb 3 10:04:00 2021 DEBUG: port: 5432 Wed Feb 3 10:04:00 2021 DEBUG: Creating DB connection: user=postgres hostaddr=127.0.0.1 port=5432 dbname=postgres Wed Feb 3 10:04:00 2021 DEBUG: Database sanity check Wed Feb 3 10:04:00 2021 DEBUG: Clearing zombies Wed Feb 3 10:04:00 2021 DEBUG: Checking for jobs to run Wed Feb 3 10:04:00 2021 DEBUG: Sleeping... My question this can be a read/write permissions on destination folder to the user pgagent? Thank you for your time and I'm sorry if I'm asking a silly question. Best regards, João Gaspar
