On an aside note, the porting doesn't work backwards without a few adjustments to the SQL dump. (tablespaces, etc.)
On 11/11/05, Matt Arnilo S. Baluyos (Mailing Lists) <[EMAIL PROTECTED]> wrote: > 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 > _________________________________________________ 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
