X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DBFBF329F83 for ; Mon, 18 Oct 2004 17:37:57 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39203-04 for ; Mon, 18 Oct 2004 16:37:50 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id E3405329F7D for ; Mon, 18 Oct 2004 17:37:48 +0100 (BST) Received: (qmail 854 invoked by uid 65534); 18 Oct 2004 16:37:45 -0000 Received: from p508BEDEF.dip.t-dialin.net (EHLO [192.168.0.108]) (80.139.237.239) by mail.gmx.net (mp011) with SMTP; 18 Oct 2004 18:37:45 +0200 X-Authenticated: #14269776 Message-ID: <4173F1DC.3080700@gmx.net> Date: Mon, 18 Oct 2004 18:39:56 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.7.3) Gecko/20040910 X-Accept-Language: de-de, en-us, en MIME-Version: 1.0 To: sreejith s Cc: pgsql-sql@postgresql.org Subject: Re: Database backup References: <5d14ecf90410162019443dc355@mail.gmail.com> In-Reply-To: <5d14ecf90410162019443dc355@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/115 X-Sequence-Number: 19218 sreejith s wrote: >How to take Database backup from an application developed in Visual >Basic thats running at Windows Client and Database resting at Linux >Server. THanx > > You wrote a similar question some days ago and mentioned that pg_dump wouldn't work on Windows, so I figure you don't want to let the Linux host computer make the backups but your Windows client. You could go 2 ways. 1) Install pg_dump on your Windows client. Either as PostgreSQL on a CygWin environment or a Windows-native PostgreSQL 7.5 or 8.0 installation. Since you only need pg_dump you wouldn't configure a running PostgreSQL so this should be pretty easy. E.g. the Linux host's IP is 192.168.0.123. Then you can run on Windows : pg_dump --host=192.168.0.123 -U your_username your_database > your_database.sql 2) Let the Linux server do the backup and transfer the resulting backup file as soon as possible to your Windows client. a) The server could push it through SAMBA, SCP or FTP. b) The client could collect all backup files when it gets booted, if the server puts the files in a SAMBA share that the client can mount as network drive or access via FTP. I'd propose you take the alternative 2) b).