[postgis-users] Command line keeps requesting a user and passwordwhen entering a command

Mark Cave-Ayland m.cave-ayland at webbased.co.uk
Mon Mar 13 06:32:59 PST 2006

> From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Steven
De Vriendt
> Sent: 13 March 2006 13:11
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Command line keeps requesting a user and
passwordwhen entering a command
> Hi list,
> Is this a normal thing ? I've created a user postgres when installing
postgresql with
> all rights and with the option to remember the password. When using the
command line in
> postgis ex:
> psql [dbname] 
> I have to specify the username
> psql [dbname] -U [username]
> followed by the password
> and that for every command I'd want to use..
> Can I just make a administrator account and password ?

Hi Steven,

What you need is to setup a .pgpass file - see
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html for more
information. You may also find the section at
http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html on
environment variables helpful.

Kind regards,


WebBased Ltd
17 Research Way

T: +44 (0)1752 797131
F: +44 (0)1752 791023


This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other

More information about the postgis-users mailing list