Re: [ADMIN] queries

2008-07-02 Thread Devrim GÜNDÜZ
Hi, On Mon, 2008-06-30 at 13:40 +0530, kartik wrote: > I was wondering that is there is any clustering available for > postgresql database Check out PGCluster, Slony-I, PITR (Warm Standby) and Skytools. > Can anyone tell me how to recover a database as we do in oracle , we > have a command in o

Re: [ADMIN] queries

2008-07-02 Thread paul socha
On 2008-06-30, at 10:10, kartik wrote: Hello there, I was wondering that is there is any clustering available for postgresql database pgcluser ? ;] And Can anyone tell me how to recover a database as we do in oracle , we have a command in oracle for recovering ‘’Alter database recover”

[ADMIN] queries

2008-07-02 Thread kartik
Hello there, I was wondering that is there is any clustering available for postgresql database And Can anyone tell me how to recover a database as we do in oracle , we have a command in oracle for recovering ''Alter database recover" Similarly do we have anything for postgresql

RE: [ADMIN] Queries

2001-05-04 Thread John Pagakis
PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Queries [EMAIL PROTECTED] wrote: > > Greetings All. > > I have a record on my database with a last name of 'DeFelice'. > > I want to be able to retrieve that record whether a user enters 'DeFelice', 

Re: [ADMIN] Queries

2001-05-04 Thread Oliver Vecernik
[EMAIL PROTECTED] wrote: > > Greetings All. > > I have a record on my database with a last name of 'DeFelice'. > > I want to be able to retrieve that record whether a user enters 'DeFelice', >'Defelice', 'defelice', or 'DEFELICE'. Is there a way I can do that? Is that what >the "ilike" func

[ADMIN] Queries

2001-05-04 Thread tsattler
Greetings All. I have a record on my database with a last name of 'DeFelice'. I want to be able to retrieve that record whether a user enters 'DeFelice', 'Defelice', 'defelice', or 'DEFELICE'. Is there a way I can do that? Is that what the "ilike" function does? I'm on 7.0.3. Thanks in adv

[ADMIN] Queries against multi-million record tables.

2001-01-30 Thread Michael Miyabara-McCaskey
Hello all, I am in the midst of taking a development DB into production, but the performance has not been very good so far. The DB is a decision based system, that currently has queries against tables with up to 20million records (3GB table sizes), and at this point about a 25GB DB in total. {La