Thanks Stephan. That appears to be the reason for the differences.-ThusithaStephan Szabo <[EMAIL PROTECTED]> wrote: On Wed, 19 Apr 2006, Thusitha Kodikara wrote:> Hi,>> I observed the following on PostgreSQL 8.1.3 (on Windows 2000).>> (1) alter table invoice add column active boolean default true;>
John DeSoi wrote:
On Apr 19, 2006, at 2:26 PM, Arnau wrote:
I have several databases that I have to synchronize their schemas.
I have been testing several programs like EMS PostgreSQL Comparer and
Navicat PostgreSQL but none of them does all I need. Any advise about
what is the best way
On Apr 19, 2006, at 6:42 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
Any tips on turning "ERROR: invalid page header in block 34 of
relation" into a pg_filedump command that would yield something
useful
or interesting? If so, I'll post the results of all three rel
I have a large table which uses a sequence for column which is defined as the
primary key.
Our systems is a real time data acquisition system, so we have "insert"
statements going through it wrapped inside stored procedure.
Every once in a while I get an inserio error on a violation of a unique
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:
> I have a large table which uses a sequence for column which is defined as the
> primary key.
> Our systems is a real time data acquisition system, so we have "insert"
> statements going through it wrapped inside stored procedure.
> Every once i
Benjamin,
Are you sure the sequence is the only source of the
values of the primary key field of all records in this
table, that no records may have been inserted using
primary key field values generated from sources other
than the sequence.
Allan.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "Benj
The sequence is the only source.
The good news is that I was using the sequence to enable purging of old data to
maintain our retention period.
I am going to try a different methodology by using table partitioning - one
inherited table for each month of data. That way after the retention period
No, there is currently no support for DDL triggers, though I believe it
is on the TODO list...
On Wed, Apr 12, 2006 at 12:08:00PM +0200, G?briel ?kos wrote:
> Hi,
>
> Is there a convenient method to let one know if something in the
> database changes (DDL-level).
>
> Background: we have here se
On Wed, Apr 12, 2006 at 11:05:52AM -0700, Sriram Dandapani wrote:
> I noticed something strange. When postgres crashed and restarted...the
> archived WAL log file numbering did not take off from where it left
> off..instead a new sequence was started (the new sequence was higher
> than the last one
I think you're confused about what actually happened...
Session 1:
decibel=# select * from a;
i
---
1
(1 row)
decibel=# begin;
BEGIN
decibel=# select * from a for update nowait;
i
---
1
(1 row)
decibel=#
Session 2:
decibel=# select * from a for update nowait;
ERROR: could not obtain loc
On Fri, Apr 14, 2006 at 11:09:16AM +, venu gopal wrote:
> Hi all,
>When i try to run the following query it gives the following error what
> was wrong in the query.
>
> Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field,
> centroid(c.the_geom) AS the_geom, c.ogc_fid AS og
On Fri, Apr 14, 2006 at 07:42:29PM +0200, Pierre LEBRECH wrote:
> The second location should be used in case of emergency. So, if my first
> machine/system becomes unreachable for whatever reason, I want to be
> able to switch very quickly to the other machine. Of course, the goal is
> to have no l
On Mon, Apr 17, 2006 at 07:07:54AM -0700, Sriram Dandapani wrote:
> I have a cursor that fetches 150K rows and updates or inserts a table
> with 150K rows.
>
> It takes several minutes for the process to complete (about 15 minutes).
> The select by itself (without cursor) gets all rows in 15 secon
On Thu, Apr 20, 2006 at 12:07:13PM -0500, Thomas F. O'Connell wrote:
> But I'm still disappointed in the hardware bleed-through affecting
> the filesystem. :(
I (well, http://stats.distributed.net/) has been bit by this before. One
issue with RAID is that it does you no good if you don't get
not
Title: Re: [ADMIN] Slony1 or DRBD for replication ?
I am running PostgreSQL 8.1.3 on Windows.
The project itself is a real time data acquisition system, so it cannot be
taken off-line for backups.
I have tried using pg_dump, but discovered that the backup was not a
consistent backup. The ap
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:
> I have tried using pg_dump, but discovered that the backup was not a =
> consistent backup.
Really?
> Back to the problem I faced when testing backups with pg_dump, it =
> appears that the backup was not a consistent backup of the data. For =
>
Please include the list in your reply so others can help. I'm also adding
-interfaces.
You're still not showing exact errors, but I suspect this might be a JDBC
issue. Here's what I get:
Session 1:
decibel=# begin;
BEGIN
decibel=# select * from i where i=1 for update nowait;
i
---
1
(1 row)
Unfortunately, I don't think there is any way.
It might not be a bad idea to add created and last_modified columns to
track this information.
On Wed, Apr 19, 2006 at 12:07:43PM -0500, Ma, Yi wrote:
>
> We're in the process of development between model updating and database
> implementation, and
Yes..all of it is in one transaction as there is a window of record ids
that need to be processed in 1 transaction. Data inflow is very
voluminous appx 1 million every 15 minutes and the goal is to create
aggregate tables on the fly (the alternative is to use nightly
aggregates).
-Original Me
Title: Re: [ADMIN] Howto: Using PITR recovery for standby replication
Tom,
First of all forgive me if I am totally
incorrect - I may very well be:) If so, believe me I will be a very happy
camper since my concerns will be void. My concern was raised when I backed
up the server which w
Benjamin Krajmalnik wrote:
> The particular table which was problematic (and for which I posted
> another message due to the unique constraint violation which I am
> seeing intermittently) is the one with the high insertion rate. The
> sequence is currently being used to facilitate purginf of old
Title: Re: [ADMIN] slow cursor
Siriam,
I have no clue what it is you are trying to
do, but I have a similar situation. I have a monitoring system which sends
data to our psotgresql database. The system calls a single stored
procedure which performs on-the-fly data aggregation for the p
Title: Re: [ADMIN] Howto: Using PITR recovery for standby replication
Alvaro,
I am a newbie, so I essentially invoked
pg_dump from with pgAdmin3, with the defaults (including large
objects).
This is the command being
issued:
.C:\Program
Files\PostgreSQL\8.1\bin\pg_dump.exe -i -h 172.2
Benjamin Krajmalnik wrote:
> I am a newbie, so I essentially invoked pg_dump from with pgAdmin3,
> with the defaults (including large objects). This is the command
> being issued:
>
> .C:\Program Files\PostgreSQL\8.1\bin\pg_dump.exe -i -h 172.20.0.32 -p 5432 -U
> postgres -F c -b -v -f "C:\Doc
Title: Re: [ADMIN] slow cursor
Thanks Benjamin
The issue I have with my situation is tht
the target table typically has millions of records (not unusual to have tens of
millions) and the update is based on 80% of the columns. The update is a
killer w.r.t performance. I plan to create
Title: Re: [ADMIN] Howto: Using PITR recovery for standby replication
1. Dropped
database
2. Recreated blank
databas
3. C:\Program
Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h 172.20.0.32 -p 5432 -U postgres -d
events -v "C:\Documents and
Settings\administrator.MS\testbk.backup"pg_re
Title: Re: [ADMIN] Howto: Using PITR recovery for standby replication
Tom,
Just wanted to let you know that I found
the problem with the constraint violation on insert.
When I restored from a backup, I forgot to
update the sequences current values to thje macval of the associated
table
27 matches
Mail list logo
