pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade issue
7+ messages / 5 participants
[nested] [flat]
* pg_upgrade issue
@ 2013-06-19 17:37 Marcos Cano <mcano@stsa.info>
0 siblings, 1 reply; 7+ messages in thread
From: Marcos Cano @ 2013-06-19 17:37 UTC (permalink / raw)
To: pgsql-admin
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the
instructions of the documentation i've found myself in a major issue which
has overwhelmed my little knowledge.
these were the steps i followed:
1)downloand and install 9.2.4, with the contrib packages.
2)init the 9.2.4 cluster in /usr/local/pgsql9.2.4/data, i also have the
8.3.2 cluster in /usr/local/pgsql/data
3) stop both servers
4)change the 9.2.4 port to 5433
5) i run this command:
/usr/local/pgsql9.2.4/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B
/usr/local/pgsql9.2.4/bin/ -c -d /usr/local/pgsql/data/ -D
/usr/local/pgsql9.2.4/data/ -p 5432 -P 5433 -v
so after some 30 seconds the upgrade process seemed like "working" but
after it crashed
with this message:
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt
Failure, exiting
"/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" -o
"" -m fast stop >> "pg_upgrade_server.log" 2>&1
so i went to check the log and found:
ERROR: could not access file "$libdir/liblwgeom": No such file or
directory
STATEMENT: LOAD '$libdir/liblwgeom'
command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D
"/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >> "pg_upgrade_server.log"
2>&1
LOG: received fast shutdown request
LOG: aborting any active transactions
waiting for server to shut down....FATAL: terminating connection due to
administrator command
LOG: could not send data to client: Broken pipe
LOG: shutting down
LOG: database system is shut down
done
server stopped
please help as i dont have any idea what's going wrong
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_upgrade issue
@ 2013-06-19 17:44 Bruce Momjian <bruce@momjian.us>
parent: Marcos Cano <mcano@stsa.info>
0 siblings, 1 reply; 7+ messages in thread
From: Bruce Momjian @ 2013-06-19 17:44 UTC (permalink / raw)
To: Marcos Cano <mcano@stsa.info>; +Cc: pgsql-admin
On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
> ERROR: could not access file "$libdir/liblwgeom": No such file or directory
> STATEMENT: LOAD '$libdir/liblwgeom'
> command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/"
> -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1
OK, so your database references '$libdir/liblwgeom', but the file does
not exist in the 9.2.4 lib directory. Odds are it is some Postgres
extension that you need to install in the new cluster.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_upgrade issue
@ 2013-06-19 20:21 Marcos Cano <mcano@stsa.info>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 7+ messages in thread
From: Marcos Cano @ 2013-06-19 20:21 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin
yes i guess is postgis... because we are using postgis in our DB but I
wasn't aware
On Wednesday, June 19, 2013, Bruce Momjian wrote:
> On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
> > ERROR: could not access file "$libdir/liblwgeom": No such file or
> directory
> > STATEMENT: LOAD '$libdir/liblwgeom'
> > command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D
> "/usr/local/pgsql9.2.4/data/"
> > -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1
>
> OK, so your database references '$libdir/liblwgeom', but the file does
> not exist in the 9.2.4 lib directory. Odds are it is some Postgres
> extension that you need to install in the new cluster.
>
> --
> Bruce Momjian <bruce@momjian.us <javascript:;>>
> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Pg_upgrade issue
@ 2020-12-21 09:51 abbas alizadeh <ramkly@yahoo.com>
0 siblings, 1 reply; 7+ messages in thread
From: abbas alizadeh @ 2020-12-21 09:51 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I wanna upgrade a postgresql database from version 9.0 to 12.4 using pg_upgrade.
But I have an issue with postgis, in current postgresql, postgis v2.0 (possible to upgrade to 2.2) is in use which is not compatible with pg v12.4 and is the last version we can use in pg v9.0(postgis v2.2), so it seems I can’t upgrade database directly from 9.0 to 12.4, the solution I try to use is to upgrade pg v9.2 to v9.6 then on pg v9.6 upgrade postgis to v3.0, and then upgrade pg v9.6 to pg v12.4.
I just wanna know if there is any better solution I can use in this case ir no?
Following picture is my plan to upgrade.
Best Rigards
Abbas.=
Attachments:
solution.png (image/png, 73.0K) download
view image
* Re: Pg_upgrade issue
@ 2020-12-24 15:12 Devrim Gündüz <devrim@gunduz.org>
parent: abbas alizadeh <ramkly@yahoo.com>
0 siblings, 0 replies; 7+ messages in thread
From: Devrim Gündüz @ 2020-12-24 15:12 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; pgsql-admin@lists.postgresql.org
Hi,
On Mon, 2020-12-21 at 17:51 +0800, abbas alizadeh wrote:
> I wanna upgrade a postgresql database from version 9.0 to 12.4 using
> pg_upgrade.
> But I have an issue with postgis, in current postgresql, postgis v2.0
> (possible to upgrade to 2.2) is in use which is not compatible with
> pg v12.4 and is the last version we can use in pg v9.0(postgis v2.2),
> so it seems I can’t upgrade database directly from 9.0 to 12.4, the
> solution I try to use is to upgrade pg v9.2 to v9.6 then on pg v9.6
> upgrade postgis to v3.0, and then upgrade pg v9.6 to pg v12.4.
> I just wanna know if there is any better solution I can use in this
> case ir no?
That is the suggested solution in the PostGIS docs.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Pg_upgrade issue
@ 2022-11-01 03:53 abbas alizadeh <ramkly@yahoo.com>
0 siblings, 1 reply; 7+ messages in thread
From: abbas alizadeh @ 2022-11-01 03:53 UTC (permalink / raw)
To: pgsql-admin
Hi experts
I tried to upgrade one of my databases from v11 to v14.
But I faced following error during upgrade:
“System catalog modifications are currently disallowed”
This is regarding to postgis extention that is installed in pg_catalog, apparently I can’t move extention from pg_catalog to public schema.
In the other hand I can’t drop postgis extention as it uses frequently in different tables.
Is there any option like “allow_system_table_mods” for pu_upgrade?
Any idea how can I sort this issue?
Regards
Abbas
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pg_upgrade issue
@ 2022-11-01 06:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: abbas alizadeh <ramkly@yahoo.com>
0 siblings, 0 replies; 7+ messages in thread
From: Laurenz Albe @ 2022-11-01 06:43 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; pgsql-admin
On Tue, 2022-11-01 at 07:53 +0400, abbas alizadeh wrote:
> I tried to upgrade one of my databases from v11 to v14.
> But I faced following error during upgrade:
> “System catalog modifications are currently disallowed”
> This is regarding to postgis extention that is installed in pg_catalog, apparently I can’t move extention from pg_catalog to public schema.
> In the other hand I can’t drop postgis extention as it uses frequently in different tables.
> Is there any option like “allow_system_table_mods” for pu_upgrade?
> Any idea how can I sort this issue?
Perhaps you can pre.install the extension is a proper schema on v14,
then dump and restore and ignore the error from CREATE EXTENSION.
Other than that, you would be reduced to fixing the old installation,
which would entail catalog modifications that might break your database.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2022-11-01 06:43 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-06-19 17:37 pg_upgrade issue Marcos Cano <mcano@stsa.info>
2013-06-19 17:44 ` Bruce Momjian <bruce@momjian.us>
2013-06-19 20:21 ` Marcos Cano <mcano@stsa.info>
2020-12-21 09:51 Pg_upgrade issue abbas alizadeh <ramkly@yahoo.com>
2020-12-24 15:12 ` Re: Pg_upgrade issue Devrim Gündüz <devrim@gunduz.org>
2022-11-01 03:53 Pg_upgrade issue abbas alizadeh <ramkly@yahoo.com>
2022-11-01 06:43 ` Re: Pg_upgrade issue Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox