[postgis-users] pgsql2shp password

[Michael Fuhr]

On Fri, Jul 28, 2006 at 07:24:19AM -0700, Amit Kulkarni wrote:
> Doesn't this utility usually need a password?

Whether you need to enter a password or not depends on the server
configuration.  See "Client Authentication" in the PostgreSQL
documentation for server-side configuration and see a couple of the
libpq chapters for client-side environment variables and password
files.

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html

> I have been using this as
> 
> pgsql2shp -upostgres -f dump.shp database table
> 
> and it works fine (running on localhost). But it doesn't ask me for a
> password?

Do you get prompted when you connect with psql?  What happens if
you do the following?

psql -U postgres database

-- 
Michael Fuhr