| From: | Kevin Brannen <kevinb(at)nurseamerica(dot)net> |
|---|---|
| To: | "Michael A(dot) Schulte" <michael(dot)schulte(at)sun(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: psql in Batch mode and passwords? |
| Date: | 2002-07-09 15:22:35 |
| Message-ID: | 3D2AFFBB.6010801@nurseamerica.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Michael A. Schulte wrote:
> Hi,
>
> does anyone have an idea how to convince psql
> to accept a password that is passed during startup
> of psql in the command line?
>
> I don't want to modify pg_hba.conf so that it
> is open for everyone so I have inserted:
>
> local all trust
> host all 129.157.0.0 255.255.0.0 password
>
>
> I look for something like:
> psql -h somehost -a dash anonymous/anonym
> where there exists a postgres user named "anonymous"
> and the password is anonym.
Try (assume a sh or ksh shell):
PGPASSWORD=anonym psql -h somehost -U anonymous -a dash
HTH,
Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefano Coletta | 2002-07-09 15:23:33 | R: How robust is postgre in case of power failure? |
| Previous Message | Stefano Coletta | 2002-07-09 15:19:33 | R: psql in Batch mode and passwords? |