[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] psql doesn't recognize some keys

2001-03-26 Thread Björn Lundin
Simone Tellini wrote: > Hi, > > I've got a problem with psql on my home box: it doesn't recognize the > arrow keys nor the backspace and probably other keys as well. > > I've compiled it from the sources, as I did on another server, where it > works correctly. The termcaps should be the same on

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
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 'kill -9' the postmaster - If you kill -9 the postma

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] Error migrating from Postgres 6.3.2

2001-03-26 Thread Tom Lane
Luis =?iso-8859-1?q?Mart=EDnez?= <[EMAIL PROTECTED]> writes: > I am migrating from postgres 6.3.2 to 7.1 Beta6. After performing a > pg_dumpall > backupfile on my old pgsql version I try to restore the data > with psql -d template1 -f backupfile, but I get "Unable to locate type name > 'char16'

[ADMIN] Error migrating from Postgres 6.3.2

2001-03-26 Thread Luis Martínez
I am migrating from postgres 6.3.2 to 7.1 Beta6. After performing a pg_dumpall > backupfile on my old pgsql version I try to restore the data with psql -d template1 -f backupfile, but I get "Unable to locate type name 'char16' in catalog" on tables such as onek, tenk1 ,tenk2 What is the pr

[ADMIN] Re: Dual-CPU RAID database server: What Hardware ?

2001-03-26 Thread J.H.M. Dassen (Ray)
Paul BOYER <[EMAIL PROTECTED]> wrote: >As we are trying to determine the better hardware choice for a database >server aiming to serve from 1GB up to 15GB with less than 10 connections >from application servers, with rather intensive requests, operating >__24x7__ under Linux. For 24x7 availabilit