Hi On Tue, Dec 1, 2020 at 9:17 AM Zhiyu ZY13 Xu <xuz...@lenovo.com> wrote:
> Hi Dave > > > > Thanks for your update. I try to upgrade pgagent_10-3.4.0. But failed. > > Would you like to help me narrow down this upgrade issue ？ Thanks > > > > upgrade path > > version upgrade > > status > > yum install pgagent_10 > > \i pgagent--3.4--4.0.sql > > create extension pgagent; > > 3.4 – 4.0 > > failed > > compile and build. (install cmake and Boost) > > > > \i pgagent--3.4--4.2.sql > > create extension pgagent; > > 3.4 – 4.2 > > failed. > > > > Currently pgagent_10 3.4.0 env installed by my teammate. He told me that > he install it by yum command and execute a script. > > Then those pgagent tables created by this script. There is no extension > exist. But those pgagent table exist. > > > > > > Then I try upgrade pgagent_10 3.40 to 4.0 by yum command. It’s > successfully upgrade by yum command. > > But the pgagent_10 process unable start. > > > > [root@sltfjfrauxq ~]# yum upgrade pgagent_10 > > > > Total download size: 138 k > > Is this ok [y/N]: y > > Downloading Packages: > > pgagent_10-4.0.0-4.rhel6.x86_64.rpm > | 138 kB 00:08 > > Running rpm_check_debug > > Running Transaction Test > > Transaction Test Succeeded > > Running Transaction > > Updating : > pgagent_10-4.0.0-4.rhel6.x86_64 > 1/2 > > Cleanup : > pgagent_10-3.4.0-10.rhel6.x86_64 > 2/2 > > Verifying : > pgagent_10-4.0.0-4.rhel6.x86_64 > 1/2 > > Verifying : > pgagent_10-3.4.0-10.rhel6.x86_64 > 2/2 > > > > Updated: > > pgagent_10.x86_64 0:4.0.0-4.rhel6 > > > > Complete! > > Version: 4.0.0 > > > > > > > > The 4.0 pgagent start logs. > > Tue Dec 1 13:57:53 2020 DEBUG: Creating primary connection > > Tue Dec 1 13:57:53 2020 DEBUG: Parsing connection information... > > Tue Dec 1 13:57:53 2020 DEBUG: user: postgres > > Tue Dec 1 13:57:53 2020 DEBUG: password: ***** > > Tue Dec 1 13:57:53 2020 DEBUG: dbname: postgres > > Tue Dec 1 13:57:53 2020 DEBUG: hostaddr: 127.0.0.1 > > Tue Dec 1 13:57:53 2020 DEBUG: port: 5432 > > Tue Dec 1 13:57:53 2020 DEBUG: Creating DB connection: user=postgres > password=abcd-1234 hostaddr=127.0.0.1 port=5432 dbname=postgres > > Tue Dec 1 13:57:53 2020 DEBUG: Database sanity check > > > > I try to upgrade it by sql. But still on failed. > > > > [root@slbwcbnos2 sql]# pwd > > /data/postgres/new_package/pgAgent-4.0.0-Source/sql > > [root@slbwcbnos2 sql]# ls -al > > total 36 > > drwxr-xr-x 2 501 games 90 Dec 1 14:25 . > > drwxr-xr-x 6 501 games 298 Jul 12 2018 .. > > -rw-r--r-- 1 501 games 538 Jul 12 2018 pgagent--3.4--4.0.sql > > -rw-r--r-- 1 501 games 27772 Jul 12 2018 pgagent.sql > > -rw-r--r-- 1 501 games 2603 Jul 12 2018 pgagent--unpackaged--4.0.sql > > > > postgres=# \i pgagent--3.4--4.0.sql > > Use "CREATE EXTENSION pgagent UPDATE" to load this file. > > postgres=# CREATE EXTENSION pgagent UPDATE; > > ERROR: syntax error at or near "UPDATE" > > LINE 1: CREATE EXTENSION pgagent UPDATE; > > ^ > > postgres=# CREATE EXTENSION pgagent UPDATE; > > ERROR: syntax error at or near "UPDATE" > > LINE 1: CREATE EXTENSION pgagent UPDATE; > > ^ > > postgres=# CREATE EXTENSION pgagent ; > > ERROR: extension "pgagent" has no installation script nor update path for > version "3.4" > > postgres=# > > > > After failed. I try to build and compile the latest version 4.2. > > Build and install successfully. But I still on unable upgrade current 3.4 > version. > > I could create extension successfully on a new database. > > > > > > postgres=# \i pgagent--3.4--4.2.sql > > Use "CREATE EXTENSION pgagent UPDATE" to load this file. > > postgres=# CREATE EXTENSION pgagent UPDATE; > > ERROR: syntax error at or near "UPDATE" > > LINE 1: CREATE EXTENSION pgagent UPDATE; > > ^ > > postgres=# CREATE EXTENSION pgagent ; > > ERROR: relation "pga_jobagent" already exists > > postgres=# > > > > > > > I think the message is wrong (which I'll fix if you can confirm) - it should be: ALTER EXTENSION pgagent UPDATE; -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com
