Re: backup database by pg_dump

Are you sure your working directory is what you think it is?  You may=20=20
want to specify a full path for the output, and see if that works.  I=20=20
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=20=20
> 5432 -U quangvu -C BENET2 > a.sql
>
> or
>
> 2. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p=20=20
> 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 =3D "C:\Program Files\PostgreSQL\8.1\bin\pg_dump"
> Dim para As String =3D " -h 192.168.77.117 -p 5432 -U quangvu -C=20=20
> 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=20=20
> just 2=A2/min with Yahoo! Messenger with Voice.

Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938