Re: database backup ???
On Tue, Jul 02, 2002 at 10:00:01PM -0700, Eric G. Miller wrote:
> On Tue, Jul 02, 2002 at 10:58:22PM -0500, Michael D. Schleif wrote:
> >
> > Yes, I've read recent posts on backups and that tar is my friend ;>
> >
> > However, I'm interested in what debian users are doing to backup
> > databases, such as mysql and postgresql?
>
> PostgreSQL can dump live databases consistently. That's what you
> should back up. Otherwise, you *have* to shut down the database
> server to get a consistent backup. I don't know about MySQL...
That would be using pg_dump in the postgresql case, yes? When I used to
work with postgresql, we used to backup and restore using pg_dump all
the time. If you're short of space, you can even gzip the dump file,
since a lot of it is fairly repetitive plain text.
- Chris
--
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Reply to: