pgagent_upgrade.sql does not exist

From: Richard Yen <richyen3(at)gmail(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgagent_upgrade.sql does not exist
Date: 2021-09-13 17:36:47
Message-ID: CAKH4vDhVpjKbJa291PQS18MOg6NPoFJH2Qs7M5xGzzBf_itFsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi PgAdmin Team,

I'm not sure if this is the right channel, but there's mention of pgagent
in the PgAdmin docs [1]. I have been trying to fix a customer's pgagent
install, and this is the following information printed when starting up
pgagent:

```

-bash-4.2$ /usr/edb/as13/bin/pgagent -l2 -f host=127.0.0.1
user=enterprisedb dbname=postgres
Thu Sep 9 20:15:10 2021 DEBUG: Creating primary connection
Thu Sep 9 20:15:10 2021 DEBUG: Parsing connection information...
Thu Sep 9 20:15:10 2021 DEBUG: user: enterprisedb
Thu Sep 9 20:15:10 2021 DEBUG: dbname: postgres
Thu Sep 9 20:15:10 2021 DEBUG: host: 127.0.0.1
Thu Sep 9 20:15:10 2021 DEBUG: Creating DB connection:
user=enterprisedb host=127.0.0.1 dbname=postgres
Thu Sep 9 20:15:10 2021 DEBUG: Database sanity check
Thu Sep 9 20:15:10 2021 ERROR: Unsupported schema version: 3. Version
4 is required - please run pgagent_upgrade.sql.
-bash-4.2$ find /usr/edb/ -name "pgagent_upgrade.sql"
-bash-4.2$

```

Notice that I could not find pgagent_upgrade.sql anywhere. I also looked
in the PgAdmin repository, but could not find it:

```
$ find . -name "pgagent_upgrade.sql"
$ git status
On branch master
Your branch is up to date with 'origin/master'.

nothing to commit, working tree clean
```

I also looked at the pgagent repository (git(at)github(dot)com:postgres/pgagent.git),
and could not find the file. Perhaps this log message is an artifact that
needs to be removed?

FWIW, I managed to fix the customer's pgagent install by executing `ALTER
EXTENSION "pgagent" UPDATE;`, as specified by pg_upgrade.

Please let me know if you need more info here.

Regards,
--Richard

[1]: https://www.pgadmin.org/docs/pgadmin4/development/pgagent.html

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Nikhil Mohite 2021-09-14 04:35:45 [pgAdmin][RM-6687]: [React] Port Grant Wizard to react
Previous Message Akshay Joshi 2021-09-10 12:57:23 pgAdmin 4 commit: Fixed an issue where the drop cascade button enables