Kshipra wrote:
>
> hello all,
> I would like to mention something in this regard.
> I have executed all the commands given here in the same order, but what the
> auther is saying that after insert fails whatever u have inserted rolls back,
> this is not the case .
> as all of us knows Postgre wor
t to take the database offline or save to a temporary
file, I'd suggest something like "mt rewind ; pg_dump -o -z >
/dev/tape". There is a new pg_dump/pg_restore out in beta now as
pg_backupXXX_latest on the PostgreSQL site which appears to be neater
than the dumper supplied in the PostgreSQL tarball.
Sevo
--
Sevo Stille
[EMAIL PROTECTED]
Chris Bitmead wrote:
> Actually that is the exact reason you _don't_ want to be based in the
> USA. Do you really want Postgres to be breaking new ground in the
> courts? The USA is at the leading edge of lame new legislation. If the
> postgresql licence is locked into Virginia law forever, (beca
Ron Peterson wrote:
>
> NEERAJ BANSAL wrote:
> >
> > Hi,
> >
> > How do you find that how much storage the data in the database or tables
> > is taking in bytes or any other format???
> > Is there any command which tells you this???
>
> ls -l /usr/local/pgsql/data/base
Which would give you the
n top of XFS)
are bound to arrive there as well, sooner or later.
Sevo
--
Sevo Stille
[EMAIL PROTECTED]
Dan Reish wrote:
>
> Does anyone know where I might find documentation on creating R-tree indexes
> in PostgreSQL? The docs included in the standard distribution don't seem to
> even mention the existence of R-trees.
There is some brief mention as to bugs in R-Trees in some part of the
document
