On 11/11/2010 08:15 PM, Guillaume Lelarge wrote:
I would like to create a specific database on a another location (not in
"data_directory = '/var/lib/postgresql/8.3/main'" ). I was wondering if
I have to run
initdb -D /other/path/
of if there is another way
To create another database in another location, you first need to create
a tablespace, and then create a database in that tablespace. For
example, in psql:
CREATE TABLESPACE otherlocation LOCATION '/some/specific/directory';
CREATE DATABASE newdb TABLESPACE otherlocation;
Hey thanks again, that did the job :)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
