Thread: Clustering

Joseph M. Day wrote:

> I am trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I
> am trying to find  the equivalent of Full / Incremental / Differential
> backups. It looks like pg_dump is the equivalent of a full backup, but
> how do I keep the equivalent of a Incremental, or Differential backup.
>
> To keep the same functionality, I will need a full backup once a week,
> and a differential once a day.


If you are using >8.0 You could use the PITR functionality.

Sincerely,

Joshua D. Drake

>
> Thanks,
>
> Joe,
>
>
> --------------------------------------------
> Joseph M. Day
> Global Innovative Solutions
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

"Joseph M. Day" <jday@gisolutions.us> writes:
> It looks like pg_dump is the equivalent of a full backup, but
> how do I keep the equivalent of a Incremental, or Differential backup.

The only built-in mechanism for incremental backups at the moment is
archiving WAL logs via PITR.  See
http://www.postgresql.org/docs/8.0/static/backup-online.html

> To keep the same functionality, I will need a full backup once a week,
> and a differential once a day.

You might consider rsync'ing the database, though I'm not sure what sort
of performance that will give.

            regards, tom lane

On Wed, Mar 23, 2005 at 05:12:37PM -0300, Joao Daniel wrote:
> Hy guys,  where can I find some information over clustering postgreSQL ?

And by "clustering" you mean what, precisely?  If you mean "many
machines with one postmaster" the really short version is that you
can't really do this today.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
        --George Orwell