[HACKERS] WAL Crash during index vacuuming 7.1beta4

2001-02-01 Thread Giuseppe Tanzilli - CSF
Hi, during the nightly vacuum pgsql closed and do not start any more. Attached the log. Seems the problem was rebuilding an Index, There is a way to force wal to ignore indexes ? Can I delete it ? thanks in advance --- Giuseppe Tanzilli

[HACKERS] Beta 4 problem(s)

2001-02-01 Thread Mitch Vincent
I've been using the 7.1 beta version for quite a while now and just upgraded to beta 4, I've noticed my application is reporting that the backend shuts down prematurely... (I'm using PHP).. I'm having a time trying to debug this.. I know it's not my code as this works fine on a 7.0.3 install.. I'v

Re: [HACKERS] Beta 4 problem(s)

2001-02-01 Thread Mitch Vincent
Yes, I did.. -Mitch - Original Message - From: "Matthew" <[EMAIL PROTECTED]> To: "'Mitch Vincent'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 10:33 AM Subject: RE: [HACKERS] Beta 4 problem(s) > Did you recompile PHP with postgre support after you upgrade

RE: [HACKERS] Beta 4 problem(s)

2001-02-01 Thread Matthew
Did you recompile PHP with postgre support after you upgraded? > -Original Message- > From: Mitch Vincent [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 01, 2001 9:13 AM > To: [EMAIL PROTECTED] > Subject: [HACKERS] Beta 4 problem(s) > > I've been using the 7.1 beta version fo

Re: [HACKERS] Open 7.1 items

2001-02-01 Thread Bruce Momjian
Thanks, Peter. This is a big help. > At 15:02 29/01/01 -0500, Bruce Momjian wrote: > >LAZY VACUUM (Vadim) > >Runtime btree recovery (Vadim) > >JDBC setMaxRows() is global variable affecting other objects > > Now fixed. When called from within a Statement it uses its maxrows value, > but inter

[HACKERS] More features for the common man!

2001-02-01 Thread Trewern, Ben
Title: More features for the common man! I'm writing this as a convert from MS-Access to PostgreSQL so whatever happens things are getting better :-) When using M$ Access I took for granted that any time I altered my database, I would be able to go back later and revert or alter that table,

Re: [HACKERS] Re: Re: grant privileges to a database [URGENT]

2001-02-01 Thread Dave Mertens
On Wed, Jan 31, 2001 at 07:18:12PM -0300, Martin A. Marques wrote: > El Mié 31 Ene 2001 18:32, Dan Wilson escribió: > > GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO > > user > The problem is that this is not what I'm looking for. I want the user to be > able to creat

[HACKERS] Index grows huge, possible leakage?

2001-02-01 Thread Alfred Perlstein
After several weeks our idicies grow very large (in one case to 4-5 gigabytes) After droppping and recreating the indecies they shrink back to something more reasonable (500megs same case). We are currently using Vadim's vacuum patches for VLAZY and MMNB, against 7.0.3. We are using a LAZY vacu

Re: [HACKERS] Index grows huge, possible leakage?

2001-02-01 Thread XuYifeng
PostgreSQL hasn't a rewritten storage managent, this is a normal case. Regards XuYifeng - Original Message - From: "Alfred Perlstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Mikheev, Vadim" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 7:34 AM Subject: [HACKERS] Index gr

[GENERAL] Re: Re: grant privileges to a database [URGENT]

2001-02-01 Thread Martin A. Marques
El Mié 31 Ene 2001 21:32, Mike Miller escribió: > MySQL has this feature. I run a multi-user system and require shared MySQL > And PostgreSQL dbs. I have mysql fine. Users have their DBs and can only > access their DBs... but theres no real way to do this in Postgres. I can > restrict tables,