[ADMIN] FreeBSD & Shared Memory

2004-06-11 Thread Michael Fork
All, I am trying to get Postgres running on FreeBSD and am running into problems with shared mem. Here is the postgres error messge: FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shgmet(key=5432001, size=103407616, 03600). HINT: This erro

Re: [ADMIN] Corrupted or deleted pg_tables

2004-06-11 Thread Robert Treat
On Tue, 2004-06-08 at 21:08, Curtis Klumas wrote: > > We have a database that we manage through Webmin and today, the entires for > the databases dissappeared from webmin. Going in through psql we could see > our data in tables still intact, and have a copy of the directory structure. > Is thier a

Re: [ADMIN] pg_clog after crash

2004-06-11 Thread Tom Lane
Andreas Schmitz <[EMAIL PROTECTED]> writes: > after a harddisk filling up to a 100% the database crashed. This is > the output I get when I try to start the DB again. Is there any chance > to get it back running without using a dump ? What PG version is this? regards, tom

Re: [ADMIN] Calculating size of the database tables

2004-06-11 Thread Bruce Momjian
Have you read the documentation section on managing disk space? --- [EMAIL PROTECTED] wrote: [ There is text before PGP section. ] > > > > > Hi, > > Thanks for the response. However, the README.dbsize says that "When >

Re: [ADMIN] PostgreSQL Performance

2004-06-11 Thread Gaetano Mendola
Milosz Miecznik wrote: Hi! I have very important question about performance of PostgreSQL Database. How it will work with: - about 300 insert operation per day, - about 100 selects per day, - about 100 still connected users? What hardware platform shall I use for such big database (RAM, No.

[ADMIN] pg_clog after crash

2004-06-11 Thread Andreas Schmitz
Hello *, after a harddisk filling up to a 100% the database crashed. This is the output I get when I try to start the DB again. Is there any chance to get it back running without using a dump ? regards, -Andreas 2004-06-11 13:38:23 [22379] LOG: database system was interrupted while in r

Re: [ADMIN] [GENERAL] out of memory error

2004-06-11 Thread Martin Marques
El Jue 10 Jun 2004 22:14, escribió: > Hi, > > we are using Postgres with a J2EE application (JBoss) and get > intermittent "out of memory" errors on the Postgres database. We are > running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the > following parameters: > > shared_buffers = 8192

[ADMIN] how to test the server webauth on mandrake

2004-06-11 Thread lise chhay
I have just finished to build the server webauth on Mandrake. Can you tell me how to test it, please, can you give me all the solutions possibles, please. Thanks -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.ht

Re: [ADMIN] [GENERAL] out of memory error

2004-06-11 Thread Richard Huxton
Mark Striebeck wrote: Hi, we are using Postgres with a J2EE application (JBoss) and get intermittent "out of memory" errors on the Postgres database. We are running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the following parameters: shared_buffers = 8192 sort_mem = 8192 effective