Thread: backup plugin

backup plugin

From

Brian

Date:

19 February 2002, 02:43:50

Any plans to make a backup plugin or option on the admin tool to backup
databases?

Re: backup plugin

From

Dave Page

Date:

19 February 2002, 06:34:24


> -----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.

Re: backup plugin

From

"Mark A. Taff"

Date:

19 February 2002, 07:24:38

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)

Re: backup plugin

From

Salil Mohanty

Date:

19 February 2002, 10:24:18

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

Re: backup plugin

From

Dave Page

Date:

19 February 2002, 10:54:42


> -----Original Message-----
> From: Salil Mohanty [mailto:salilmohanty@yahoo.com]
> Sent: 19 February 2002 12:02
> To: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] backup plugin
>
>
> 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.

Hi Salil,

That's not really our territory - perhaps you should ask on the
pgsql-hackers@postgresql.org list.

Regards, Dave.