Thread: Restore and backup with VFP

On Tue, Aug 26, 2008 at 11:28 PM, Mr. John <mr_johnmr@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.php
>
> 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

On Wed, Aug 27, 2008 at 10:11 AM, Mr. John <mr_johnmr@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

On Wed, Aug 27, 2008 at 10:27 AM, Mr. John <mr_johnmr@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

On Wed, Aug 27, 2008 at 10:43 AM, Mr. John <mr_johnmr@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

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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On Wed, Aug 27, 2008 at 12:43 PM, Mr. John <mr_johnmr@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