Обсуждение: pgagent_upgrade.sql does not exist
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
$ 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@github.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
Thanks Richard - I've updated the message for the next release.
On Mon, Sep 13, 2021 at 6:37 PM Richard Yen <richyen3@gmail.com> wrote:
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@github.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