[ADMIN]

2001-02-06 Thread Philippe Rochat
Attached is a modified version of Field.java for the JDBC driver. I think types were not so correctly defined, and that this version should be more well suiting last version of postgres. Any comment welcome, Ph.R. BTW: author e-mail in the README of jdbc in the distrib does not exist anymore ..

[ADMIN] "Sorry too many clients" error and vacuum command

2001-02-06 Thread Gyula Toth
1. Postgres in default does not delete the expired/unnecessary lines from the tables, therefore we have to run vacuum regularly to delete these lines in order to prevent the database from becoming too large. Is there any way to change the default, so that the updated lines do not duplicate and th

[ADMIN] Re: Longer and longer updates

2001-02-06 Thread ender
if you're doing updates in a single transaction, you'll realize speed gains by distributing the updates into multiple transactions. postgres won't have to keep multiple copies that way. hth kapil > > > > 3) executed this statement tons of times: > > > >update test set data=1234 where key

[ADMIN] Re: pgadmin

2001-02-06 Thread Alfonso Peniche
What you have to do is: For every database you have in PostgreSQL you have to: 1.- Select ODBC Data Sources in the Control Panel 2.- Select the User DSN tab 3.- Click on 'Add...' 4.- Choose the ODBC Driver corresponding to PostgreSQL and click on 'Finish'. 5.- A Setup window will appear with the

[ADMIN] PostgreSQL client libraries only.

2001-02-06 Thread C. Bensend
Hello folks, Hopefully, this is the correct forum. I wasn't entirely sure. I'm trying to perfect a process for installing Apache/PHP/OpenSSL/Mod_SSL on OpenBSD machines. This I have done, and it works well. :) Yay. I need to provide PostgreSQL support for this webse

Re: [ADMIN] ERROR:cannot read block 9053 of mots

2001-02-06 Thread Ragnar Kjørstad
On Fri, Feb 02, 2001 at 03:44:04PM +0100, David D wrote: > hi,i'm sorry but > i don't speak english...but i have a problem: > > ERROR:cannot read block 9053 of mots We got simular errors from our database because of a disk-error. To verify, you can either: * Read the mots file directly, e