Re: Pg_dump and password

From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
To: "Pleyer, Walter" <walter(dot)pleyer(at)lfrz(dot)at>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Pg_dump and password
Date: 2008-02-08 09:01:07
Message-ID: BLU110-W23B74BAA7FA18874BCE22FA92F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> From: Walter(dot)Pleyer(at)lfrz(dot)at> To: pgsql-admin(at)postgresql(dot)org> Date: Fri, 8 Feb 2008 09:04:46 +0100> Subject: [ADMIN] Pg_dump and password> > Hi Folks!> > Is it possible to call pg_dump not only with -U username but also with the user's password?

Yes you can use -W option along with -U option while calling pg_dump. -W would enforce password prompt, once authenticated it would take the dump.> > Walter> > > > > ---------------------------(end of broadcast)---------------------------> TIP 2: Don't 'kill -9' the postmaster
- Vishal
_________________________________________________________________
Tried the new MSN Messenger? It’s cool! Download now.
http://messenger.msn.com/Download/Default.aspx?mkt=en-in

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message n0g0013 2008-02-08 11:32:21 Re: Postgres 8.2 install on solaris 10
Previous Message Milen A. Radev 2008-02-08 08:47:58 Re: Pg_dump and password