[opencms-dev] Installation of OpenCMS-6.2.1 on PostgreSQL 8.1.3

[Ivan Codarin]

Hi,
you are using a system-configuration similar to mine.
You can also specify "template1" but you should be sure to be the only 
user/sesison connected to the dbms.
For example you have to shutdown your dbManager software (a.k.a. 
pgadmin3) before starting the setup process.

In postgresql 8.1.3 you can use the "postgres" database as templatedb. 
This database does not exists on the previous versions of postgresql 
(7.4.x); in that case you could use "template1".
I'm using 6.2.0 on postgresql and when I developed the db-driver all the 
unit tests were running well.

Regards
Ivan


Andreas Haumer wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi!
>
> I just wanted to report that today I successfully installed
> OpeenCMS 6.2.1 using PostgreSQL-8.1.3 as database system.
>
> Here is a list of the most important system components involved
> in my test installation:
>
> * Linux operating system
> * Sun JDK 1.5.0_06
> * Apache Tomcat 5.5.17
> * PostgreSQL-8.1.3
> * JDBC driver postgresql-8.1-405.jdbc3.jar
> * OpenCMS-6.2.1
>
> I did a full installation of OpenCMS-6.2.1 with all modules
> provided in the standard distribution and also did a few tests
> of the installed product, which all went without problems.
>
> The installation went quite smoothly, though you still have
> to be careful _not_ to specify "template1" as "Template Db"
> in the database setup dialog.
>
> Instead you have to use the name of some other existing database
> (I always use "postgres", because that also does exist on our
> standard PostgreSQL installations)
>
> If you specify "template1" as "Template DB" in the database
> setup dialog, the next step will fail, as after the initial
> database check the connection to the "template1" database
> will stay in the Tomcat database connection pool and so the
> "template1" database will still be open when the setup program
> tries to create the "opencms" database. PostgreSQL doesn't like
> that and will react with the following message:
>
> ERROR:  source database "template1" is being accessed by other users
>
> For a more elaborate description of this problem please see my
> mail to this mailing list from March 7th, 2006
> <http://mail.opencms.org/pipermail/opencms-dev/2006q1/022605.html>
>
> (I haven't got any reply to my report, but as far as I can tell
> from all my tests since then the analysis and my suggestions to
> solve the problem still are correct. I'm sending this mail hoping
> that it might be useful for others)
>
> HTH
>
> - - andreas
>
> - --
> Andreas Haumer                     | mailto:andreas at xss.co.at
> *x Software + Systeme              | http://www.xss.co.at/
> Karmarschgasse 51/2/20             | Tel: +43-1-6060114-0
> A-1100 Vienna, Austria             | Fax: +43-1-6060114-71
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFEWwyWxJmyeGcXPhERAiaYAJ42YQsjBl6w6Hopfl2Y+0mVZMlTcwCgvmT7
> NNFASkd7lhPyHRbdYqibmOQ=
> =554y
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>