backup database by pg_dump

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.

Responses

Browse pgsql-bugs by date

  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