From: | Thanh Thao Nguyen <mtmnthao(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | backup database by pg_dump |
Date: | 2006-05-12 07:11:17 |
Message-ID: | 20060512071117.92176.qmail@web54314.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Can you help me?
To back up database, I use pg_dump command as normal in command prompt
1. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 > a.sql
or
2. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C -f aaa.zzz BENET2
-----> It's OK
But, now i want to use in VBNET code, so I try:
Dim str As String = "C:\Program Files\PostgreSQL\8.1\bin\pg_dump"
Dim para As String = " -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 > a.sql "
Process.Start(str, para)
It run but I can't see the result in my directory? What wrong?
Thanks
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.
From | Date | Subject | |
---|---|---|---|
Next Message | Jacques Gollion | 2006-05-12 07:59:06 | BUG #2433: Using pg_dump in a .bat : Cannot avoid asking for user Name and Password |
Previous Message | Simon Riggs | 2006-05-12 07:04:20 | Re: BUG #2428: ERROR: out of memory, running INSERT SELECT |