Rogelio Monter wrote: > In my company, we're using Postgresql 8.0.0 beta 5 since the > company started to implement databases.
> Win 2000 Server Version 8.0 is years out of support, support for it and 8.1 on Windows was dropped years earlier than for other platforms because there were problems with the Windows implementation which weren't solved until 8.2. We never recommend using a beta test version in production. http://www.postgresql.org/support/versioning/ The version to look at moving to now would be 9.1 or 9.2. > A co-worker said that he couldn't migrate from this version to a > newer onw because it use a datatype that doesn't exist anymore. I'm not personally aware of any datatype being dropped. > how i can upgrade this database to a newer one Install the new software in a different directory (or an a different machine) from the old 8.0.0 beta test software. Use pg_dump from the new software to dump the old database and load a new database. Test for issues before making it live in production. Do it soon; the version you are using is not meant for production, and it would not be surprising if it ate your data. Also, make sure you are taking frequent backups and keeping several generations of them. Future postings on the topic should be on the pgsql-general list; this list is for bug reports. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs