[TYPO3-english] Upgrading from 4.4 to 4.5 with Postgres

[Jigal van Hemert]

Hi,

On 26-9-2011 10:51, Boris Gulay wrote:
> 24.09.2011 16:58, Jigal van Hemert пишет:
>> Did you run /typo3/sysext/dbal/res/postresql/postgresql-compatibility.sql?
> No, I did not run it manually. Should I do it or it should be run
> automatically by Upgrade wizard?

Someone else with the same problem with Postgresql tested it this 
weekend. We found that you need to have plpgsql installed in Postgres. 
You can test if it is installed by using the query:
	SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql'
See [1]

If plpgsql is available you can run the sql script I mentioned manually.

It is not yet done in the Install Tool / Upgrade wizard [2]

> I have some errors in upgrade wizard, may be this is the case. I will
> try to do upgrade once more and note what error are thrown.

After this script was executed the frontend (and also backend) of TYPO3 
worked correctly. If a COMPARE was done in the Install Tool a lot of 
tables were mentioned which needed to be removed / changed / created. I 
suspect that this is a problem with the way the tables / fields in the 
database are compared with the table structures in core and extensions.

If you find problems with the Install Tool on Postgres, please report 
this in the bugtracker [3].

[1] http://www.polak.ro/postgres-how-to-check-if-plpgsql-is-installed.html
[2] http://forge.typo3.org/issues/29024
[3] http://forge.typo3.org/projects/extension-dbal

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.