[PLUG] MySQL v. PostgreSQL -- perhaps an easy answer

[Jeme A Brelin]

On Wed, 14 Jan 2004, Ian Burrell wrote:
> On Wed, Jan 14, 2004 at 02:39:22PM -0800, Jeme A Brelin wrote:
> >
> > Which is easier for backups?
> >
> > I assume that, with either one, you just want to stop the dbms and
> > dump to a file and back that up.  Am I wrong?
> >
> > I guess this is where y'all tell me I should be using LVM?
>
> The standard way to backup PostgreSQL is dump it with the pg_dump
> command.  This produces a SQL script that will recreate the database
> when run with the pg_sql interpreter.

Right.  I'm familiar with this.  I know MySQL works the same way.

> The on-disk database files can be copied to make a backup only if the
> database server is stopped.

Again, the same as MySQL, from my knowledge.

> Unless you have a really big database, dumps work fine.

What's "really big" in this context?

J.
-- 
   -----------------
     Jeme A Brelin
    jeme at brelin.net
   -----------------
 [cc] counter-copyright
 http://www.openlaw.org