[postgis-users] trouble moving data: revisited

[Sears, Jeremy]

Hey Strk,
Thanks for the prompt reply. 
No, psql will not work w/out asking for a password.
I have set the PGPASSWORD var and tried again...

I still get the msg: 
"password authentification failed for user "postgres_test""

The db superuser is postgres_test. Both this user and the pass have been set
with the environment vars. I dont understand why it says the pass is bad.

Is it possible that the user who restores the new db must be the same one
who created the restore dump? (Im thinking same user name, rights etc..)






-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
strk at refractions.net
Sent: November 24, 2005 3:27 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] trouble moving data: revisited


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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users