[postgis-users] port option on postgis_restore.pl

[alex bodnaru]

maybe setting PGPORT=5433 before calling the entire script would help you?

alex

Eduardo Luís Garcia Escovar wrote:
> 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
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users