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

Re: Need suggestions

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-general by date

Next:From: David FetterDate: 2009-06-26 16:35:08
Subject: Re: masking the code
Previous:From: Tom LaneDate: 2009-06-26 13:24:44
Subject: Re: Can't start postgresql 8.3.7

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