Hi,
I have a cluster of 3 nodes Primary is connected by StandbyA (streaming),
Standby A is connected by Standby B (streaming).
I failed over the cluster
1) stop primary
2) promoted StandbyA
Now i see from syslog on Standby B that it is complaining about the
timeline mismatch.
Replication Status f
I am looking for advice on a performance problem. I'm pretty sure that the
culprit of my slow performance is a view that is several hundred million
records in size. Because it is a view, I can only index the underlying table,
but because the view generates an "un-pivoted" version of the underlyi
On Wednesday, January 16, 2013, Vraj Mohan wrote:
> Is there a good sample database (with decent data volumes) for
> postgresql? I am interested in one for learning and automated testing.
>
What do you mean by decent data volumes? Numbers and units are wonderful
things!
What things are you look
Whatever you did to get 1 million points a day on your site.. I want in..
the name of your marketer please!
I agree with condensing this into a heatmap or a set of RRDs.. one for X..
one for Y.. one for x * (y * max_height)). You can easily query RRDs later
on.. even multiple RRD files at once.
Em 16/01/2013 13:56, Edson Richter escreveu:
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see all statements issued by my
appli
On Wed, Jan 16, 2013 at 03:06:41PM -0800, Charles Porter wrote:
> I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
>
> Both 8.4 and 9.2 have been installed with the installers for OSX from
> EnterpriseDB
>
> Both have been stopped.
>
> As user postgres, I run the pg_upgrade com
> Instead of storing x/y, have you considered referencing a region of pixels?
The bigger the region, the larger your possible savings.
Good idea, but I don't always have all points and regions will not be fully
filled
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Ho
> convert it into a heatmap at the end of each day.
How to do it with Postgresql?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5740076.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via
It is not possible because connection is local variable in both thread
functions, no common variables are used.
I checked that it also crashes without SSL. Two threads connecting to the same
server, different databases.
Joanna
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Robert James wrote
> On 1/13/13, Chris Angelico <
> rosuav@
> > wrote:
>> On Mon, Jan 14, 2013 at 3:37 PM, Robert James <
> srobertjames@
> >
>> wrote:
>>> Thanks. But how do I do that where I have many literals? Something
>>> like:
>>>
>>> INSERT INTO seltest (id, a, b) SELECT (1,2,3),(4,5,6)
Robert James writes:
> SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL AND true
> -- Gives this error:
> ERROR: argument of AND must not return a set
> SQL state: 42804
> Can anyone make heads or tails of it? Is it a real bug? Is there a work
> around?
It's not a bug: regexp_matches re
I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
Both 8.4 and 9.2 have been installed with the installers for OSX from
EnterpriseDB
Both have been stopped.
As user postgres, I run the pg_upgrade command and get the error
'old and new pg_controldata alignments are invalid or do
On Jan 16, 2013, at 12:23 PM, Robert James wrote:
> Is there a recommended, high performance method to check for subdomains?
>
> Something like:
> - www.google.com is subdomain of google.com
> - ilikegoogle.com is not subdomain of google.com
>
> There are many ways to do this (lowercase and re
On 15.01.2013, at 17:32, Jeff Janes wrote:
> T.E., Fortunately in point releases from August 2012 (9.0.9, 9.1.5,
> etc.), the default server log settings will log both the cancel and
> the command triggering the cancel. So if you are running an up to
> date server, you can just look in the logs
On 15.01.2013, at 16:36, Tom Lane wrote:
> "T. E. Lawrence"
> > So, apparently, we need to interrupt the heavy imports on some reasonable
>> intervals and do manual VACUUM ANALYZE?
>
> Data import as such, no matter how "heavy", shouldn't be a problem.
> The question is what are you doing tha
I've been getting a funny SQL error, which I've boiled down to this case.
SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL
-- Returns true, as expected
SELECT (regexp_matches('abc', '(.)b(.)'))[1] IS NOT NULL AND true
-- Gives this error:
ERROR: argument of AND must not return a set
SQL s
On Wed, Jan 16, 2013 at 03:23:30PM -0500, Robert James wrote:
> Is there a recommended, high performance method to check for subdomains?
>
> Something like:
> - www.google.com is subdomain of google.com
> - ilikegoogle.com is not subdomain of google.com
>
> There are many ways to do this (lowerca
>From the Microsoft site I learned
http://msdn.microsoft.com/en-us/library/ms188046(v=sql.105).aspx
that they combine collation and "ComparisonStyle" to a collation name.
I thought that case insensitivity had to be built into the collation, but
apparently MS built case sensitivity in the database
Marcel van Pinxteren writes:
> Therefore the question: are there plans to create a set of case
> insensitive, and maybe also accent insensitive collations in the near
> future?
Not from the Postgres project -- we just use the collations supplied by
the operating system.
r
The subject has been discussed on this mailing list before, recently.
To be able to switch from SQL Server to Postgresql, for me this is
essential.
Therefore the question: are there plans to create a set of case
insensitive, and maybe also accent insensitive collations in the near
future?
I have n
On 01/16/2013 08:20 AM, Brian Sutherland wrote:
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
On 01/14/2013 08:30 AM, Brian Sutherland wrote:
I had a look at the files open by the process, there were not that many,
so no leaks or anything. Just an utterly insane OSX default
Em 16/01/2013 14:18, Tom Lane escreveu:
Pavel Stehule writes:
2013/1/16 Edson Richter :
I was wondering, would be a nice addition the ability to read the chain of
triggers (may be another trigger variable like TG_OP, called "TG_CHAIN" or
something else that will be an array with the name of th
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
> On 01/14/2013 08:30 AM, Brian Sutherland wrote:
> >Hi,
> >
> >I have a plpython stored procedure which sometimes fails when I run my
> >applications automated test suite. The procedure is called hundreds of
> >times during the tests b
On 01/15/2013 07:08 PM, Meta Seller Dev/Admin wrote:
On Wed, Jan 16, 2013 at 11:45 AM, Rob Sargent wrote:
What environment are you in. In jdbc you can address the resultset by
column name.
C++, so it's quite inefficient to always use names.
Chris Angelico
Craft you're own metadata/lookup
Pavel Stehule writes:
> 2013/1/16 Edson Richter :
>> I was wondering, would be a nice addition the ability to read the chain of
>> triggers (may be another trigger variable like TG_OP, called "TG_CHAIN" or
>> something else that will be an array with the name of the triggers called
>> before curre
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see all statements issued by my
application, but the statements in trigger don't sh
On Wed, Jan 16, 2013 at 9:53 AM, Vraj Mohan wrote:
> Is there a good sample database (with decent data volumes) for
> postgresql? I am interested in one for learning and automated testing.
>
> I looked at http://pgfoundry.org/projects/dbsamples/ (specifically at
> pagila), but it seemed incomplete
Is there a good sample database (with decent data volumes) for
postgresql? I am interested in one for learning and automated testing.
I looked at http://pgfoundry.org/projects/dbsamples/ (specifically at
pagila), but it seemed incomplete and not maintained,
I also looked at http://dev.mysql.com/d
On 01/15/2013 09:16 PM, John R Pierce wrote:
On 1/15/2013 9:02 PM, Robert James wrote:
I would do this as actual databases, but Postgres doesn't allow JOINs
and FKs between different databases. Can I use schema for the above?
How? How do I backup and restore schema independently?
pg_dump --sc
- Original Message -
From: "Stuart Bishop"
To: "Bruce Momjian"
Cc: "Scott Marlowe" , "SUNDAY A. OLUTAYO"
, "Gavin Flower" , "Chris
Ernst" , pgsql-general@postgresql.org
Sent: Wednesday, January 16, 2013 1:00:56 PM
Subject: Re: [GENERAL] Linux Distribution Preferences?
> On Sun, Jan 13
On Wed, Jan 16, 2013 at 08:10:26AM +1100, Chris Angelico wrote:
> On Tue, Jan 15, 2013 at 4:55 AM, Brian Sutherland
> wrote:
> > I'm guessing that it's some kind of race condition, but I wouldn't know
> > where to start looking.
>
> Look for a recursive import (A imports B, B imports A)
I've al
> On Sun, Jan 13, 2013 at 08:46:58PM -0700, Scott Marlowe wrote:
>> The reasons to NOT use ubuntu under PostgreSQL are primarily that 1:
>> they often choose a pretty meh grade kernel with performance
>> regressions for their initial LTS release. I.e. they'll choose a
>> 3.4.0 kernel over a very s
2013/1/16 Edson Richter :
> I was wondering, would be a nice addition the ability to read the chain of
> triggers (may be another trigger variable like TG_OP, called "TG_CHAIN" or
> something else that will be an array with the name of the triggers called
> before current trigger).
-1
building dy
33 matches
Mail list logo
