Magnus Hagander wrote:
On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote:
OK, W2K3 supports a thing it calls Junctions, which are similar to
symlinks - and PG appears to be using that in this case.
Crisis averted.
I was just going to suggest that. It's a pretty neat feature, but the
supp
On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote:
> Paul Lambert wrote:
> > I've just noticed in the tablespace documentation (Ch 19.6) that PG
> > makes use of symbolic links that point to any user-defined tablespaces
> > but AFAIK W2K3 doesn't support symlinks.
> >
>
> OK, W2K3 supports
Paul Lambert wrote:
I've just noticed in the tablespace documentation (Ch 19.6) that PG
makes use of symbolic links that point to any user-defined tablespaces
but AFAIK W2K3 doesn't support symlinks.
OK, W2K3 supports a thing it calls Junctions, which are similar to
symlinks - and PG appear
Magnus Hagander wrote:
Sounds like the WAL log. It's in the pg_xlog directory - verify that
that's where the data is increasing.
The WAL log is global and not per-tablespace, so it doesn't follow your
tablespaces location.
Nope, it's the files in the pg_tblspc directory on my C drive, they ar
On Thu, 2007-11-22 at 15:26 +0900, Paul Lambert wrote:
> I'm running PG 8.3beta3 on a W2K3 server.
>
> I've set up a tablespace on D drive, with PG itself on C drive and
> loaded a bunch of data into a database to test. The directory I've
> created the tablespace in on D drive grows to 116Mb -
Paul Lambert wrote:
I note however, that the pg_database directory on C drive also grows at
the same time to 116MB.
That was meant to say the pg_tblspc directory.
Both directories (my tablespace and pg_tablespace) contain the same set
of files - same names and sizes, eg both contain a file
I'm running PG 8.3beta3 on a W2K3 server.
I've set up a tablespace on D drive, with PG itself on C drive and
loaded a bunch of data into a database to test. The directory I've
created the tablespace in on D drive grows to 116Mb - which would be
about right for the amount of data I've plugged i