CODEWITHSUNDEEP
postgresqlpgadmin
Simon GIS
Simon GIS

Reputation: 1055

pgAdmin can't see pgAgent Job scheduler

I've been trying to install PgAgent on PostgreSQL.

As you can see, I have it in my catalog and in the extensions.

But why it doesn't appear on my tablespaces?

enter image description here

I also cant reset the PG admin section

enter image description here

Upvotes: 1

Views: 8540

Answers (4)

Jongpyo Jeon
Jongpyo Jeon

Reputation: 359

pgAgent needs to be created in postgres database in order to show up.

I got a pgagent job when I processed create extension in postgres databases. Thank you.

Upvotes: 0

Justin
Justin

Reputation: 21

pgAgent needs to be created in postgres database in order to show up.

Upvotes: 1

Var dhan
Var dhan

Reputation: 1

Steps: 1. Install the pgagent to a particular database in a server. 2. create a new connection in pgadmin where give maintainance database as the once to which the pgagent is installed.

This will eneable the pg agent jobs option in the connection database to become visible

Upvotes: 0

Jim Jones
Jim Jones

Reputation: 19613

pgAgent Jobs do not appear in the Tablespaces unless you manually create one with this name :)

The Jobs are listed in a separated section on pgAdmin

enter image description here

Keep in mind that in the pgAdmin connection you have to set the maintenance database to the database you have installed pgAgent. In my case, the postgres database:

enter image description here

Upvotes: 8

Related Questions