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

[Mark Cave-Ayland]

> 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,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

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

http://www.webbased.co.uk  
http://www.infomapper.com
http://www.swtc.co.uk 

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
person.