Re: Cluster / Tablespace ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nico Callewaert schrieb:
> Hi,
>
> Maybe my question is too simple...
> Anyway, I'm coming from a Firebird background where we just talk about a
> database file. I read that PostgreSQL is working with a database
> cluster. I don't know exactly the meaning of that and I didn't find a
> well explaining answer on the internet.
Hi,

a database cluster can have more than one database. You build a cluster with initdb. In
this cluster you create databases with CREATE DATABASE.

http://www.postgresql.org/docs/8.3/interactive/app-initdb.html

And is there a difference
> between a cluster and a tablespace ?

Tablespaces are the possibility to define a location where your database objects are
placed on your hd.

http://www.postgresql.org/docs/8.3/interactive/manage-ag-tablespaces.html

> Many thanks in advance, Nico

For more info refer to the documentation ;-)

http://www.postgresql.org/docs/

Cheers

Andy

- ----------------------------------
St.Pauli - Hamburg - Germany

Andreas Wenk
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJkXyOVa7znmSP9AwRAh7aAJ9eogTmKxspojfSmjzpre4uxGIKvgCfT8vg
cRCSl4AJ/FyHNiCywCUwHQE=
=7VVl
-----END PGP SIGNATURE-----