Postgres Pro
Downloads
Home   >   mailing lists

Re: location for pg_default tablespace - Mailing list pgsql-general

From AI Rumman
Subject Re: location for pg_default tablespace
Date
Msg-id 2a7905441001112140w36a2a888v220ad4bb65a84daf@mail.gmail.com
Whole thread Raw
In response to Re: location for pg_default tablespace  (John R Pierce <pierce@hogranch.com>)
Responses Re: location for pg_default tablespace  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view
Thanks.
But actually I want to know that why the value in spclocation is null is pg_tablespace for pg_default.
Moreover, $PGDATA/pg_tblspc has no file.
Could you please tell me why?

On Tue, Jan 12, 2010 at 11:26 AM, John R Pierce <pierce@hogranch.com> wrote:
AI Rumman wrote:
I am new at Postgresql. Previously I used to work with Oracle.
I am surprised to see that the location for pg_default tablespace in my database  for a Postgresql cluster is null.
Could anyone please tell me what is the location of default tablespace in postgresql and how could I find it?

Its the $PGDATA directory.  The location of this varies widely by operating system and postgres distribution.  For instance, the postgres supplied with fedora and redhat linuxes tend to put this in /var/lib/pgsql/data ...   If you build postgres from source on a unix-like system, using full defaults, its probably /usr/local/pgsql/data



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: location for pg_default tablespace
Next
From: Greg Smith
Date:
Subject: Re: location for pg_default tablespace