Re: [ADMIN] Y2K test

2000-01-06 Thread neko
On Mon, 20 Dec 1999, Karin Probost wrote: > vacuum; > NOTICE: Rel pg_type: TID 1/63: InsertTransactionInProgress 319103 - > can't shrink relation > > What do the messages mean ? This are not error messages. You can ignore them. The vacuum have to expunge deleted rows, rollbacked inserts or updat

[ADMIN] missing headers

2000-01-04 Thread neko
Hi! The headers installation is still incomplet maybe... /usr/include/pgsql/commands/trigger.h:12: access/tupdesc.h: No such file or directory /usr/include/pgsql/commands/trigger.h:13: access/htup.h: No such file or directory /usr/include/pgsql/commands/trigger.h:14: nodes/parsenodes.h: No such

Re: [ADMIN] Vacuum script

1999-12-17 Thread neko
On Fri, 17 Dec 1999, Bruce Momjian wrote: > > It would be nice for new users; I think it would make it easier > > for them to actually set out and do it. Many new users are > > of the not-so-knowledgable variety, and shell scripting isn't > > something they want to undertake. > > Can someone mo

Re: [ADMIN] When triggers ?

1999-12-17 Thread neko
On Fri, 17 Dec 1999, Mario Simeone wrote: > When Postgres will be able to use triggers ? Triggers are already works. Try: $ psql template1 template1=> \h create trigger template1=> \h create function U may some parts of postgres programmers manual. (can found it as programmers.ps) i hope th

[ADMIN] .h-s in devel package...

1999-12-17 Thread neko
Hi! There are some missing header, in devel packages... imho the "make install" don't place some of them in the INCLUDE. If i include spi.h somewhere, then i can't compile ;( Ok, i can copy them from the source, but... -- nek;(

any event log? (Re: [ADMIN] Database chages log to outside)

1999-12-12 Thread neko
> > I need a logging utility for postgresql server. > This will (probably) be addressed in WAL (write-ahead logging(?)), due to > appear eventually but, as we found out the other day, not so soon :( . Can i write any log anywhere? My first goal was to duplicate the database, for more safety. Ther

[ADMIN] Database chages log to outside

1999-12-10 Thread neko
Hi all! I need a logging utility for postgresql server. The log server (and the file) shall be on not the same machine like postgresql server, so the last good database impresson will be exists if the master issue destroyd. Thats needed a logging facility in postgres server, who send all off writ

[ADMIN] Re: Database/table limits ??????

1999-11-24 Thread neko
On Tue, 23 Nov 1999, Chris Albertson wrote: > > I am running postgresql 6.5.2 on FreeBSD. I am developing a data warehouse > > here at Utah State University. A quick look at the docs leaves the following > > questions: > Yes you can do this. The answer is "RAID". I use Postgres > mostly on Li