Thread: PostgreSQL Client Aplications ?
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 ?
Thanks.
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. -- Richard Huxton Archonet Ltd
On Wed, 2005-06-15 at 10:55, 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. Assuming they are starting their own window here, it is NORMAL for secure applications to NOT echo back output when you are typing in your keyboard. This lack of feedback is for security reasons. It should be accepting the password. Does the terminal respond when you hit enter?
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.