Tuesday, April 1, 2008

Postgresql Installation Error


Installation Error for postgresql 8.1.0
Error Message : Failed to get system.metric service terminal : 87

This error can occur when the windows doesn't support the old postgresql version
please try to install the lastest postgresql version


postgresql 8.3.0 commands

cmd to take database dump
#pg_dump -U postgres -c -f dbdump_name.sql dbname


cmd to load the dump
# psql -U postgres -d dbname -f dbdump_name.sql