Re: PostgreSQL Client Aplications ? - Mailing list pgsql-general

From David Siebert
Subject Re: PostgreSQL Client Aplications ?
Date
Msg-id 42B05791.8010108@eclipsecat.com
Whole thread Raw
In response to Re: PostgreSQL Client Aplications ?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton wrote:
> Zlatko Matić wrote:
>
>> Hello.
>>
>> Till now I've been working with Postgres only through pgAdminIII.
>> Postgres is installed on WIndows XP. Now I need to use pg_dumpall. I
>> have found folder with different Postgres aplications, placed in
>> C:\Program Files\PostgreSQL\8.0\bin. When I double-click on any of
>> them, I am prompted for password, but I can't input anything (!?).
>> The cursor is blinking but no text apears as I'm typing. What's wrong
>> ? Is there any other way for starting/executing those programs, such
>> as pg_dumpall ?
>
>
> They're command-line programs. You should run them from a command-prompt
> window.
>
Get a command prompt. If you do not know how go to your start menu and
run cmd
cd to the directory that has the file. If you do not know how to do that
  type CD progra<tab>\posge<tab>\8.0\bin
<tab> means hit the tab key and it will complete the name for you.
then pg_dumpall >backup.sql <enter>
and it should create a file called backup.sql but to be honest I do not
use postgres under Windows. Windows is okay for clients but I find it
messy for servers.



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL Client Aplications ?
Next
From: "Magnus Naeslund(t)"
Date:
Subject: plpgsql cursors, fetching more than one row