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 <pie...@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 > > >
