[work] [postgis-users] postGIS on windows

[Bresnahan, Mike]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

> > I type
> > pgsql2shp -f ..\dump -h localhost -p 5432 postgis "postgres" WIN1252
- -P
> > somepassword
> >
> > and I get back
> > FATAL: password authentication failed for user "Tara"
> >
> > But I don't have a pg user called "Tara", just postgres...

Try adding "-u postgres" as per the help:

OPTIONS:
  [...]
  -u <user>  Connect to the database as the specified user.
  [...]

For example:

pgsql2shp -f ..\dump -h localhost -u postgres -P <passwd> postgis
<table>


-----BEGIN PGP SIGNATURE-----
Version: PGP Universal 2.8.3
Charset: us-ascii

wsBVAwUBSKTmJh6WPRoYuvd0AQhtZAf+MTq7aMlYnHdd71OQw4bUCPpplW/dQoll
kZD1sXQVBLSRasKjBxEOxFQqAcon4m2QT0lSOvAu6YulHNK6viZUVE5yq2iPEMqP
EREFsbDLKaQp7neSd0dxnW4sc+BV6yOnpfFO+RK1XdNcguFJvqXg6/BJANEHkDgO
46m7sgeGsoAwE+4qG0W368MbPncMaXgQZ1t/TCvaKL8Bo0x3ntd5svldCd+cCYEY
8PfmGqXpK+AKavWRbLGVpJsP7rDWv/FKEVrqwEDoGMLG5xzRMk6PkL5zyH5vt2k0
9QKsix9dmWjsl+rHGtzxvsOn/BF+rzM3sD651DK3fCBLABRxXeg8/Q==
=CFn3
-----END PGP SIGNATURE-----