| From: | Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com> |
|---|---|
| To: | Jack W <dbdevelop2000(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need suggestions |
| Date: | 2009-06-26 14:55:00 |
| Message-ID: | 92869e660906260755k545ae74cmb0c055885107e9cb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/6/25 Jack W <dbdevelop2000(at)gmail(dot)com>
>
> Maybe for maintainence purpose or schema change. For example as you
> mentioned above, if using several tablespaces located on different hard
> drives. If one hard drive is damaged, the database on that hard drive will
> not be available. How about other databases managed by the same database
> server instance?
>
interesting questions...
If I were you, I would just verify this by creating separate partition,
putting a tablespace there, creating a database in this tablespace,
pgbench'ing this database continuosly, and running
umount --force on the partition.
> I need to shut down all the databases to do mainatainence, right?
>
depends on the kind of maintenance.
--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2009-06-26 16:35:08 | Re: masking the code |
| Previous Message | Tom Lane | 2009-06-26 13:24:44 | Re: Can't start postgresql 8.3.7 |