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

PG equivalent of "mysqlhotcopy"?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: PG equivalent of "mysqlhotcopy"?
Date: 2009-07-30 13:34:46
Message-ID: e373d31e0907300634pcea4f82h9e164e73ebe49548@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Although mysqldump is the official solution, there's a fabulous perl
script "mysqlhotcopy" that simply copies the data from MySQL tables in
folders and restoring the data is as simple as copying the files back
to their /var/lib/mysql/data location.

I know about pg_dumpall, which creates a humongous SQL file, but is
there something equivalent in the postgresql world, like a
"pgsqlhotcopy" which copies data folders in a similar way as
mysqlhotcopy?

Thanks!

Responses

pgsql-general by date

Next:From: Phoenix KiulaDate: 2009-07-30 13:36:39
Subject: Re: Slony and local machine slave..(supernewbie question)
Previous:From: Sam MasonDate: 2009-07-30 13:24:38
Subject: Re: Can't execute function

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