| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | "Schuhmacher, Bret" <Bret(dot)Schuhmacher(at)Aspect(dot)com> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Psql bug on Windows or pilot error? ;-) |
| Date: | 2005-05-18 14:30:50 |
| Message-ID: | 3c7e4afa7080f59ca8777047ee03a452@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On May 18, 2005, at 8:58 AM, Schuhmacher, Bret wrote:
> I'm trying to restore a db I dumped on Linux to a windows box for local
> development. When I run this on Linux
> ./psql test < dumpfile, I get prompted for a password.
>
> On windows, the same command is shown below:
> C:\Program Files\PostgreSQL\8.0\bin>psql -U postgres test <
> d:\temp\testdb_05170
> 5
> Password:
> psql: FATAL: password authentication failed for user "postgres"
There seems to be a problem on Windows using '<'. Try this instead:
C:\Program Files\PostgreSQL\8.0\bin>psql -U postgres -f
d:\temp\testdb_05170 test
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Goodaire | 2005-05-18 16:12:31 | Re: Unable to connect from other machine |
| Previous Message | Pascual De Ruvo | 2005-05-18 13:01:59 | Re: Storing/Using Passwords |