Re: Restore and backup with VFP

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(dot)broersma(at)gmail(dot)com>
To: Mr. John <mr_johnmr(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)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(dot)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