dbTalk Databases Forums  

[BUGS] backup database by pg_dump

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] backup database by pg_dump in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default [BUGS] backup database by pg_dump - 05-12-2006 , 08:35 AM






--0-2033774007-1147417877=:91962
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-2033774007-1147417877=:91962
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Can you help me?</div> <div>&nbsp;</div> <div>To back up database, I use pg_dump command as normal in command prompt</div> <div>&nbsp;</div> <div>1. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 &gt; a.sql</div> <div>&nbsp;</div> <div>or </div> <div>&nbsp;</div> <div>2. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C -f aaa.zzz BENET2</div> <div>&nbsp;</div> <div>-----&gt; It's OK</div> <div>&nbsp;</div> <div>But, now i want to use in VBNET code, so I try:</div> <div>&nbsp;</div> <div>Dim str As String = "C:\Program Files\PostgreSQL\8.1\bin\pg_dump"</div> <div>Dim para As String = " -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 &gt; a.sql "</div> <div>&nbsp;</div> <div>Process.Start(str, para)</div> <div>&nbsp;</div> <div>It run but I can't see the result in my directory? What wrong?</div> <div>&nbsp;</div> <div>Thanks</div><p>
<hr size=1>Love cheap thrills? Enjoy PC-to-Phone <a href="http://us.rd.yahoo.com/mail_us/taglines/postman9/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com/"> calls to 30+ countries</a> for just 2¢/min with Yahoo! Messenger with Voice.
--0-2033774007-1147417877=:91962--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.