On 11/9/05, Tito Mari Francis Escaño <[EMAIL PROTECTED]> wrote: > Is there an issue on data handling compatibility between PostgreSQL 7.x and > 8.x? > > Would data dump from v7.x be acceptable to v8.x? > > Our test app was developed using 7.x, specifically 7.4.8. Now, knowing > the features of version 8.x, particularly 8.0.4, I think this will > have a long-term benefit for the server if no issue will hinder.
I just restored our production database dump (7.4.8) to our backup database server running 8.1. no problems so far. The production database is already using views and stored procedures. The only little problem I had was enabling TCP/IP access into the 8.1 server. In 7.x, what you do is to put this on your postgresql.conf: tcpip_socket = true whereas in 8.x, you do something like this instead: listen_addresses = '*' -- Stand before it and there is no beginning. Follow it and there is no end. Stay with the ancient Tao, Move with the present. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
