How to use pg_dump to backup a database?

[osman7king]

I want to backup and restore a database by comand line,
Acually I successed to do that but I have a problem in spacial status:

the database name: swt
schema name: public
the owner of this DB: swt_user

I executed the following comand, it worked and the backup done:

>pg_dump.exe -i -h localhost -p 5432 -U swt_user -F c -v -f d:\pg_backup\swt.backup -n public -w swt

although the command structure doesn't require the database name (swt), but it didn't work without it.


My issues:
1. I want to provide the password of the connected user
in this command, like following:
>pg_dump.exe -i -h localhost -p 5432 -U swt_user -F c -v -f d:\pg_backup\swt.backup -n public -W ******(the password)

because I want to execute the command automaticly,
is it possible?

2. I want to connect by the superuser (postgres) and
provide different schema names from different
databases.

3. Sometimes, when I execute the same command, it
doesn't work(access is denied) and I get an error
message that says:
(pg_dump is not a valid win32 application).

may someone help me and give me the optimal command
for each issues?

Best Regards
Osman.

[rski]

Ad 1.
No, but you can create file .pgpass with all needed information
http://www.postgresql.org/docs/curre...pq-pgpass.html

You should also ensure that postgres requires password for a user, see here
http://www.postgresql.org/docs/curre...ntication.html


Ad 2. Not sure what do you mean. To connect as a superuser you can use

-U postgres
 

parameter

Ad 3.
Some windows issue? I'm not good at windows.