| Lists: | pgsql-general |
|---|
| From: | "Bruno Almeida do Lago" <teolupus(at)gmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | More atomic online backup |
| Date: | 2006-01-06 18:40:02 |
| Message-ID: | 43beb970.7f300f5c.583d.1787@mx.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi,
1) I've a pg cluster with 5 databases here. I was wondering if it's possible
to make an online backup of 1 database only, not the entire cluster.
2) Online backups at Oracle are done per tablespace. Do you see any
advantage on this?
Best Regards,
Bruno Almeida do Lago
| From: | Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> |
|---|---|
| To: | Bruno Almeida do Lago <teolupus(at)gmail(dot)com> |
| Subject: | Re: More atomic online backup |
| Date: | 2006-01-07 06:33:04 |
| Message-ID: | Pine.LNX.4.58.0601070123280.11473@eon.cs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Fri, 6 Jan 2006, Bruno Almeida do Lago wrote:
> Hi,
>
> 1) I've a pg cluster with 5 databases here. I was wondering if it's possible
> to make an online backup of 1 database only, not the entire cluster.
>
Check out tool pg_dump or the documents for other options.
> 2) Online backups at Oracle are done per tablespace. Do you see any
> advantage on this?
>
AFAIK, In Oracle, a tablespace is a set of (logically related) files
belongs to one database, so do tablespace backup is a natural option.
PostgreSQL can have several databases sharing one tablespace, which makes
the backup tablespace logically hard to understand, and we don't support
tablespace level backup yet.
Regards,
Qingqing