Skip site navigation (1) Skip section navigation (2)

Re: backup plugin

From: Salil Mohanty <salilmohanty(at)yahoo(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: backup plugin
Date: 2002-02-19 12:01:52
Message-ID: 20020219120152.20438.qmail@web11802.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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" <mark(at)libertycreek(dot)net> 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: pgadmin-hackers-owner(at)postgresql(dot)org
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org]On
> Behalf Of Dave Page
> Sent: Tuesday, February 19, 2002 12:34 AM
> To: 'Brian'; pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: [pgadmin-hackers] backup plugin
> 
> 
> > -----Original Message-----
> > From: Brian [mailto:brian0(at)optonline(dot)net]
> > Sent: 19 February 2002 04:32
> > To: pgadmin-hackers(at)postgresql(dot)org
> > 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
> majordomo(at)postgresql(dot)org)
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-19 12:01:57
Subject: Re: Hebrew support
Previous:From: Jean-Michel POUREDate: 2002-02-19 11:50:21
Subject: Re: Hebrew support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group