Re: [ADMIN] sorry which is the best

2006-04-23 Thread Ottó Havasvölgyi
Hi, Are these A,B,C independent from each other? I mean you don't need to perform a query or transaction in which at least two of them occurs. In this case it is recommanded to put them into different databases. This is more secure. Best Regards, Otto 2006/4/17, [EMAIL PROTECTED] <[EMAIL PROTEC

[ADMIN] sorry which is the best

2006-04-16 Thread slackman
Sorry i have wrong... Now I have 3 database A,B,C is working in Interbase v 5.6, but Interbas v 5.6 is no longger can hold what the client wants, I will conver it in Postgresql, I need your advice which is the bertter result: (1): unika | |-- A (schema) | B (schema) |---

[ADMIN] Sorry

2004-01-21 Thread pginfo
Sorry for my question about trigger in "C". A found the good example. regards, ivan. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[ADMIN] sorry!

2003-09-13 Thread pginfo
Sorry the last message was for pgAdmin mailing list. Pls. ignore it. It was my type mistake and I am very sorry. regards, ivan. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/F

[ADMIN] Sorry, too many clients already

2001-03-26 Thread Subra Radhakrishnan
Thanks everybody, Majority of the mails I received asked me to start the postmaster as follows and it seems to work so far: /usr/local/pgsql/postmaster -i -B 256 -N 128 -D /usr/local/pgsql/data/ Thanks again, Subra __ Do You Yahoo!? Get email

Re: [ADMIN] Sorry, too many clients already

2001-03-26 Thread Tom Lane
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes: > On Mon, Mar 26, 2001 at 12:00:03PM +0530, Mahesh Guleria wrote: >> Use these commands : >> >> ps -ef|grep post >> kill -9 [process id] > No, no, a thousand times, no! Haven't you seen this appended to > messages on the lists? > TIP 4: Don't 'kil

RE: [ADMIN] Sorry, too many clients already

2001-03-26 Thread David Lizano
At 19.42 26/3/01 +0200, you wrote: >Mahesh Guleria writes: > > > Use these commands : > > > > ps -ef|grep post > > kill -9 [process id] > >Don't do that, it might destroy your database. SIGTERM should be used to >kill individual backends. > >-- >Peter Eisentraut [EMAIL PROTECTED] http:

Re: [ADMIN] Sorry, too many clients already

2001-03-26 Thread Ross J. Reedstrom
; > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Subra > Radhakrishnan > Sent: Friday, March 23, 2001 4:31 PM > To: [EMAIL PROTECTED] > Subject: [ADMIN] Sorry, too many clients already > > > Hi All, > >

RE: [ADMIN] Sorry, too many clients already

2001-03-26 Thread Peter Eisentraut
Mahesh Guleria writes: > Use these commands : > > ps -ef|grep post > kill -9 [process id] Don't do that, it might destroy your database. SIGTERM should be used to kill individual backends. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(en

RE: [ADMIN] Sorry, too many clients already

2001-03-25 Thread Mahesh Guleria
Use these commands : ps -ef|grep post kill -9 [process id] Mahesh Guleria -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Subra Radhakrishnan Sent: Friday, March 23, 2001 4:31 PM To: [EMAIL PROTECTED] Subject: [ADMIN] Sorry, too many clients already

Re: [ADMIN] Sorry, too many clients already

2001-03-23 Thread Jie Liang
By default, one postmaster allows 32 clients to connect at same time, max is 1024. 1. check your processes under the postgres, kill the junky proccesses. 2. re_start your postmaster with -N=?? (>32) see your man page of postmaster. Jie LIANG St. Bernard Software 10350 Science Center Drive Su

[ADMIN] Sorry, too many clients already

2001-03-23 Thread Subra Radhakrishnan
Hi All, We are getting an error every now and then in PostgreSQL saying 'Sorry, too many clients already'. We have recently installed the database version 7.0.3. Calls to database are made from our application written in Java, JSP. Can anyone help me with this? Thanks, Subra ___

[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] sorry

1998-05-22 Thread Yogesh Bhanu
Hi Sorry about the last mail. The postmaster -i does work.here is the screenshot tcp0 0 *:5432 *:* LISTEN I have a problem of connecting from the browser.Neither Appgen Nor dbengine works. and I suspected that the socket is not alive.