[postgis-users] trouble moving data: revisited

[strk at refractions.net]

On Thu, Nov 24, 2005 at 03:19:59PM -0500, Sears, Jeremy wrote:
> 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. 

does running 'psql' work w/out asking for a password ?
Your goal is making it work, probably setting the PGPASSWORD
environmental variable.

--strk;

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email