[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