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

Re: Restore and backup with VFP

On Tue, Aug 26, 2008 at 11:28 PM, Mr. John 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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
To: Mr. John
Cc: pgsql-odbc@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 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

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:11 AM, Mr. John 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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
To: Mr. John
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 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

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:27 AM, Mr. John 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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
To: Mr. John
Cc: pgsql-odbc@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 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

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 10:43 AM, Mr. John 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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
To: Mr. John
Cc: pgsql-odbc@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 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@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

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

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

Re: Restore and backup with VFP

On Wed, Aug 27, 2008 at 12:43 PM, Mr. John 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc