It's rumoured that David Fetter once said:
I guess that's OK, but it shows up like a beacon to all kinds of
hostile gear. Passive systems are usually a better bet.
Are there many hostile forces in your hallway?
:-)
/D
---(end of
On Fri, Dec 26, 2003 at 10:48:20AM -, Dave Page wrote:
It's rumoured that David Fetter once said:
I guess that's OK, but it shows up like a beacon to all kinds of
hostile gear. Passive systems are usually a better bet.
Are there many hostile forces in your hallway?
Most days not,
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this resource ?
im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1)
what can be wrong ?
---(end of
Alex J. Avriette [EMAIL PROTECTED] wrote:
I'd like to request the following feature:
Frequently when answering questions on IRC for people, questions
fall into one of two categories, what function can I use to
manipulate datatype xyz, and what datatype can i use for xyz.
The latter is
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this resource ?
We need more info. What does your postgresql.conf say about
max_connections? How much ram do you have? How much
shared
max_connections=200
shared_buffers=2000
ram = 500M + 300M swap
hdd = infinite
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this
ivan [EMAIL PROTECTED] writes:
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this resource ?
First bet is that you are running into a maximum-number-of-processes-
per-user limit imposed by
Hello,
Perhaps you have too many open files? What else is running on this
machine?
Sincerely,
Joshua D. Drake
ivan wrote:
max_connections=200
shared_buffers=2000
ram = 500M + 300M swap
hdd = infinite
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
hi
i need to connect to by my database
DBT-2 and PostgreSQL 7.4 is finally working with LVM2 at 100 and 200
warehouse scale factors on 8-processor system in STP with 40 drives (38
managed under LVM), but not without a few catches. I have written up
some brief instructions on how to execute the test successfully with the
Linux-2.6.0
(I started with this addressed to the -general list, but it just
doesn't seem like a general usage topic. If -hackers is the wrong
place, please point me in the right direction).
I've been working on a custom index type (access method) that allows
postgres to do fulltext searching (including
In manage-ag.sgml our docs says:
[...]
risk. To allow it, you must compile productnamePostgreSQL/ with
the C preprocessor macro literalALLOW_ABSOLUTE_DBPATHS/
defined. One way to do this is to run the compilation step like
this:
programlisting
gmake
.. many others stuf ...
the error is : could not fork new process for connection: Resource
temporarily unavailable
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
Hello,
Perhaps you have too many open files? What else is running on this
machine?
Sincerely,
Joshua D. Drake
ivan
ulimit -u = 256 ,
it's ok, ?
On Fri, 26 Dec 2003, Tom Lane wrote:
ivan [EMAIL PROTECTED] writes:
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this resource ?
First bet is that you
Eric Ridge [EMAIL PROTECTED] writes:
1) Is it possible for an access method to receive some kind of DROP
INDEX notification?
No.
select * from test where stuff = 'stuff' AND NOT more_stuff =
'drink beer';
has this plan:
To do better here, you'd need to invent a not-=' operator, so
ivan [EMAIL PROTECTED] writes:
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me Resource temporarily
unavailable, what are this resource ?
ulimit -u = 256 ,
it's ok, ?
Mph. Well, that doesn't seem to be the problem, unless you are
ivan [EMAIL PROTECTED] writes:
the error is : could not fork new process for connection: Resource
temporarily unavailable
We could have saved some time if you'd spelled out the full error
message to begin with.
This is undoubtedly a kernel-imposed restriction you are running into.
I'm not sure
On Dec 26, 2003, at 3:22 PM, Tom Lane wrote:
3) How does one get the $PGDATA directory?
DataDir. Why should you care? An index AM that wants to know this is
probably broken IMHO; it's certainly trying to do something that's
outside the charter of index AMs, and is likely to cause lots of
Eric Ridge [EMAIL PROTECTED] writes:
Xapian has it's own storage subsystem, and that's what I'm using to
store the index... not using anything internal to postgres (although
this could change).
I would say you have absolutely zero chance of making it work that way.
You will not be able to
PostgreSQL runs beautifully together with JBoss (or any other J2EE platform)
using its current JDBC driver so the idea of a co-bundle is not far fetched
at all.
I'm not an advocate for a backend rewrite to Java. I'm however a firm
believer that Java and the J2EE platform will become (if it isn't
On Dec 26, 2003, at 4:04 PM, Tom Lane wrote:
Eric Ridge [EMAIL PROTECTED] writes:
Xapian has it's own storage subsystem, and that's what I'm using to
store the index... not using anything internal to postgres (although
this could change).
I would say you have absolutely zero chance of making it
from log :
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork checkpoint process: Resource temporarily unavailable
ulimit -a :
core file size(blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size
Eric Ridge [EMAIL PROTECTED] writes:
I assume the doc chapter on Page Files and the various storage-related
README files are good places for more information. Any other tips or
pointers?
Not right offhand, but feel free to ask questions when you get stuck.
Also don't forget that there's a
Hi,
I am attempting to use Setof Record dynamically. I am developing an application where I will not know what the end-user is trying to work with from a web front end. Thus I will not know before hand the structure of the table I am trying to pull the record from.
My Code:
CREATE FUNCTION
On Fri, Dec 26, 2003 at 11:49:20AM -0600, David Fetter wrote:
The latter is harder to answer than the former. For the former, I
propose a macro in psql, \qf (query function). Obviously, the name
implies a broader scope than simply querying the datatypes
permissable.
* Part of \df (for
On Fri, Dec 26, 2003 at 06:34:47PM -0500, Alex J. Avriette wrote:
On Fri, Dec 26, 2003 at 11:49:20AM -0600, David Fetter wrote:
The latter is harder to answer than the former. For the former,
I propose a macro in psql, \qf (query function). Obviously,
the name implies a broader scope
A E wrote:
I am attempting to use Setof Record dynamically. I am developing an
application where I will not know what the end-user is trying to work
with from a web front end. Thus I will not know before hand the
structure of the table I am trying to pull the record from.
[code]
I know that I
On Fri, Dec 26, 2003 at 04:07:50PM -0800, David Fetter wrote:
\dfT integer
might bring back all the functions that operate on (or return)
integers.
I like this the best so far. My only concern is that there is a
whole lot of output generated by this (see thread parent).
27 matches
Mail list logo