[Pkg-postgresql-public] Bug#838953: add choice to do configuration for the user

積丹尼 Dan Jacobson jidanni at jidanni.org
Tue Sep 27 03:00:41 UTC 2016


By the way, the whole thing fails anyway

# pg_dropcluster --stop 9.6 main
Redirecting stop request to systemctl
# pg_upgradecluster 9.5 main
Stopping old cluster...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop operation
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Redirecting start request to systemctl
Creating new cluster 9.6/main ...
  config /etc/postgresql/9.6/main
  data   /var/lib/postgresql/9.6/main
  locale zh_TW.UTF-8
  socket /var/run/postgresql
  port   5433
Disabling connections to the new cluster during upgrade...
Redirecting start request to systemctl
Roles, databases, schemas, ACLs...
ERROR:  could not open extension control file "/usr/share/postgresql/9.6/extension/postgis.control": No such file or directory
ERROR:  extension "postgis" does not exist
ERROR:  type "geometry" does not exist
LINE 3:     "wkb_geometry" "geometry"(Geometry,4326),
                           ^
ERROR:  relation "kk1" does not exist
ERROR:  relation "kk1" does not exist
ERROR:  type "geometry" does not exist
LINE 3:     "wkb_geometry" "geometry"(Geometry,4326),
                           ^
ERROR:  relation "燥坑門牌" does not exist
ERROR:  relation "燥坑門牌" does not exist
ERROR:  relation "kk1" does not exist
ERROR:  relation "燥坑門牌" does not exist
ERROR:  relation "kk1" does not exist
ERROR:  relation "燥坑門牌" does not exist
ERROR:  relation "kk1" does not exist
ERROR:  relation "燥坑門牌" does not exist
Fixing hardcoded library paths for stored procedures...
Upgrading database zaokeng...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3440; 0 17775 TABLE DATA kk1 jidanni
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "kk1" does not exist
    Command was: ALTER TABLE kk1 DISABLE TRIGGER ALL;


pg_restore: [archiver (db)] could not execute query: ERROR:  relation "kk1" does not exist
    Command was: COPY "kk1" ("ogc_fid", "wkb_geometry", "name", "description", "timestamp", "begin", "end", "altitudemode", "tessellate", "ex...
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "kk1" does not exist
    Command was: ALTER TABLE kk1 ENABLE TRIGGER ALL;


pg_restore: [archiver (db)] Error from TOC entry 3307; 0 16677 TABLE DATA spatial_ref_sys postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "spatial_ref_sys" does not exist
    Command was: ALTER TABLE spatial_ref_sys DISABLE TRIGGER ALL;


pg_restore: [archiver (db)] could not execute query: ERROR:  relation "spatial_ref_sys" does not exist
    Command was: COPY "spatial_ref_sys"  FROM stdin;

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "spatial_ref_sys" does not exist
    Command was: ALTER TABLE spatial_ref_sys ENABLE TRIGGER ALL;


pg_restore: [archiver (db)] Error from TOC entry 3438; 0 17763 TABLE DATA 燥坑門牌 jidanni
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "
燥坑門牌" does not exist
    Command was: ALTER TABLE "燥坑門牌" DISABLE TRIGGER ALL;


pg_restore: [archiver (db)] could not execute query: ERROR:  relation "燥坑門牌" does not exist
    Command was: COPY "燥坑門牌" ("ogc_fid", "wkb_geometry", "name", "description", "timestamp", "begin", "end", "altitudemode", "tessell...
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "燥坑門牌" does not exist
    Command was: ALTER TABLE "燥坑門牌" ENABLE TRIGGER ALL;


WARNING: errors ignored on restore: 9
Analyzing database zaokeng...
Fixing hardcoded library paths for stored procedures...
Upgrading database template1...
Analyzing database template1...
Fixing hardcoded library paths for stored procedures...
Upgrading database postgres...
Analyzing database postgres...
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Copying old configuration files...
Copying old start.conf...
Copying old pg_ctl.conf...
Stopping target cluster...
Redirecting stop request to systemctl
Stopping old cluster...
Redirecting stop request to systemctl
Disabling automatic startup of old cluster...
Configuring old cluster to use a different port (5433)...
Starting target cluster on the original port...
Redirecting start request to systemctl
Success. Please check that the upgraded cluster works. If it does,
you can remove the old cluster with

  pg_dropcluster 9.5 main

And I don't know what to do now.



More information about the Pkg-postgresql-public mailing list