http://www.postgresql.org/docs/8.3/static/runtime-config-client.html#GUC-TEMP-TABLESPACES
P Adji wrote:
sorry my mistake, it should be temp_tablespaces. I use PG 8.3.0-1
> Date: Thu, 15 Jan 2009 09:00:09 -0800
> From: [email protected]
> To: [email protected]
> Subject: Re: [postgis-users] postgre tmp_tablespace
>
> What version of PostgreSQL are you using? I don't see that variable
in 8.3.
> postgis=# show tmp_tablespace;
> ERROR: unrecognized configuration parameter "tmp_tablespace"
>
> I would imagine it's the directory location for temporary files.
According to the 8.3 docs:
> "Temporary files (for operations such as sorting more data than can
fit in memory) are created within
> PGDATA/base/pgsql_tmp, or within a pgsql_tmp subdirectory of a
tablespace directory if a tablespace other than
> pg_default is specified for them. The name of a temporary file has
the form pgsql_tmpPPP.NNN, where PPP is the PID of
> the owning backend and NNN distinguishes different files of that
backend."
>
> Cheers,
> Kevin
>
>
> P Adji wrote:
> > Dear all,
> > sorry if it is not postgis related.
> >
> > whats the variable tmp_tablespace in postgre is for ?
> >
> > thanks guys
> >
> >
------------------------------------------------------------------------
> > Share your beautiful moments with Photo Gallery. Windows Live Photo
> > Gallery <http://get.live.com/photogallery/overview>
> >
> >
> >
------------------------------------------------------------------------
> >
> > _______________________________________________
> > postgis-users mailing list
> > [email protected]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------------------------------------------------
See all the ways you can stay connected to friends and family
<http://www.microsoft.com/windows/windowslive/default.aspx>
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
