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: Thank
> 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
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: Than
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
postgres
> 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 em
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 spe
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 pr
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?
ht
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 in
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
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. Wh
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
>
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 referen
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
> >
> >Kin
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: D
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
>
>Thi
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
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 ob
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
-
Howdy- saw your e-mail in the postgresql install file, hope you don't
mind me writing.
Postgresql compiles and runs fine- but the database directories are
named by numbers, not by names- which ain't how it is on my linux boxes
(nor how its described in the pgsql doc)
my posgres user has its h
> "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 N
26 matches
Mail list logo
