Re: pg_dumpall

On 16 Jun 2005 at 11:36, Zlatko Matic wrote:

> Ok. but I have a problem. When i double-click, a black window appears,
> prompting for password. But I can't input anything! Cursor is just
> blinking. I'm typing and nothing apears. If I click enter, pg_dumpall
> just closes... Postgres 8.02 is installed on Windows XP...

Don't double-click on the application....open a console window first by
going to Start -> All programs -> Accessiories -> Command prompt,
then run it by typing (and substituing as necessary for the bits in <...>):

  c:\<path to installation>\bin\pg_dumpall <options>

I'd recommend including the option -U <Postgres user> which makes
the connection as that user - otherwise it tries to connect as the
Windows user under which you're current logged into the machine,
and if there is no corresponding user in Postgres the connection will
fail.

--Ray.