title: Errors in Migration of an old PostgreSQL Database with Postgis Objects
body: <p>We have a very old Linux system running PostgreSQL 8.3. The system contains a database with Postgis functions, but, from pgAdmin III interface, no 'Extensions' seem enabled. That server machine is going to go obsolete and we want to move to another Postgres server. </p>
  
  <p>Currently we have a Windows server Postgres 9.3. I have been able to create a custom .backup file and am able to import most of the tables and data using the approach per: <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade" rel="nofollow noreferrer">http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade</a> but my error.txt file says:</p>
  
  <pre><code>function makepoint(double precision, double precision) does not exist
  </code></pre>
  
  <p>and I think this function is part of the <code>liblwgeom.dll</code> and I can't find that DLL file anywhere! I have gone through most of the zip downloads from: <a href="http://download.osgeo.org/postgis/windows/" rel="nofollow noreferrer">http://download.osgeo.org/postgis/windows/</a> but no luck. </p>
  
  <p>The original database does have a 'makepoint' function as below but it doesn't work on the target Windows system because of a lack of the DLL.</p>
  
  <p>What are my options? </p>
  
  <p>Maybe a different approach is needed. Please note, per the <a href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade" rel="nofollow noreferrer">http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade</a> I had also tried the 'Hard Upgrade' using the .backup file in a Linux environment but got some error like 'invalid header', presumably due to the pg restore tool being too new; in Linux, my progress was way less than in the Windows one.</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION makepoint(double precision, double precision)
  RETURNS geometry AS '$libdir/liblwgeom', 'LWGEOM_makepoint'
  LANGUAGE c IMMUTABLE STRICT COST 1; ALTER FUNCTION makepoint(double   precision, double precision)  OWNER TO postgres;
  </code></pre>
  
  <p><strong><em>Edit</em></strong> This is a Windows system and so the proposed Mac OS suggestion is not valid. Thanks though.</p>