[PERFORM] Postgres version change - pg_dump

[sarlav kumar]

Hi All,

 

Thanks to everyone for helping with my previous questions.

 

I have a test database running on Postgres 7.3.2.

 

 version                          
-------------------------------------------------------------
 PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96

I have another server where a newer version of postgres that came with the Fedora Core 3 package installed.

 

version                                                        
-------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6)

 

I would like to do a pg_dump on the test database, and restore it in the new database on Postgres 7.4.6. I would like to know if there would be any problem due to the postgres version/OS change. If so, could someone tell me what precautions I can take to avoid any problems?

 

Thanks in advance,

Saranya

 

 

 

---

Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.