Michiel Lange [EMAIL PROTECTED] wrote in message
news:apn9vs$gou$1;news.hub.org...
I was just wondering about a few options that I would think might be
pretty
useful. They might exist, but then, I don't know how to get it done...
Here's my list:
- multi-volume database. Is it possible to
Hi all,
Anyone experienced similar patterns on their Web-DB setups ?
Short setup description :
X frontend webservers (Apache 1.3.x) with php and mod_perl dynamic content.
1 backend db server (Postgresql 7.1.3).
The webservers are _very_ busy, but send only a limited amount of their
requests
I have a strange dilemma. I've created a couple sequences I can't
remove.
Here is an example
I can
CREATE SEQUENCE count1 ..;
DROP SEQUENCE count1;
I can't
CREATE SEQUENCE count1ListItems1 ..;
DROP SEQUENCE count1ListItems1;
It states
We have a system that someone setup on cygwin. We are trying to locate where
the pg_hba.conf file is and found one but it doesn't seem that it is being
used.
How might we (1) locate which pg_hba.conf file postgres uses on cygwin and (2)
where pg is storing the data. I looked into the
Hi
Does anyone know where I could get some Database administration and
management training for PostgreSQL.
Cheers
Elizabeth O'Neill
Database developer
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Hello.
I have a problem here with PostGreSQL (7.2.1) (running on Debian 3.0).
The database appears to be functioning correctly, but /var/log/syslog
is filled with the messages which look like the following:
postgres[32066]: [288403] DEBUG: statistics collector process (pid
14965) exited with
Hello,
I'm trying to recover database(after a crash). postgres is failing to
start complaining on missing transaction log file :
2002-10-22 14:53:17 [2247] DEBUG: database system was interrupted at
Hi all,
I'm trying to code a problem where a set of options can be expressed in
a data column like 10111011, a bit string.
Each position is atomic and represents a certain setting within the set,
thus: 0010 would return TRUE if OR'd with 10111011, since the
3'rd position matches in both
* smacks your hand for using uppercase letters *
Another big no no is not keeping your create sequences for sequences ( what
a pun ) in a file somewhere.
Otherwise you can't drop them because you don't remember what parameters
they took ( but you can always, as you say, look at system tables )
On Tue, Oct 29, 2002 at 01:43:45PM -0800, Mick wrote:
Hello.
I have a problem here with PostGreSQL (7.2.1) (running on Debian 3.0).
The database appears to be functioning correctly, but /var/log/syslog
is filled with the messages which look like the following:
postgres[32066]: [288403]
On Wed, Oct 30, 2002 at 01:36:28AM +0100, Michiel Lange wrote:
I was just wondering about a few options that I would think might be pretty
useful. They might exist, but then, I don't know how to get it done...
Here's my list:
- multi-volume database. Is it possible to split the complete
David Bear writes:
Also, since postgres starts as a windows service, how does one put commandline
parms on the postmaster so that it listens to a socket. Sorry about the
newbie questions but all the docs I found point to runing pg on various
unicies.
Consider reading the Administrator's
Denis Braekhus [EMAIL PROTECTED] writes:
Every now and then postgresql gets too busy and these patterns emerge :
- some connections are just idling and not being reaped (presumably either the
browser/client or the apache webserver timed out the request)
- these connections stack up to a
Folks,
I just made a mistake that could be quite costly: I did this:
update writer_survey set partid='W41308' where survid in (select survid
from participants where partid='W41291' limit 1);
when I should have done this:
update writer_survey set partid='W41308' where survid in (select survid
http://www.postgresql.org/idocs/index.php?functions-math.html
is this what you're after?
SELECT 1 WHERE B'1010' B'0110' B'0001';
returns 1
SELECT 1 WHERE B'1010' B'0100' B'0001';
returns null
- Original Message -
From: "Ericson Smith" [EMAIL PROTECTED]
Andrew Perrin [EMAIL PROTECTED] writes:
I just made a mistake that could be quite costly: I did this:
update writer_survey set partid='W41308' where survid in (select survid
from participants where partid='W41291' limit 1);
when I should have done this:
update writer_survey set
I'm fairly new to postgres, we are using postgresql-7.2.3 on Linux Red-Hat
8.0
I am having a problem with the shared buffers setting.
Whenever I set the shared buffers above 96 I start getting Segmentation
Faults
when performing queries.
However, if I leave the shared buffers set to 96 or lower
Dear Sir,
I use SCO Open Server 5.0.5 on an intel box. Although I have installed and
used PostgreSQL on Linux, setting it on SCO has not been smooth :)
I have downloaded the latest version ie Postgresql-7.2.3.
I also installed ant package for using java. I have tcl8.0, tk8.0,
itclsh3.0 and
18 matches
Mail list logo