From: | James David Smith <james(dot)david(dot)smith(at)gmail(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Tablespaces |
Date: | 2013-09-24 11:43:52 |
Message-ID: | CAMu32AD7qhb5sMq=oSZJtZVnMVfHaRcc==DNsjqQ5o4PFC9A6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for the advice guys. I've seemed to get it working now. It'd
like to provide an explanation as to how, but I've tried so many
things that I'm a bit lost.... but all is working fine now! Thanks
again.
On 24 September 2013 12:40, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:
> On Mon, Sep 23, 2013 at 5:50 PM, James David Smith
> <james(dot)david(dot)smith(at)gmail(dot)com> wrote:
>
>> SELECT relname FROM pg_tablespace;
>>
>
> Uh? There is no relname in pg_tablespace:
> http://www.postgresql.org/docs/current/static/catalog-pg-tablespace.html
>
>> But when they run a command such as this, the new database is still
>> made in the default directory, rather than the persona folder:
>>
>> CREATE DATABASE testing(i int)
>>
>> Would appreciate any thoughts and guidance please. The aim is to keep
>> everyone's work in their own folders.
>
> According to the documentation
> (http://www.postgresql.org/docs/9.2/static/runtime-config-client.html)
> if the tablespace name does not match any existing table space
> PostgreSQL will default to default (i.e., will create objects in the
> default tablespace). Moreover: "This variable is also not used when
> creating databases. By default, a new database inherits its tablespace
> setting from the template database it is copied from."
>
>
> Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Thara Vadakkeveedu | 2013-09-24 13:53:54 | Re: Uninstall postgresql 9.2 on red hat linux |
Previous Message | Luca Ferrari | 2013-09-24 11:40:16 | Re: Tablespaces |