Re: pgagent_upgrade.sql does not exist
От | Dave Page |
---|---|
Тема | Re: pgagent_upgrade.sql does not exist |
Дата | |
Msg-id | CA+OCxoyRnMeKi8-AJ+fRC4rP7aHMb1AJGXsj5z-SnKRtPJE0pQ@mail.gmail.com обсуждение исходный текст |
Ответ на | pgagent_upgrade.sql does not exist (Richard Yen <richyen3@gmail.com>) |
Список | pgadmin-hackers |
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
В списке pgadmin-hackers по дате отправления: