Re: backup database by pg_dump

Are you sure your working directory is what you think it is? You may
want to specify a full path for the output, and see if that works. I
suspect your working directory is not set correctly.

On May 12, 2006, at 3:11 AM, Thanh Thao Nguyen wrote:

> 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.

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938