Hi Dave, Is there any facility currently in postgresql to take backup of the WAL logs? or differential backup? Or is work on this thing in progress?
Salil. --- "Mark A. Taff" <[EMAIL PROTECTED]> wrote: > Brian, > If you install OpenSHH (an open-source SSH client), > you can access the > Linux command prompt from a DOS prompt. You can > then run any of the Linux > command line interfaces to PostgreSQL, including > psql, pg_dump, etc. This > works well for me if I just need quick access. > However, for something as > important as backups, running cron jobs (and > checking from time to time to > make sure your data was actually backed up in a > recoverable format!) is a > far safer approach. > > Regards, > > Mark Taff > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > Behalf Of Dave Page > Sent: Tuesday, February 19, 2002 12:34 AM > To: 'Brian'; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] backup plugin > > > > -----Original Message----- > > From: Brian [mailto:[EMAIL PROTECTED]] > > Sent: 19 February 2002 04:32 > > To: [EMAIL PROTECTED] > > Subject: [pgadmin-hackers] backup plugin > > > > > > Any plans to make a backup plugin or option on the > admin tool > > to backup databases? > > Brian, > > I have no intention of *ever* implementing such a > plugin. The first time > someone's backup failed I'd be directly in the > firing line :-). > > Seriously though, you should make use of > pg_dump/pg_dumpall on the server > end to perform your backups (I run pg_dumpall from a > script fired by cron, > which then also dumps the whole system to DAT tape). > It will always be the > most reliable method of backup, and reliability is > by far the most important > thing with backups. > > Regards, Dave. > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com
