[postgis-users] port option on postgis_restore.pl

[Eduardo Luís Garcia Escovar]

Yes, I think this can be a solution.

Thanks Alex

alex bodnaru escreveu:
> 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