Re: old database dump.

Alternatively you can login with your password as
normal and then once in psql use the '\i filename'
command to read in your backup.

E.g.,
psql dbname
Password:
dbname=# \i database.bak
dbname=# \q

Regards - Paul Breen

--- Jeff Frost <jeff@frostconsultingllc.com> wrote:

> Use the .pgpass file.
>
> On Thu, 1 Dec 2005, Theo Galanakis wrote:
>
> > database.bak prompts me for a password. How can I
> run the psql command
> > without being prompted for a password. The
> password prompt and < command
>
> --
> Jeff Frost, Owner     <jeff@frostconsultingllc.com>
> Frost Consulting, LLC
> http://www.frostconsultingllc.com/
> Phone: 650-780-7908    FAX: 650-649-1954
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>