Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)

<div class="moz-cite-prefix">On 07/10/2012 11:28 PM, Chris Preston wrote:<br /></div><blockquote
cite="mid:3EED475E754849429C74FCAB58B57CFF@chrisp"type="cite"><pre wrap="">
 
Hello all,
How far can I get to a higher version of PostgreSQL by just entering a
command line instruction to upgrade without any major effort?
</pre></blockquote><br /> Not very, unless your database and queries are very simple.<br /><br /> At minimum you'll
haveto deal with the removal of implicit casts to text ( <a
href="http://www.postgresql.org/docs/current/static/release-8-3.html#AEN116407">http://www.postgresql.org/docs/current/static/release-8-3.html#AEN116407</a>)
and,if you use bytea, the change of default bytea format ( <a
href="http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT"></a><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html#AEN109764">http://www.postgresql.org/docs/current/static/release-9-0.html#AEN109764</a>).<br
/><br/> In general, you will want to read the "Migration to" notes for each version:<br /><br /><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html">http://www.postgresql.org/docs/current/static/release-8-2.html</a><br
/><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html">http://www.postgresql.org/docs/current/static/release-8-3.html</a><br
/><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html">http://www.postgresql.org/docs/current/static/release-8-4.html</a><br
/><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html">http://www.postgresql.org/docs/current/static/release-9-0.html</a><br
/><a
href="http://www.postgresql.org/docs/current/static/release-9-0.html">http://www.postgresql.org/docs/current/static/release-9-1.html</a><br
/><br/> Alternately, you could try using PostgreSQL 9.1's pg_dump on your 8.1 database, load the dump into a 9.1
instance,run your client against it and see what breaks. For simpler apps that can be a reasonable choice.<br /><br />
--<br/> Craig Ringer<br />