From: | João Gaspar <joao(dot)f(dot)r(dot)gaspar(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | [Question][PGAgent][Jobs] - Problems running sh scripts on remote Server |
Date: | 2021-02-03 11:02:13 |
Message-ID: | CAM+zXj0KXLOymt25ePiC-_ffjJ7ExJKhg2TqWvaAxkifxUOPTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alain Dupeyron | 2021-02-05 18:25:06 | query tool csv/txt output file extension choice and encoding |
Previous Message | Khushboo Vashi | 2021-02-03 04:53:56 | Re: authentication fail |