Re: [GENERAL] verifying database integrity?

1999-06-10 Thread Valerie Mates
At 02:21 AM 6/9/99 +0800, Vadim Mikheev wrote: >Valerie Mates wrote: >> >> Hi -- Some clod turned off the power to my customer's computer -- a Linux >> box with a Postgres server on it -- while it was running. Ever since then, >> certain PostgreSQL queries have been very slow. We wonder how to

Re: [GENERAL] IPC Problems - URGENT !

1999-06-10 Thread The Hermit Hacker
Okay, this one I can help with a bit better... If I remember correctly, this one is hitting you: -B n_buffers n_buffers is the number of shared-memory buffers for the postmaster to allocate and manage for the backend server processes that it starts.

Re: [GENERAL] IPC Problems - URGENT !

1999-06-10 Thread Anthony Brock
On a related note, Postgres 6.4.2 appears to function perfectly (I just downloaded and installed, and haven't run into any problems yet). Thanks again for any help, Tony At 09:52 AM 6/10/99 -0700, you wrote: >I am in a similar position to the person below. I am trying to install >Postgres 6.5b

Re: [GENERAL] IPC Problems - URGENT !

1999-06-10 Thread Anthony Brock
I am in a similar position to the person below. I am trying to install Postgres 6.5beta3 on a Solaris 7 machine (64-bit libraries installed) using egcs-1.1.2 and receive the following when trying to run the 'postmaster -i' command: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, s

[GENERAL] new type: 1-byte bit mask type

1999-06-10 Thread Adriaan Joubert
Hi, I finally finished my 1-byte bitmask type. You can even use it in btree indexes now. It provides all the standard bit operations (& | ^ ~ << >>) and I hope someone will find it useful. If anybody has any suggestions for improvements or questions, please let me know. If it passes muste

Re: [GENERAL] Howto convert arrays 2 query results

1999-06-10 Thread Jeroen Schaap
On 10-Jun-99 Gerald Fiedler wrote: > create table relation (S_ID int, M_ID int); > insert into relation (2,1); > insert into relation (4,1); > insert into relation (1,2); > insert into relation (3,2); > > will normalize your DB, so you don't need an array. Yes, it sure will. But only, I don't