[Top][All Lists]

[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.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]