Hi all,
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
Regards,
Sebastian