[postgis-users] pg_restore: [archiver] could not open input file

[Stefan Schwarzer]

Hi,

gush, the migration of a database from one computer to another is  
really a headache. Or perhaps I am doing something wrong. But perhaps  
it's only because I am running different versions of postgres and  
postgis. In the moment I have to "copy" the database from my local  
machine a) to the server and b) to my new computer.

When I try to migrate it to the new computer with the following  
settings:

	my old machine with PostGres 8.1.2 and PostGIS 1.1.1
	my new machine with PostGres 8.2.1 and PostGIS 1.2.1

and these parameters:

	sh postgis_restore.pl lwpostgis.sql geodataportal  
pgdump_local_geodataportal_2007-02-02.sql

I get the following information:

	postgis.sql is /usr/local/pgsql/share/contrib/lwpostgis.sql
	dbname is geodataportal
	dumpfile is /Users/Shared/pgdump_local_geodataportal_2007-02-02.sql
	Scanning /usr/local/pgsql/share/contrib/lwpostgis.sql
	SQLFUNC: histogram2d_in(cstring)
	SQLFUNC: histogram2d_out(histogram2d)
	...
	...
	
Until here it's ok. But then this:

	Scanning /Users/Shared/pgdump_local_geodataportal_2007-02-02.sql list
	pg_restore: [archiver] could not open input file: No such file or  
directory
	Producing ascii dump /Users/Shared/ 
pgdump_local_geodataportal_2007-02-02.sql.ascii
	pg_restore: [archiver] could not open input file: No such file or  
directory
	pg_restore call failed

Any idea what that could be?