Devolopment -> Testing -> Production Problems

Hi, I'am having a lot of headaches when I move my db from a development
server to another server. Especially do with functions and the cache
lookup fail error.

Is there a "best" way to move a db to lesson these types of problems.

My development server is a laptop running windows, cygwin and postgresq
7.1.3, my production box is debian and postgresql 7.1.3.

I use pgAdmin to do all my table and function managment (functions are
pgplSQL). I have keep my functions in Microsoft's Visual Source Safe.

I generally use pg_dump -o -O -x > output.file to dump the database and
psql -d database < output.file to import.

Sometimes I use pgAdmins publish database to move the tables and
functions and then a pg_dump -a > output.file to move the data.

Either way I still end up spending hours tracking down errors, which is
a real pain.

any help will be gratefull, thanks


Dean Grubb