On Fri, Oct 31, 2008 at 01:29:16PM -0200, Rogerio Luz wrote:
> No fresh bootstrap, recover from Backup
Well, that would restore whatever version of the file was
initially bootstrapped into the database the backup was
taken from.
> - version of the file:
>
> -- $Id: v9-i18n-dynamic.sql,v
1.1.2.3 2008/10/28 12:35:03 ncq Exp $
> -- $Revision:
1.1.2.3 $
find the version it that in the restored database you will
need to run the following query with pgAdmin or psql:
SELECT * from gm_schema_revision where filename like '%v9-i18n-dynamic.sql%';
If that version is not 1.1.2.3 like the above you'd have to
manually fix the database as described in the release notes.
> the ¨set default_transaction..." line I found and uncommented, continues to
> show this error, the other fix I do not know how to do.
You'd need to use psql or pgAdmin to run the two queries
against the database.
> > set default_transaction_read_only to off;
> > alter database set lc_messages to 'C';
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346