Restore and backup with VFP

--0-258149754-1219818532=:817
Content-Type: text/plain; charset=us-ascii

Hi
I'm looking for some clues to backup and restore Postgre database from client side using VFP,I found this
http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.p hp

but doesn't work,I got this error

"pg_dump.exe"' is not recognized as an internal or external command,
operable program or batch file.

Thanks




--0-258149754-1219818532=:817
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi<br>I'm looking for some clues to backup and restore Postgre database from client side using VFP,I found this <br><a target="_blank" href="http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.php" rel="nofollow"> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.p hp</a><br><br> but doesn't work,I got this error <br><br> "pg_dump.exe"' is not recognized as an internal or external command,<br>operable program or batch file. <br><br>Thanks
<!-- google_ad_section_end --><br></div></div><br>



</body></html>
--0-258149754-1219818532=:817--
mr_johnmr [ Mi, 27 August 2008 08:28 ] [ ID #1965721 ]

Re: Restore and backup with VFP

On Tue, Aug 26, 2008 at 11:28 PM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> Hi
> I'm looking for some clues to backup and restore Postgre database from
> client side using VFP,I found this
> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.p hp
>
> but doesn't work,I got this error
>
> "pg_dump.exe"' is not recognized as an internal or external command,
> operable program or batch file.

pg_dump.exe is usually located:

C:\Program Files\PostgreSQL\8.X\bin\

You might need to adjust your PATH system variable to see this
directory so that you can execute pg_dump.exe without having to
qualify it with its directory location.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Mi, 27 August 2008 18:19 ] [ ID #1965722 ]

Re: Restore and backup with VFP

--0-936829098-1219857077=:26692
Content-Type: text/plain; charset=us-ascii

Thanks Richard for answer,you're right but I want to backup database
from client side so there is not such file,do I have to copy here?I've
done such thing,it works but backup is saved on client not on server
this can be difficult for big database,I used Firebird RDMS and backups
were done on server side.
Thanks.


----- Original Message ----
From: Richard Broersma <richard.broersma [at] gmail.com>
To: Mr. John <mr_johnmr [at] yahoo.com>
Cc: pgsql-odbc [at] postgresql.org
Sent: Wednesday, August 27, 2008 7:19:27 PM
Subject: Re: [ODBC] Restore and backup with VFP

On Tue, Aug 26, 2008 at 11:28 PM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> Hi
> I'm looking for some clues to backup and restore Postgre database from
> client side using VFP,I found this
> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.p hp
>
> but doesn't work,I got this error
>
> "pg_dump.exe"' is not recognized as an internal or external command,
> operable program or batch file.

pg_dump.exe is usually located:

C:\Program Files\PostgreSQL\8.X\bin\

You might need to adjust your PATH system variable to see this
directory so that you can execute pg_dump.exe without having to
qualify it with its directory location.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug




--0-936829098-1219857077=:26692
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Thanks Richard for answer,you're right but I want to backup database
from client side  so there is not such file,do I have to copy here?I've
done such thing,it works but backup is saved on client not on server
this can be difficult for big database,I used Firebird RDMS and backups
were done on server side.<br>Thanks.</div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Richard Broersma <richard.broersma [at] gmail.com><br>To: Mr. John <mr_johnmr [at] yahoo.com><br>Cc: pgsql-odbc [at] postgresql.org<br>Sent: Wednesday, August 27, 2008 7:19:27 PM<br>Subject: Re: [ODBC] Restore and backup with VFP<br><br>
On Tue, Aug 26, 2008 at 11:28 PM, Mr. John <<a ymailto="mailto:mr_johnmr [at] yahoo.com" href="mailto:mr_johnmr [at] yahoo.com">mr_johnmr [at] yahoo.com</a>> wrote:<br>> Hi<br>> I'm looking for some clues to backup and restore Postgre database from<br>> client side using VFP,I found this<br>> http://archives.postgresql.org/pgsql-odbc/2007-03/msg00060.p hp<br>><br>> but doesn't work,I got this error<br>><br>> "pg_dump.exe"' is not recognized as an internal or external command,<br>> operable program or batch file.<br><br>pg_dump.exe is usually located:<br><br>C:\Program Files\PostgreSQL\8.X\bin\<br><br>You might need to adjust your PATH system variable to see this<br>directory so tha
t you can execute pg_dump.exe without having to<br>qualify it with its directory location.<br><br><br>-- <br>Regards,<br>Richard Broersma Jr.<br><br>Visit the Los
Angeles PostgreSQL Users Group (LAPUG)<br>http://pugs.postgresql.org/lapug<br></div></div></div><br>

</body></html>
--0-936829098-1219857077=:26692--
mr_johnmr [ Mi, 27 August 2008 19:11 ] [ ID #1965723 ]

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:11 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> I want to backup database from
> client side so there is not such file,do I have to copy here?

I think that using the postgresql installation binary, you can choose
to only install the client tools. (i.e. psql.exe, pg_dump.exe ... ) on
your client machine.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Mi, 27 August 2008 19:19 ] [ ID #1965724 ]

Re: Restore and backup with VFP

--0-807104647-1219858052=:96082
Content-Type: text/plain; charset=us-ascii

K,thanks again,I thinks that's the clue,what about backup location on server or on client.



----- Original Message ----
From: Richard Broersma <richard.broersma [at] gmail.com>
To: Mr. John <mr_johnmr [at] yahoo.com>
Sent: Wednesday, August 27, 2008 8:14:25 PM
Subject: Re: [ODBC] Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:10 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:

> I want to backup database from
> client side so there is not such file,do I have to copy here?
I think that using the postgresql installation binary, you can choose
to only install the client tools. (i.e. psql.exe, pg_dump.exe ... ) on
your client machine.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug




--0-807104647-1219858052=:96082
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>K,thanks again,I thinks that's the clue,what about backup location on server or on client.<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Richard Broersma <richard.broersma [at] gmail.com><br>To: Mr. John <mr_johnmr [at] yahoo.com><br>Sent: Wednesday, August 27, 2008 8:14:25 PM<br>Subject: Re: [ODBC] Restore and backup with VFP<br><br>
On Wed, Aug 27, 2008 at 10:10 AM, Mr. John <<a ymailto="mailto:mr_johnmr [at] yahoo.com" href="mailto:mr_johnmr [at] yahoo.com">mr_johnmr [at] yahoo.com</a>> wrote:<br><br>> I want to backup database from<br>> client side  so there is not such file,do I have to copy here?<br>I think that using the postgresql installation binary, you can choose<br>to only install the client tools. (i.e. psql.exe, pg_dump.exe ... ) on<br>your client machine.<br><br><br>-- <br>Regards,<br>Richard Broersma Jr.<br><br>Visit the Los Angeles PostgreSQL Users Group (LAPUG)<br>http://pugs.postgresql.org/lapug<br></div></div></div><br>

</body></html>
--0-807104647-1219858052=:96082--
mr_johnmr [ Mi, 27 August 2008 19:27 ] [ ID #1965725 ]

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:27 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> K,thanks again,I thinks that's the clue,what about backup location on server
> or on client.


I don't understand your question. Would you elaborate a little more?


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Mi, 27 August 2008 19:33 ] [ ID #1965726 ]

Re: Restore and backup with VFP

--0-671641053-1219859010=:45315
Content-Type: text/plain; charset=us-ascii

Database is located on server,when I backup from client computer,the backup is saved on this machine witch means the whole backup file is thrown by network.If there is a huge database,backup time will increase this way,otherwise if database could be saved on server the network traffic will be small and also backup time.

Thanks.



----- Original Message ----
From: Richard Broersma <richard.broersma [at] gmail.com>
To: Mr. John <mr_johnmr [at] yahoo.com>
Cc: pgsql-odbc [at] postgresql.org
Sent: Wednesday, August 27, 2008 8:33:02 PM
Subject: Re: [ODBC] Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:27 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> K,thanks again,I thinks that's the clue,what about backup location on server
> or on client.


I don't understand your question. Would you elaborate a little more?


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug




--0-671641053-1219859010=:45315
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Database is located on server,when I backup from client computer,the backup is saved on this machine witch means the whole backup file is thrown by network.If there is a huge database,backup time will increase this way,otherwise if database could be saved on server the network traffic will be small and also backup time.<br><br>Thanks.<br><br><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Richard Broersma <richard.broersma [at] gmail.com><br>To: Mr. John <mr_johnmr [at] yahoo.com><br>Cc
: pgsql-odbc [at] postgresql.org<br>Sent: Wednesday, August 27, 2008 8:33:02 PM<br>Subject: Re: [ODBC] Restore and backup with VFP<br><br>
On Wed, Aug 27, 2008 at 10:27 AM, Mr. John <<a ymailto="mailto:mr_johnmr [at] yahoo.com" href="mailto:mr_johnmr [at] yahoo.com">mr_johnmr [at] yahoo.com</a>> wrote:<br>> K,thanks again,I thinks that's the clue,what about backup location on server<br>> or on client.<br><br><br>I don't understand your question.  Would you elaborate a little more?<br><br><br>-- <br>Regards,<br>Richard Broersma Jr.<br><br>Visit the Los Angeles PostgreSQL Users Group (LAPUG)<br>http://pugs.postgresql.org/lapug<br></div></div></div><br>

</body></html>
--0-671641053-1219859010=:45315--
mr_johnmr [ Mi, 27 August 2008 19:43 ] [ ID #1965727 ]

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:43 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> Database is located on server,when I backup from client computer,the backup
> is saved on this machine witch means the whole backup file is thrown by
> network.If there is a huge database,backup time will increase this
> way,otherwise if database could be saved on server the network traffic will
> be small and also backup time.

True. Whats the question?


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Mi, 27 August 2008 19:48 ] [ ID #1965728 ]

Re: Restore and backup with VFP

--0-1916715462-1219859999=:20262
Content-Type: text/plain; charset=us-ascii

Can I backup from client machine and save file direct to server to avoid network traffic ?



----- Original Message ----
From: Richard Broersma <richard.broersma [at] gmail.com>
To: Mr. John <mr_johnmr [at] yahoo.com>
Cc: pgsql-odbc [at] postgresql.org
Sent: Wednesday, August 27, 2008 8:48:51 PM
Subject: Re: [ODBC] Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:43 AM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> Database is located on server,when I backup from client computer,the backup
> is saved on this machine witch means the whole backup file is thrown by
> network.If there is a huge database,backup time will increase this
> way,otherwise if database could be saved on server the network traffic will
> be small and also backup time.

True. Whats the question?


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc




--0-1916715462-1219859999=:20262
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Can I backup from client machine and save file direct to server to avoid network traffic ?<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Richard Broersma <richard.broersma [at] gmail.com><br>To: Mr. John <mr_johnmr [at] yahoo.com><br>Cc: pgsql-odbc [at] postgresql.org<br>Sent: Wednesday, August 27, 2008 8:48:51 PM<br>Subject: Re: [ODBC] Restore and backup with VFP<br><br>
On Wed, Aug 27, 2008 at 10:43 AM, Mr. John <<a ymailto="mailto:mr_johnmr [at] yahoo.com" href="mailto:mr_johnmr [at] yahoo.com">mr_johnmr [at] yahoo.com</a>> wrote:<br>> Database is located on server,when I backup from client computer,the backup<br>> is saved on this machine witch means the whole backup file is thrown by<br>> network.If there is a huge database,backup time will increase this<br>> way,otherwise if database could be saved on server the network traffic will<br>> be small and also backup time.<br><br>True.  Whats the question?<br><br><br>-- <br>Regards,<br>Richard Broersma Jr.<br><br>Visit the Los Angeles PostgreSQL Users Group (LAPUG)<br>http://pugs.postgresql.org/lapug<br><br>-- <br>Sent via pgsql-odbc
mailing list (<a ymailto="mailto:pgsql-odbc [at] postgresql.org" href="mailto:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresql.org</a>)<br>To make changes to your
subscription:<br>http://www.postgresql.org/mailpref/pgsql-odbc<br></div></div></div><br>

</body></html>
--0-1916715462-1219859999=:20262--
mr_johnmr [ Mi, 27 August 2008 19:59 ] [ ID #1965729 ]

Re: Restore and backup with VFP

On 27/08/2008 18:59, Mr. John wrote:
> Can I backup from client machine and save file direct to server to avoid
> network traffic ?

If you have SSH available, you could use that to run the backup on the
server...

Ray.

------------------------------------------------------------ ------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod [at] iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------ ------

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Rod [ Mi, 27 August 2008 20:30 ] [ ID #1965730 ]

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 12:43 PM, Mr. John <mr_johnmr [at] yahoo.com> wrote:
> Database is located on server,when I backup from client computer,the backup
> is saved on this machine witch means the whole backup file is thrown by
> network.If there is a huge database,backup time will increase this
> way,otherwise if database could be saved on server the network traffic will
> be small and also backup time.

If you save database dump on your server, it is also known as "not a backup".

- Adam

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Adam M [ Do, 28 August 2008 00:22 ] [ ID #1965987 ]
Datenbanken » gmane.comp.db.postgresql.odbc » Restore and backup with VFP

Vorheriges Thema: Need a developer contact
Nächstes Thema: Fw: Restore and backup with VFP