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

Re: backup plugin

From: "Mark A(dot) Taff" <mark(at)libertycreek(dot)net>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, "'Brian'" <brian0(at)optonline(dot)net>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: backup plugin
Date: 2002-02-19 09:19:14
Message-ID: LOBBLBDHPFLLCMMKPMFKAEDGDDAA.mark@libertycreek.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
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)


In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-19 09:20:29
Subject: Re: Unicode/Multibyte/Hebrew/Japanese
Previous:From: Dave PageDate: 2002-02-19 09:16:38
Subject: Re: Hebrew support

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