Hi. I must migrate a database from a server with postgresql 7 to a
server with postgresql 8.

Do I need some conversion?

Thanks.

On Mar 9, 5:03 pm, Lucifer <luci... (AT) spamcop (DOT) net> wrote:
There have been several improvements since the earlier PostgreSQL 7.
As far as I know, you should not need anything special (at least, in
terms of upgrading/migrating the database itself). I would suggest
using pg_dump to backup the database(s) and then use psql to restore
the database. Hope this helps.

Regards,

Enrique Martinez
Sr. Web/Database Developer

"EMartinez" <emartinez.pr1 (AT) gmail (DOT) com> schreef in bericht
news:1173594924.803602.201440 (AT) 64g2000cwx (DOT) googlegroups.com...
7.4.

Some changes may require you to modify your queries ...
.... FTTOMH based on upgrading 7.3 to 8.1 April last
- 'where field > 5' will crash for field is null
'where '0'||field > 5' may save the day, but will ignore its index
- '0+field::interval' will crash for TWO reasons
use '1970-0-0':date+field::text::interval'
- 'group by field' is no longer guranteed to sort too
use 'group by field order by field' to restore consistent results
- 'max(field)' will use index
workaround 'order by field limit 1' is no longer needed
Go down the list of changes at
http://www.postgresql.org/docs/8.2/i...e/release.html
for more "deprecated features"

Hans