Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe different
for 7.x)
NH
-Message d'origine-
De: jochen mader [SMTP:[EMAIL PROTECTED]]
Date: vendredi 8 juin 2001 13:53
À:[EMAIL PROTECTED]
Objet:[GENERAL] too many clients
First: Thanks to
I would like to write begin and commit/rollback
transaction instructions in plpgsql functions I am
writing.
Also how to write 'lock serializable' in plpgsql
Thank you in advance.
Allan Kamau.
__
Do You Yahoo!?
Get personalized email
Hi!
Use the -N flag to set number of client connections when starting
postmaster. See manual page for postmaster.
/Buckis
-Original Message-
From: jochen mader [mailto:[EMAIL PROTECTED]]
Sent: den 8 juni 2001 13:53
To: [EMAIL PROTECTED]
Subject: [GENERAL] too many clients
First:
Hello,
I just updated a smaller database with some functions declared
LANGUAGE 'plpgsql';
from 7.0.3 to 7.1 (Debian package 7.1release-4)
The Debian package of postgresql 7.1 replaces the former extra package
postgresql-pl and so I guess that plpgsql support is now included in the
I would like to write begin and commit/rollback
transaction instructions within plpgsql writen
functions.
Also how to write 'lock serializable' in plpgsql.
Thank you in advance.
Allan Kamau.
__
Do You Yahoo!?
Get personalized email
On Fri, Jun 08, 2001 at 04:37:42PM +0200, Andreas Tille wrote:
The Debian package of postgresql 7.1 replaces the former extra package
postgresql-pl and so I guess that plpgsql support is now included in the
postgresql package. Unfortunately I get
It is.
ERROR: Unrecognized language
Im trying to install DBD-Pg so that I can connect to pgsql databases
through Perl.
The README files say I should set some environment variables.. quoting
the readme file:
...The Makefile checks the environment variables POSTGRES_INCLUDE and
POSTGRES_LIB, to find the library libpq.so and the
Jason Tishler [EMAIL PROTECTED] writes:
The bottom line is should I be using
make -C src/include install-all-headers
instead of
make -C src/include install
or is PoPy's use of non-client-side headers incorrect?
If PoPy is client-side code and not something that loads into the
On Friday 08 June 2001 16:45, you wrote:
Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe
different for 7.x)
Thanks a lot, overlooked this one :-)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Tom,
On Fri, Jun 08, 2001 at 12:40:47PM -0400, Tom Lane wrote:
Jason Tishler [EMAIL PROTECTED] writes:
The bottom line is should I be using
make -C src/include install-all-headers
instead of
make -C src/include install
or is PoPy's use of non-client-side headers incorrect?
Somazx Interesting [EMAIL PROTECTED] writes:
Can anyone think of anything that would cause dropping a table with little
data contained within it to take several seconds (and growing)?
Can't see a reason for that offhand.
- upgraded to 7.1 but not to 7.1.2
I'd strongly recommend moving to
Somazx Interesting [EMAIL PROTECTED] writes:
getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0
tuples. Expected 1.
pg_dump failed on OnEd, exiting
Kinda looks like you dropped some function that was still referenced by
a trigger. Better drop the trigger too.
[EMAIL PROTECTED] writes:
I just noticed that inserting 1 tuples in an indexed table took exactly
the same amount of time as inserting 1 tuples in a non-indexed table
(194 seconds). Why is this? The difference in MySQL is about 50% longer in
an indexed table.
Surprises me too. Which
i just installed postgresql7.1 on a freebsd 4.3-stable machine. and i
am able to start it with:
postmaster -D data
but when i try to:
createdb test
i get the following error:
/usr/libexec/ld-elf.so.1: Shared object libpq.so.2 not found
where can i get libpq.so.2?
peter choe
Nick Ganju [EMAIL PROTECTED] writes:
I am trying to do the following query:
select * from track_category_track c, track_datafile d where
c.track_id='49682224EB2753AB0A262ACB00172E08' and d.track_id=c.track_id
This takes more than 1 second to run, even though track_id is indexed in
both
At 02:18 PM 6/8/2001 -0400, Tom Lane wrote:
Somazx Interesting [EMAIL PROTECTED] writes:
getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0
tuples. Expected 1.
pg_dump failed on OnEd, exiting
Kinda looks like you dropped some function that was still referenced by
a
On Fri, 8 Jun 2001, Somazx Interesting wrote:
At 02:18 PM 6/8/2001 -0400, Tom Lane wrote:
Somazx Interesting [EMAIL PROTECTED] writes:
getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0
tuples. Expected 1.
pg_dump failed on OnEd, exiting
Kinda looks like you
Somazx Interesting [EMAIL PROTECTED] writes:
Taking that to mean, try deleting that orphaned trigger - but since I
don't know which table that trigger was on - I did it by deleting it
through pg_trigger, I now get somewhat worse errors:
getTables(): relation 'lessontable_548_118': 8
If I have a database running, and I see that
there is a postmaster process taking 99.9% cpu.
ie, a very large insert query.
Is there a way to cleanly shut down that query from the client or admin
side?
-Thanks
---(end of broadcast)---
TIP 4:
At 01:30 PM 6/8/2001 -0700, you wrote:
At 02:18 PM 6/8/2001 -0400, Tom Lane wrote:
Somazx Interesting [EMAIL PROTECTED] writes:
getTables(): SELECT (funcname) for trigger sa_eval_trigger_608
returned 0
tuples. Expected 1.
pg_dump failed on OnEd, exiting
This is easy to fix,
You can kill -TERM the postmaster that is executing the particular query.
cheers,
t.
On Fri, 8 Jun 2001, Dennis wrote:
If I have a database running, and I see that
there is a postmaster process taking 99.9% cpu.
ie, a very large insert query.
Is there a way to cleanly shut down that
To be more precise, if by a very large insert you mean an import of a large data
file via COPY, then it is fully transactional i.e. if you kill -TERM the corresponding
postmaster, it'll be like the insert never took place.
If you mean multiple INSERTs in a transaction block then again the same.
PC == Peter Choe [EMAIL PROTECTED] writes:
PC i just installed postgresql7.1 on a freebsd 4.3-stable machine. and i
PC am able to start it with:
PC postmaster -D data
PC but when i try to:
PC createdb test
PC i get the following error:
PC /usr/libexec/ld-elf.so.1: Shared object libpq.so.2
Hello,
We have decided that we will not be including GreatBridge PostgreSQL and
instead will be focussing on the community released version.
As always updated information on the book can be found on the web at:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Joshua Drake
g == grant [EMAIL PROTECTED] writes:
g However, the last time i checked, NULL does not equal to 1, 2, 3,
g or anything else besides NULL. Thats why I'm confused as to why
g SELECT column FROM table WHERE column != 1 also excludes NULL,
g because 1 does NOT have the same value as NULL.
Ok,
25 matches
Mail list logo