[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] pg_upgrade problem on Windows XP and Windows 7
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] pg_upgrade problem on Windows XP and Windows 7 |
Date: |
Mon, 18 Nov 2013 22:51:00 +0100 (CET) |
I tried to use pg_upgrade but guess what it does not work. Here is the error I
have no idea how to fix this.
c:\Windows\Temp>pg_upgrade.exe --old-datadir "C:/Program Files (x86)/PostgresPlu
s/8.4SS/data" --new-datadir "C:/Program Files (x86)/PostgreSQL/9.3/data" --old-b
indir "C:/Program Files (x86)/PostgresPlus/8.4SS/bin" --new-bindir "C:/Program F
iles (x86)/PostgreSQL/9.3/bin"
SQL command failed
CREATE TEMPORARY TABLE info_rels (reloid) AS SELECT c.oid FROM pg_catalog.pg_cla
ss c JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid LEFT OUTER
JOIN pg_catalog.pg_index i ON c.oid = i.indexrelid WHERE relkind IN ('r'
, 'm', 'i', 'S') AND i.indisvalid IS DISTINCT FROM false AND i.indisready IS D
ISTINCT FROM false AND ((n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_to
ast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema',
'binary_upgrade', 'pg_toast') AND
c.oid >= 16384) OR (n.nspname = 'pg_catalog' AND relname IN ('pg_largeob
ject', 'pg_largeobject_loid_pn_index') ));
ERROR: transaction is read-only
Well, this is a bug in pg_upgrade and should be reported as such.
Since databases CAN be readonly for default transactions pg_upgrade
needs to deal with that.
Karasten