Thread: Using pg_dump through odbc
Hello, I am using Delphi with psqlodbc and postgresql. The problem is that I want the users to be able to backup the database from client stations by pressing a button. So my question is how can I run a pg_dump or psql command from delphi through odbc and get back the dumped data ? Any ideea or maybe a workaround? Thank you, Adrian Din, Om Computer & Software
Simple method would be to load pg_dump on their machine and shell to it. PGadminIII appears to do this and it runs well going from postgres on linux to a XP machine. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Din Adrian Sent: Tuesday, March 01, 2005 8:20 AM To: pgsql-odbc@postgresql.org Subject: [ODBC] Using pg_dump through odbc Hello, I am using Delphi with psqlodbc and postgresql. The problem is that I want the users to be able to backup the database from client stations by pressing a button. So my question is how can I run a pg_dump or psql command from delphi through odbc and get back the dumped data ? Any ideea or maybe a workaround? Thank you, Adrian Din, Om Computer & Software ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Yes, this could be a solution, but I don't want to leave another file (pg_dump.exe or maybe to pg_restore to) on client machines ... If I can't find another way I think this will be the solution! Thank you, -- Adrian Din, Om Computer & Software On Tue, 01 Mar 2005 08:41:26 -0500, Joel Fradkin <jfradkin@wazagua.com> wrote: > Simple method would be to load pg_dump on their machine and shell to it. > PGadminIII appears to do this and it runs well going from postgres on > linux > to a XP machine. > > Joel Fradkin > Wazagua, Inc. > 2520 Trailmate Dr > Sarasota, Florida 34243 > Tel. 941-753-7111 ext 305 > jfradkin@wazagua.com > www.wazagua.com > Powered by Wazagua > Providing you with the latest Web-based technology & advanced tools. > C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc > This email message is for the use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized > review, > use, disclosure or distribution is prohibited. If you are not the > intended > recipient, please contact the sender by reply email and delete and > destroy > all copies of the original message, including attachments. > > > -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Din Adrian > Sent: Tuesday, March 01, 2005 8:20 AM > To: pgsql-odbc@postgresql.org > Subject: [ODBC] Using pg_dump through odbc > > Hello, > I am using Delphi with psqlodbc and postgresql. > The problem is that I want the users to be able to backup the database > from client stations by pressing a button. So my question is how can I > run > > a pg_dump or psql command from delphi through odbc and get back the > dumped data ? > Any ideea or maybe a workaround? > > Thank you, > Adrian Din, > Om Computer & Software > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > >
Just include the win32 versions of pg_dump/restore from the win32 Postgresql 8.x release, then use the createprocess api commad to execute the pg_dump.exe.
By using createprocess you can pipe the output of the exe into your Dephi apps window. That's all PG admin 3 does.
Do a search on google on createprocess and piping Standard Output.
Tony Caduto
Senior Programmer/Analyst
| Din Adrian <adrian.din@easynet.ro> Sent by: pgsql-odbc-owner@postgresql.org 03/01/2005 07:19 AM |
|
Hello,
I am using Delphi with psqlodbc and postgresql.
The problem is that I want the users to be able to backup the database
from client stations by pressing a button. So my question is how can I run
a pg_dump or psql command from delphi through odbc and get back the
dumped data ?
Any ideea or maybe a workaround?
Thank you,
Adrian Din,
Om Computer & Software
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Yes, I think this is the only solution - to use the pg_dump.exe in my application ... I have allready started to do so ... Thank You, -- Adrian Din, Om Computer & Software On Tue, 1 Mar 2005 11:46:18 -0600, <anthony.caduto@micorp.com> wrote: > Just include the win32 versions of pg_dump/restore from the win32 > Postgresql 8.x release, then use the createprocess api commad to execute > the pg_dump.exe. > By using createprocess you can pipe the output of the exe into your Dephi > apps window. That's all PG admin 3 does. > Do a search on google on createprocess and piping Standard Output. > > > > Tony Caduto > Senior Programmer/Analyst > > > > > Din Adrian <adrian.din@easynet.ro> > Sent by: pgsql-odbc-owner@postgresql.org > 03/01/2005 07:19 AM > > To > pgsql-odbc@postgresql.org > cc > > Subject > [ODBC] Using pg_dump through odbc > > > > > > > Hello, > I am using Delphi with psqlodbc and postgresql. > The problem is that I want the users to be able to backup the database > from client stations by pressing a button. So my question is how can I > run > a pg_dump or psql command from delphi through odbc and get back the > dumped data ? > Any ideea or maybe a workaround? > > Thank you, > Adrian Din, > Om Computer & Software > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > >