Re: [ADMIN] Setting Transaction level doesn't work

2000-01-11 Thread Peter Eisentraut
This only makes sense if called in a transaction (after begin). On 2000-01-11, Norbert Meissner mentioned: > Hi all, > > I've tried to set the transaction isolation level in 6.5 to serializable > > with "set transaction isolation level serializable" in psql. A "show > transaction isolation lev

Re: [ADMIN] postgresql configuration nits

2000-01-11 Thread Peter Eisentraut
On 2000-01-11, Sarah Officer mentioned: > 1. I am not installing my software in /usr/local. Here's how I want > to install my software: > > BASE_DIR > include - platform independent include files go here > man - platform independent man pages > other - other directories for stuff ht

Re: [ADMIN] Vacuum process.

2000-01-11 Thread Peter Eisentraut
There shouldn't be any need to vacuum the template database. It's vacuumed at the end of initdb and one usually doesn't make any great changes to it afterwards. On 2000-01-12, Christopher L. Davis mentioned: > Sorry if this is very basic, but I have searched through the archives and > saw mentio

Re: [ADMIN] bugs?

2000-01-11 Thread Peter Eisentraut
Check you pg_user vs your pg_class if there are tables whose owner (pg_class.relowner) has no corresponding user entry (pg_user.usesysid). On 2000-01-11, ZioBudda mentioned: > Hi, for my error I have delete the file pg_log from pgsql/ and now my > database do not works anymore. I can enter in th

[ADMIN] Vacuum process.

2000-01-11 Thread Christopher L. Davis
Sorry if this is very basic, but I have searched through the archives and saw mention in a message that vacuuming template1 caused problems. So I just wanted to be sure. Is it necessary to vacuum the template1 database? I am writing a script to backup and then vacuum my database, but wondered if

Re: [ADMIN] bugs?

2000-01-11 Thread ZioBudda
On Tue, 11 Jan 2000, Lincoln Spiteri wrote: > Or maybe you are not good for massice application :) > ok. my mistake is massice=big.. but the problem remain and your email is lessfull. Il tuo programma più importante prende più memoria di quella che hai. Se hai abbastanza memoria, non hai abbast

Re: [ADMIN] bugs?

2000-01-11 Thread Lincoln Spiteri
On Tue, 11 Jan 2000, [EMAIL PROTECTED] wrote: > Hi, for my error I have delete the file pg_log from pgsql/ and now my > database do not works anymore. I can enter in the database but if I make > db1=> \dt > > I get: > Couldn't find any tables! > > why it? How can I rescue all my data? > If ther

[ADMIN] Setting Transaction level doesn't work

2000-01-11 Thread Norbert Meissner
Hi all, I've tried to set the transaction isolation level in 6.5 to serializable with "set transaction isolation level serializable" in psql. A "show transaction isolation level" tells me that it is still "read commited". Any Hints ? Is there a possibility to have transaction level setted to se

[ADMIN] bugs?

2000-01-11 Thread ZioBudda
Hi, for my error I have delete the file pg_log from pgsql/ and now my database do not works anymore. I can enter in the database but if I make db1=> \dt I get: Couldn't find any tables! why it? How can I rescue all my data? If there is no way I think that postgresql is not good for massice appl

[ADMIN] postgresql configuration nits

2000-01-11 Thread Sarah Officer
I am compiling postgres 6.5.3 on an IRIX running version 6.5 of the OS. I ran into a few problems which are surmountable, but perhaps they should be fixed. I believe problems 1 and 3 are platform independent. I have no idea what causes problem 2. Any ideas? 1. I am not installing my software