Re: Cluster / Tablespace ? - Mailing list pgsql-novice

From Andreas Wenk
Subject Re: Cluster / Tablespace ?
Date
Msg-id 49917C8E.6070408@netzmeister-st-pauli.de
Whole thread Raw
In response to Cluster / Tablespace ?  ("Nico Callewaert" <callewaert.nico@telenet.be>)
List pgsql-novice
-----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-----

pgsql-novice by date:

Previous
From: "Nico Callewaert"
Date:
Subject: Cluster / Tablespace ?
Next
From: Carol Walter
Date:
Subject: Re: Cluster / Tablespace ?