The advice I've received upon asking this question in the past is
clients first then server. We are currently running many 9.1 clients
against some servers awaiting upgrade
- the most ancient of which is
7.4. The only problem (annoyance, really) is that in interactive
psql
Hi PostgreSQL users,
I'm having difficulty migrating a postgres 8.4.11 database to postgres
9.1.2, neither of the included pg_dumpall tools appear to honour the -o or
--oids options and fail to dump the table oids from the old database as we
require.
I've tried various combinations and orders of
On 1 May 2012 11:12, Matthew Churcher matthew.churc...@realvnc.com wrote:
Hi PostgreSQL users,
I'm having difficulty migrating a postgres 8.4.11 database to postgres
9.1.2, neither of the included pg_dumpall tools appear to honour the -o or
--oids options and fail to dump the table oids from
great stuff!
was that already in it?
i'd plea for adding recognition of gzipped data too..
cheers,
WBL
On Wed, Apr 25, 2012 at 11:05 PM, Guillaume Lelarge
guilla...@lelarge.infowrote:
On Wed, 2012-04-25 at 10:40 +0200, Willy-Bas Loos wrote:
On Wed, Apr 25, 2012 at 9:51 AM, Magnus Hagander
Thanks Thom, that's really useful to know however I've been unable to get
it working with pg_dump either. Are you able to offer any insight there?
What command line options are you using?
I get the same result with:
pg_dump -o mydatabase
pg_dump mydatabase
Thanks again, Matt
-Original
On 1 May 2012 11:55, Matthew Churcher matthew.churc...@realvnc.com wrote:
Thanks Thom, that's really useful to know however I've been unable to get
it working with pg_dump either. Are you able to offer any insight there?
What command line options are you using?
I get the same result with:
OK, I think I've worked out what's going on. I've got my wires crossed
between table column OIDS (deprecated) and the OID which uniquely identifies
each table (?always enabled?).
We're not using OID for each column, only to reference the tables themselves
as that's how triggers are referring to
On 1 May 2012 11:22, Thom Brown t...@linux.com wrote:
On 1 May 2012 11:12, Matthew Churcher matthew.churc...@realvnc.com wrote:
Hi PostgreSQL users,
I'm having difficulty migrating a postgres 8.4.11 database to postgres
9.1.2, neither of the included pg_dumpall tools appear to honour the -o
On 1 May 2012 12:37, Matthew Churcher matthew.churc...@realvnc.com wrote:
OK, I think I've worked out what's going on. I've got my wires crossed
between table column OIDS (deprecated) and the OID which uniquely identifies
each table (?always enabled?).
We're not using OID for each column,
Thanks Joe and John,
You are right. I all needed was that dev package. On Ubuntu 4.4.3. I
ran: sudo apt-get install postgresql-server-dev-9.1
and then ran through the PLR install with no problem.
Thanks so much for the help.
Daniel
The triggers are being used to track changes to the tables. The developers
are concerned that using string references for the table names in this case
would create too much overhead as this is a frequent operation and is
performance critical.
Sounds like we have the choice of using string names
Hi there,
I have mission-critical data running on PostgreSQL 8.3. My database got
corrupted a few days ago as I ran out of disk space.
I had to run pg_resetxlog to get the database started again. I am now
experiencing the following errors:
1. ERROR: t_xmin is uncommitted in tuple to be updated
We recently installed the GreenPlum massively Parallel Appliance which
is using Postgres version 8.2.15 and I have been asked to provide a
security report showing all user and group roles and the access they
have to the user data and views. In the Postgres catalog tables I have
located the tables
Matthew Churcher matthew.churc...@realvnc.com writes:
The triggers are being used to track changes to the tables. The developers
are concerned that using string references for the table names in this case
would create too much overhead as this is a frequent operation and is
performance
On 05/01/2012 05:06 AM, Matthew Churcher wrote:
The triggers are being used to track changes to the tables. The developers
are concerned that using string references for the table names in this case
would create too much overhead as this is a frequent operation and is
performance critical.
Merlin Moncure wrote:
On Mon, Apr 30, 2012 at 1:47 AM, Alexander Reichstadt l...@mac.com wrote:
Hi,
From the documentation I was able to build a trigger firing upon deletion of a
record a function that delivers tablename_operation as a notification one needs
to subscribe to. So in terminal I
Hi, take a look at pg_class table, column relacl
http://www.postgresql.org/docs/8.2/static/catalog-pg-class.html
The opposite way (does a user has privilages to...) is set of build in
functions
http://www.postgresql.org/docs/8.2/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
hope this
2012/4/26 Tom Lane t...@sss.pgh.pa.us
I've applied a patch for this. Thanks for the report!
regards, tom lane
Thanks for Your time :)
Regards,
Bartek
I would like to prevent overlapping dates ranges for col1 + col2 from
being inserted into my test table.
Existing Data:
1, FOO, 2012-04-04, 2012-04-06
Insert Attempts:
1, FOO, 2012-04-05, 2012-04-08 -- BAD, overlaps w/ above!
1, BAR, 2012-04-04, 2012-04-06 -- OK, no conflict!
2, FOO, 2012-04-04,
On Tue, May 1, 2012 at 10:15 AM, bradford fingerm...@gmail.com wrote:
I'm trying to used what I learned in
http://www.depesz.com/2010/01/03/waiting-for-8-5-exclusion-constraints/,
but I cannot figure out how to apply this exclusion constraint to col1
(integer) + col2 (varchar).
Take a look at
Thanks, Richard, but mostly through just guessing. I need to research
what GIST is and how the addition of col1 and col2 to that is making
this work.
With
psql -d mytest -c CREATE EXTENSION btree_gist;
This seems to work now:
CREATE TABLE test (
id INTEGER NOT NULL DEFAULT
Hi,
I played with this problem few months ago and found out that
mulitidimentional cube could be a solution (
http://www.postgresql.org/docs/9.1/static/cube.html).
If You have col1 and date1, date2 then Your cube is a simple line in 2
dimensional space - axis: col1, date (line between points X,
Hi
I think for overlaping exclusion constraint you need period extension
or range datatype in 9.2
Kind Regards,
Misa
Sent from my Windows Phone
From: bradford
Sent: 01/05/2012 19:16
To: pgsql-general@postgresql.org
Subject: [GENERAL] How do I setup this Exclusion Constraint?
I would like to
hi
I want to install madlib into a postgresql9.1.3 installation.
i am trying to:
a) make python2.7
b) configure postgresql to point at the python2.7 working directory, and
c) install postgresql9.1.3 (using python2.7)
no success to date.
to date my steps have been:
1. configure/make python2.7
The framework I am using is PGSQLKit for Mac OS X for which the source was
available and which I downloaded and altered since. Actually it gives you
access down to the pqlib calls.
The connection being closed was one of the issues. I had added convenience
classes with class methods to the
Some of my functions are running much slower than doing the same query
inline and I'd like to know if there's a way to fix that.
I have a number of tables that store data valid at different times. For
each logical entity there may be multiple rows, valid at different times
(sometimes
On Wed, May 2, 2012 at 12:43 PM, Evan Martin
postgre...@realityexists.net wrote:
Some of my functions are running much slower than doing the same query
inline and I'd like to know if there's a way to fix that.
[chomp analysis and examples]
Is there any possibility that you could recode your
Evan Martin postgre...@realityexists.net writes:
Some of my functions are running much slower than doing the same query
inline and I'd like to know if there's a way to fix that. ...
This is quite slow, especially when I have a WHERE clause that narrows
down the set of rows from 100,000 to 10
On tis, 2012-05-01 at 12:56 -0700, Mark Rostron wrote:
hi
I want to install madlib into a postgresql9.1.3 installation.
i am trying to:
a) make python2.7
b) configure postgresql to point at the python2.7 working directory,
and
c) install postgresql9.1.3 (using python2.7)
cd
Hi,
I got very inefficient plan for a simple query.
PostgreSQL 9.0.7 on FreeBSD, default_statistics_target=1000
Table:
Game2=# \d sb_messages
Table public.sb_messages
Column| Type
|Modifiers
Maxim Boguk maxim.bo...@gmail.com writes:
I got very inefficient plan for a simple query.
It looks like the problem is with the estimate of the antijoin size:
- Nested Loop Anti Join (cost=0.00..24576.82 rows=1 width=206)
(actual time=0.043..436.386 rows=20761 loops=1)
that is,
On Wed, May 2, 2012 at 2:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I got very inefficient plan for a simple query.
It looks like the problem is with the estimate of the antijoin size:
- Nested Loop Anti Join (cost=0.00..24576.82 rows=1
Thanks, Tom (and Chris). Yes, the EXPLAIN output showed a function scan:
SELECT * FROM thing_asof('2012-04-01') WHERE timeslice_id = 1234
Function Scan on thing_asof (cost=0.25..12.75 rows=5 width=353)
Filter: ((timeslice_id)::integer = 12345)
I replaced the OVERLAPS with and = comparisons
On Wed, May 2, 2012 at 2:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Maxim Boguk maxim.bo...@gmail.com writes:
I got very inefficient plan for a simple query.
It looks like the problem is with the estimate of the antijoin size:
- Nested Loop Anti Join (cost=0.00..24576.82 rows=1
34 matches
Mail list logo