| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Anton Melser *EXTERN*" <melser(dot)anton(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "stopping" a single database in a cluster |
| Date: | 2006-11-10 14:06:59 |
| Message-ID: | 52EF20B2E3209443BC37736D00C3C1380B5F5189@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Is it possible to stop a single database, like it is with Oracle? Our
> oracle admin asked this for FS backups, if there are 3 dbs (in
> separate tablespaces) then there seems no reason why this couldn't be
> possible... is it possible?
No, this is not possible, because they are all serverd by the same
server process.
You can, however, do an online backup while the database is running.
This is essentially a filesystem backup, and you issue a certain
SQL statement before and after the backup.
> ps. If this isn't possible, what experiences do people have with
> running several postgres instances on a single machine?
It is called 'cluster', not 'instance'.
I have very good experiences.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2006-11-10 14:15:48 | Re: tsearch2() with data from other table |
| Previous Message | Shane Ambler | 2006-11-10 13:56:03 | Re: Database Mirroring Solution |