[postgis-users] trouble moving data: revisited

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Thu Nov 24 12:19:59 PST 2005


Good Day All,
Sorry to continue hounding this issue but I have managed to thoroughly
confuse myself. 

Here's a description of my situation:

-We have a PostgreSQL(8.0.2) database on a windows server, PostGIS enabled.
Works fine.

-We have recently installed PostgreSQL(8.1) with the prepackaged PostGIS
(1.0.4) on a new windows server.

The goal here is to dump the data from the old server to the new. So ...
 
- a dump file was created with 'pg_dump -Fc' from the old db. 

following documentation at:
http://postgis.refractions.net/docs/ch02.html#upgrading

- the 'postgis_restore.pl' script was run.
	During the execution of this script I am prompted for the PostgreSQL
password three times. It ALAWAYS indicates :"pass authentification failed
for user "postgres_test"". I am certain I am entering the password properly
each time. I have the environment variable set to this user (set
pguser=postgres_test). What's going on here? Is there a better way to get
data from one db to another? I have had success getting the data into the
new db by other means, however not without errors. 

Any Suggestions?
Best Regards
Jeremy Sears





More information about the postgis-users mailing list