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@libertycreek.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@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org]On
> Behalf Of Dave Page
> Sent: Tuesday, February 19, 2002 12:34 AM
> To: 'Brian'; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] backup plugin
>
>
> > -----Original Message-----
> > From: Brian [mailto:brian0@optonline.net]
> > Sent: 19 February 2002 04:32
> > To: pgadmin-hackers@postgresql.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@postgresql.org)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com