Hello,
my operating system is Debian 12 Bookworm:
[code]cat /etc/debian_version[/code]
12.9
I have PgAdmin4-Web and PgAgent installed on my system.
I followed this advice when I installed them:
for pgAdmin 4 (APT):
https://www.pgadmin.org/download/pgadmin-4-apt/
for PgAgent:
Install pgAgent on Postgres 10 (Debian Linux)
https://gist.github.com/peterneave/83cefce2a081add244ad7dc1c53bc0c3
PgAdmin4-web works as expected!
Commands to install and set up PgAgent that I have run so far:
(following the above help on gist.github)
Terminal
1. Install pgAgent via package manager
[code]
sudo apt update
sudo apt install pgagent
[/code]
2. Create .pgpass file.
[code]
sudo su - postgres
echo localhost:5432:*:pgagent:securepassword >> ~/.pgpass
chmod 600 ~/.pgpass
chown postgres:postgres /var/lib/postgresql/.pgpass
[/code]
3. Setup Logging directory
[code]
mkdir /var/log/pgagent
chown -R postgres:postgres /var/log/pgagent
chmod g+w /var/log/pgagent
[/code]
Postgres
4. Setup pgAgent on Postgres (maintenance) Database
[code]
sudo su - postgres
psql
CREATE EXTENSION pgagent;
[/code]
Testing
5. Test pgAgent connections
In a separate terminal,
[code]
sudo tail -f /var/log/postgresql/postgresql-15-main.log
[/code]
Postgres connection
Test connection to database in terminal with
[code]
psql -h localhost -d mydatabase -U pgagent
[/code]
There is no error here.
pgAgent
[code]
sudo su - postgres
/usr/bin/pgagent -f -l 2 host=localhost port=5432 user=pgagent dbname=postgres
[/code]
There is an error here!
In postgresql-15-main.log are these errors:
[messages]
2025-02-08 15:49:10.087 CET [15472] pgagent@postgres ERROR:
permission denied for table pga_jobagent
2025-02-08 15:49:10.087 CET [15472] pgagent@postgres STATEMENT:
INSERT INTO pgagent.pga_jobagent (jagpid, jagstation) SELECT
pg_backend_pid(), 'csp4'
2025-02-08 15:49:15.161 CET [15476] pgagent@postgres ERROR:
permission denied for table pga_jobagentThe output of the following
command is:
[/messages]
The output of the next command
[code]
postgres@csp4:~$ /usr/bin/pgagent -f -l 2 host=localhost port=5432
user=pgagent dbname=postgres
[/code]
is:
[messages]
Sat Feb 8 15:49:10 2025 WARNING: Couldn't create the primary
connection [Attempt #9]
Sat Feb 8 15:49:10 2025 DEBUG: Clearing all connections
Sat Feb 8 15:49:10 2025 DEBUG: Connection stats: total - 1, free - 0,
deleted - 1
Sat Feb 8 15:49:15 2025 DEBUG: Creating primary connection
Sat Feb 8 15:49:15 2025 DEBUG: Parsing connection information...
Sat Feb 8 15:49:15 2025 DEBUG: Creating DB connection: user=pgagent
dbname=postgres host=localhost port=5432 dbname=postgres
Sat Feb 8 15:49:15 2025 DEBUG: Database sanity check
Sat Feb 8 15:49:15 2025 DEBUG: Clearing zombies
Sat Feb 8 15:49:15 2025 WARNING: Query error: ERROR: permission
denied for table pga_jobagent
Sat Feb 8 15:49:15 2025 WARNING: Query error: ERROR: permission
denied for table pga_jobagent
Sat Feb 8 15:49:15 2025 WARNING: Couldn't create the primary
connection [Attempt #10]
Sat Feb 8 15:49:15 2025 DEBUG: Clearing all connections
Sat Feb 8 15:49:15 2025 DEBUG: Connection stats: total - 1, free - 0,
deleted - 1
Sat Feb 8 15:49:15 2025 ERROR: Stopping pgAgent: Couldn't establish
the primary connection with the database server.
[/messages]
How do I solve this problem?
Any advice is appreciated!
--
Best wishes by Paul Chanyi!
