- Original Message -
From: "Eric L. Blevins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 11:15 AM
Subject: Re: [ADMIN] Signal 11
> From: "Andrew Sullivan" <[EMAIL PROTECTED]>
> To: "Eric L. Blevins" <[EMAIL PROTECTED]>
> Sent: Thursday, October 31, 2002
This might sound silly, but I am trying something basic, and having
trouble. What I want to do is unload selected rows from a table, and load
them somewhere else.
pg_dump works great if you want the whole table. I suppose I could from
one table, dump into a temp, and then pg_dump it, but tha
Hello everyone,
I have a question about setting the variables in the postgresql.conf
file. I have the following settings in my my.cnf file for MySQLand
need to know which variables in the postgresql.conf file would
correspond to the ones below, so that I may tune my system correctly.
set-var
On Thu, 2002-10-31 at 14:19, Andrew Sullivan wrote:
> On Thu, Oct 31, 2002 at 03:52:03PM -0500, John Sequeira wrote:
> > Does anyone have successful experience using rsync/usogres or one of the pg
> > replication projects to accomplish this?
Usogres just flat didn't work well for us, and it intro
On Thu, Oct 31, 2002 at 03:52:03PM -0500, John Sequeira wrote:
> Does anyone have successful experience using rsync/usogres or one of the pg
> replication projects to accomplish this?
Yes. We use the rserv (eRServer) software from PostgreSQL, Inc. It
works for us.
You can't use rsync for this.
I have a question about configuring a warm spare.
I'm on a project that's looking to deploy a fairly transaction-intensive
application (250K inserts/day) running on a linux/apache/mod_perl/postgres
setup and would like to implement an offsite warm spare (as warm as
possible). The warm spare wo
I'm using blobs for ease of management in a high
volume, distribuited content distribution system. My last version of the
application used the filesystem to manage the content, and now that I've moved
everything to the database my code (php, perl) is much more compact and
easier to manage,
Jodi,
check contrib/intarray for arrays of integers.
ïÌÅÇ
On Thu, 31 Oct 2002, Jodi Kanter wrote:
> Can anyone offer some insight or link to documentation on the use of integer and/or
>string array data types? We are thinking of using them in our database but there is
>some concern abo
Andrew Perrin wrote:
- Do a formal backup more often
For what it's worth, the FreeBSD "port"
(http://cvsweb.freebsd.org/ports/databases/postgresql7/) for PostgreSQL
contains a most excellent daily maintenance script (as written it's a
FreeBSD "periodic" script, but it's more or less suitab
FYI, our "signal 11" problem was caused by faulty cache memory on the RAID
controller.
-Original Message-
From: Eric L. Blevins [mailto:eblevins@;insight.rr.com]
Sent: Thursday, October 31, 2002 11:16
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Signal 11
From: "Andrew Sullivan" <[EMAIL PR
"Eric L. Blevins" <[EMAIL PROTECTED]> writes:
> From: "Andrew Sullivan" <[EMAIL PROTECTED]>
>> Have you checked your physical memory for flaws?
>>
> Yes, I have checked the memory, it is fine.
I'd suggest checking harder ;-). I think an unreliable section of
memory is by far the most probable ex
From: "Andrew Sullivan" <[EMAIL PROTECTED]>
To: "Eric L. Blevins" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 10:33 AM
Subject: Re: [ADMIN] Signal 11
>
> Have you checked your physical memory for flaws?
>
Yes, I have checked the memory, it is fine.
We had so much trouble we replaced the
We've done A LOT of database work where images (as well as other large
MIME-type files) are part of the equation. We've almost always stuck with
the approach of keeping images outside the database. Here are the pros and
cons we consider.
Blob PROS:
1) At least you need to maintain only a single
Jodi,
In my
experience:
It is better to normalize these arrays into separate tables
- even if it isn't "nice" to do so :-p
Array types can't be indexed, can't be foreign keys,
and aren't compatible with other systems.
Normalization is always the most efficient way of handling
m
Can anyone offer some insight or link to
documentation on the use of integer and/or string array data types? We are
thinking of using them in our database but there is some concern about breaking
normalization standards and opening ourselves up to more issues later.
We are storing data abou
I have a java app that (is currently using MYSQL,
but we're converting to Postgre soon) references small (62kb) images for viewing
on the screens of the app.
Does anyone have any thoughts on database design
that they can share with me that would validate why I would want to put Images
into
Thanks for your response. I sort of figured I was out of luck. As it
turned out, things weren't nearly as bad as they could be - I had turned
on the SQL query echo to the log, so I had a complete trace of all the
statements that had gone into creating that table. It took a few hours'
work, but with
On Wednesday 30 October 2002 20:09, Tom Lane wrote:
> This strikes me as a fault on the client side, not in Postgres --- to
> wit, poor connection management. It is not Postgres' job to kill idle
> client connections.
I suppose you are right. The thing is we have never used persistant
connection
18 matches
Mail list logo
