[postgis-users] port option on postgis_restore.pl

[Eduardo Luís Garcia Escovar]

Hi,

Recently I have decided to upgrade both PostgreSQL and PostGIS instalations.
I've downloaded most recent versions of PostgreSQL, GEOS, PROJ.4 and 
PostGIS.

For testing purposes,  I have mantained my old versions running on the 
default port (5432).
Then I've installed the new versions on an alternative port (5433).

So I dumped my database using the -Fc option, and afterwards I have used 
the Perl script "postgis_restore.pl" to restore it to the instalation 
running on port 5433, following the documentation:

$ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump [createdb options] > restore.log

I have put "-p 5433" (port option) on [createdb options], like this:

$ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump -p 5433 > restore.log

I took me a lot of tries to realize that another commands, like "psql" and "pg_restore" were not using this "port option".


I searched the archives of this list and found the thread 
"/postgis_restore.pl patch to allow psql options"/ (May 2005) which 
discussed this issue, but it seems to me that until now we have to 
modify the perl script in order to access the desired port.

For now I solved the problem stopping the old database for a while and 
starting the new database on default port (5432). Then everything works 
fine.
But I suggest the inclusion of a port option in future versions of 
postgis_restore.pl.

Best Regards,

Eduardo Escovar



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060424/0c81712f/attachment.html>