"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 possibl
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 t
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 stat
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 environm
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 exi
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 2002-10-17
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 bot
* 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 )
Che
> 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 environment but
couldn't
> find anything there.
1) try to copy pg_hba.conf.sample or pg_hba.conf (wherever it is @ your
host) to $PGHOME/data & edit it then.
2) dat
On Tue, Oct 29, 2002 at 01:47:40PM -0500, Alexander Korobov wrote:
>
> I'm aware of contrib/pg_resetxlog but this does not seem to be reliable tool.
It's as reliable as it can be, as far as I know. There is the
potential for data loss, but that's the problem with having lost your
WAL.
> Are the
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]: [2884
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
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
fr
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 PROTEC
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 partid='
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 t
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" an
20 matches
Mail list logo
