The company I work for provides services for various offices around the
country. In order to help keep our database straight, and allow several of our
client-side programs to verify their location, we include a table called
'region' in our database. Although the database is replicated by Slony
One of the servers I am responsible for maintaining was apparently having
problems earlier today. The servers are all running SuSE 9.2, Apache 2 (not
sure what version), and Postgres 8.1.4. Our main server is running Slony 1.1,
I think, creating Log-Shipping records that the rest of the server
Yesterday, one of the (replicated) remote databases I work with somehow got
corrupted, so I attempted to drop a new copy off of the master (on a different
box) and rebuild the database. Creation, language install, schema reload, all
appeared to go well. On the actual data reload, I set the sys
Is somewhat old, 8.1.3. I'll try to upgrade it to the 8.1.9. The box is
running on SuSE 9.2, if I recall correctly...which binary rpm should I snag for
that?
Tom Lane <[EMAIL PROTECTED]> wrote: Andrew Edson writes:
> PANIC: block 39 unfound
> LOG: startup process (PID 640
I've been working on a db project intended to perform modifications to one db
based on the data stored in another one. Specifically, I'm supposed to check a
pair of tables based on two criteria; an id field, and a timestamp. This will
be crossreferenced with the second database; the timestamps
13.22 rows=87439 width=21) (actual
> time=20.286..65330.049 rows=204855 loops=1)
>Filter: (rcrd_cd = '0A'::bpchar)
> Total runtime: 65945.160 ms
Again, someone mind pointing out to me where I've managed to mess this one up?
Richard Huxton <[EMAIL PROTECTED]&g
have already been solved; I'm using an older version of
Postgres; 8.1.3. My boss has requested that it not be upgraded just yet,
however, so I'm stuck with it for the moment.
Richard Huxton <[EMAIL PROTECTED]> wrote:
Andrew Edson wrote:
> I apologize about the CC; I th
Tom Lane <[EMAIL PROTECTED]> wrote: Ah. I think your result is explained by
this 8.1.4 bug fix:
2006-05-18 14:57 tgl
* src/backend/optimizer/plan/createplan.c (REL8_1_STABLE): When a
bitmap indexscan is using a partial index, it is necessary to
include the partial index predicate in the scan'
Is there some program or procedure for stripping apostrophes (') from data in
the db? Most of our data has been shuffled over to Postgres from an older
system, and I'm occasionally running into data entered in the old system that
has apostrophes in it. (Most recent example: A name field with t
The dollar quoting appears to have fixed it; thank you. I apologize for my
folly in sending out the original message.
Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Aug 20, 2007, at 11:19 , Andrew Edson wrote:
> Is there some program or procedure for stripping apostrophes ('
I've been tasked with maintaining a set of postgres databases created by my
predecessor in this position. The original databases several years back were
version 8.1.3, and used the tsearch2 functions to enable some client-program
searches.
We've recently begun preparing to shift to 8.3 (I beli
I need to add a system to our postgres pg_hba.conf file; the main server went
down a few days ago, and this system was mistakenly left off the list of
allowed systems when the server was brought back up. (Older version of the
.conf file; I managed to accidentally delete the more current one whi
Okay, for some reason we still had a problem connecting after a pg_ctl reload,
but the shutdown went through this time, and everything's working now. Thanks
for the assistance.
Tom Lane <[EMAIL PROTECTED]> wrote: Andrew Edson writes:
> Someone else added the IP address for the o
I'm working on a php project that's supposed to draw information from the DB
for display, and I've been requested to speed up the display as much as
possible. I'm drawing data from four tables, with an additional two that I
have to 'bounce' through to match the keys together. Also, I've got fi
Index Cond: ("outer".person_seq = persn.person_seq)
Total runtime: 271175.640 ms
(22 rows)
Anybody ideas what might be causing the problems with the slowdown? The slow
database is fed by slony logshipping from the 'normal' one, and both are (at
least theoreti
I've been given a file to maintain, the purpose of which is to purge the
database of records more than two years old. (Database setup is pg 8.1.3)
The program (written in perl) enters postgres as the user 'postgres', and is
supposed to select foreign-key records from all tables that link t
I have a select statement, used in a Perl program, which is supposed to find
all records related to those in one table which have a delete_dt field value of
four years or older.
This is the select statement:
SELECT t2.dist_id, t1.clnt_seq, t2.cntrct_seq, t2.cntrct_id, t3.aunit_seq,
t1.pe
If this message has already appeared on the list, I apologize. My system tried
to temporarily freeze up when I attempted to send this message a few minutes
ago, and I do not know if I hit send before it halted or not.
I am working with a php program that is designed to enter the database,
I'm needing to do a partial dump on a database. All of the entries in the db
can be marked as one of two groups, and I've been asked to create a dump of
just the second group. It is possible to do a select statement based dump and
just grab the one set of records in the output?
---
I am aware of this, yes, but the data in question is all (both sets) contained
on a single table. That's why I was looking for a way to do a 'dump where
(select foo where bar = 'criteria')' structure.
Merlin Moncure <[EMAIL PROTECTED]> wrote: On 4/11/07, Andre
As the title of this message suggests, I've got a couple of questions about
indexing that I'm not sure about. I've tried to take a look at the docs, but I
can't remember seeing anything on these; it's quite possible, I admit, that I'm
simply not remembering all of what I saw, but I would apprec
21 matches
Mail list logo
