So, should I fill a bug report?
With regards, Dmitry Samonenko.
On Wed, May 28, 2014 at 11:28:47PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote:
> >> So for my edification, does that mean -O ' -c
> >> config_file=/etc/postgresql/9.3/main/postgresql.conf' could cause a
> >> problem or that st
2014-05-24 8:54 GMT-03:00 Jack Douglas :
>
> If I’m using the Data Checksum feature (new to 9.3:
> https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Data_Checksums),
> and in the event of a checksum failure on a replication master, will that
> corrupt data replicate to slaves or will
Dmitry Samonenko writes:
> So, should I fill a bug report?
[ shrug... ] This is not a bug. It might be a feature request, but
I doubt that it's a feature anybody would be interested in implementing.
Adding timeouts to libpq would mean adding hard-to-test (and therefore
easy-to-break) logic paths
Hi all;
we have a client running PostgreSQL on windows, and they want to run
streaming replication with some sort of failover.
We have streaming replication in place, we thought we could use
pgbouncer and in the case of the master being down our heartbeat script
would reload the pgbouncer co
On Fri, May 30, 2014 at 6:08 PM, Tom Lane wrote:
[ shrug... ] This is not a bug. It might be a feature request, but
> I doubt that it's a feature anybody would be interested in implementing.
>
Don't count me out.
> Adding timeouts to libpq would mean adding hard-to-test (and therefore
> easy-
I'm using a JSON column to store some aggregate data, like so:
UPDATE courses_table
SET aggregates = agg.aggregates
FROM (
SELECT course_id, row_to_json(sub) AS aggregates
FROM (
SELECT course_id, avg(rating) AS rating, sum(reviews_count) AS
reviews_count,
On Fri, May 30, 2014 at 07:48:00PM +0400, Dmitry Samonenko wrote:
> > BTW, you might consider using libpq's nonblock mode to push the waiting
> > out to the application level, and then you could just decide when you've
> > waited too long for yourself.
> >
> Do you mean PQsendQuery / PQisBusy / PQg
Hi,
has anyone else had this issue and does any one know the solution?
Since upgrading my mac from os x 10.8 to 10.9, i can no long build postgres
with '--with-python’.
i get the following error.
ld: framework not found Python
clang: error: linker command failed with exit code 1 (use -v to see
Hi Reiner,
Latest PG 9.4 source code seems building fine with --with-python option on
my OS X 10.9.3 box i.e.
pc1dotnetpk:inst asif$ find . | grep -i python
> ./lib/plpython2.so
> ./share/extension/plpython2u--1.0.sql
> ./share/extension/plpython2u--unpackaged--1.0.sql
> ./share/extension/plpyth
On Fri, May 30, 2014 at 8:19 PM, Martijn van Oosterhout
wrote:
> I don't think the suggestion is to move to async command processing. I
> think the suggestion is to use those methods to make a
> PGgetResultWithTimeout() that does what you want.
>
> Have a nice day,
> --
> Martijn van Oosterhout
Dmitry Samonenko writes:
> Yeah, that will work. Looks simple to implement in the client. Question is:
> why don't you think it should be a part of the libpq's API? It's a must
> have feature in high availability environments where only several minutes
> of Out of Service per year are tolerable.
Il 30/05/14 18:49, reiner peterke ha scritto:
Hi,
has anyone else had this issue and does any one know the solution?
Since upgrading my mac from os x 10.8 to 10.9, i can no long build postgres
with '--with-python’.
i get the following error.
ld: framework not found Python
clang: error: linke
Asif Naeem writes:
> On Fri, May 30, 2014 at 9:49 PM, reiner peterke
> wrote:
>> Since upgrading my mac from os x 10.8 to 10.9, i can no long build
>> postgres with '--with-pythonâ.
> Latest PG 9.4 source code seems building fine with --with-python option on
> my OS X 10.9.3 box i.e.
[ pleas
On Fri, May 30, 2014 at 11:16 AM, Chris Hanks
wrote:
> I'm using a JSON column to store some aggregate data, like so:
>
> UPDATE courses_table
> SET aggregates = agg.aggregates
> FROM (
> SELECT course_id, row_to_json(sub) AS aggregates
> FROM (
> SELECT course_id,
On 05/30/2014 11:52 AM, Tom Lane wrote:
Asif Naeem writes:
On Fri, May 30, 2014 at 9:49 PM, reiner peterke
wrote:
Since upgrading my mac from os x 10.8 to 10.9, i can no long build
postgres with '--with-python’.
Latest PG 9.4 source code seems building fine with --with-python option on
m
That works! Thanks!
On Fri, May 30, 2014 at 11:59 AM, Merlin Moncure wrote:
> On Fri, May 30, 2014 at 11:16 AM, Chris Hanks
> wrote:
>> I'm using a JSON column to store some aggregate data, like so:
>>
>> UPDATE courses_table
>> SET aggregates = agg.aggregates
>> FROM (
>> SELE
Tom Lane-2 wrote
> Dmitry Samonenko <
> shreddingwork@
> > writes:
>> Yeah, that will work. Looks simple to implement in the client. Question
>> is:
>> why don't you think it should be a part of the libpq's API? It's a must
>> have feature in high availability environments where only several minu
Adrian Klaver writes:
> On 05/30/2014 11:52 AM, Tom Lane wrote:
>> If you do the ld call by hand without the -syslibroot option, it works.
>> AFAICS it could never have worked with such an option, so I'm thinking
>> this is some new misbehavior in the latest version of Xcode.
> There is and the S
On Friday, May 30, 2014, David G Johnston
wrote:
> Tom Lane-2 wrote
> > That argument seems nonsensical from here. If you need HA then you
> should
> > be using network service monitoring tools, not relying on some random
> > libpq client to decide that its connection has been lost.
I'm troub
Sorry, my last mail got truncated. I'm starting to like Gmail mobile.
On Saturday, May 31, 2014, Dmitry Samonenko wrote:
>
>
>> Though this then begs the question: if the connection comes back up what
>> happens in the client?
>
>
>
>> Depends on the state of the server. If problem was purely net
postgresql 8.1.11
we found the database can't be connected at 2014/5/9 23:00 and 2014/5/10
17:03 which you can see from below log. We checked the CUP and memory also,
it is normal. And the server generated many postmaster process at the
interrupted time. Untill we restart the database, it becomes n
Hello,
I am a newbee to Postgresql and I want to build replication between master
and slave servers(8.4). I was able to set it up but I cannot check archive#
at master and slave servers as what was the last archive# generated at
master and what is current archive# at Slave server that is being rep
Hi Satish,
You can calculate the replication lag by comparing the current WAL write
location on the primary with the last WAL location received/replayed by the
standby. They can be retrieved using pg_current_xlog_location on the
primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_loc
On 5/30/2014 1:59 AM, snowsnake wrote:
postgresql 8.1.11
hopelessly obsolete and long out of support. Also, note that 8.1
was updated until 8.1.23, so thats 12 bug release versions you've
missed, but 8.4 is the oldest version currently in support, and its soon
to be obsoleted.
we fou
On May 30, 2014, at 6:19 PM, Kapil Agarwal wrote:
> Slave server:
>
> select pg_last_xlog_receive_location();
>
not possible back in 8.4. you could just compare the output of the
pg_controldata command on both hosts.
On 05/30/2014 01:59 AM, snowsnake wrote:
postgresql 8.1.11
we found the database can't be connected at 2014/5/9 23:00 and 2014/5/10
17:03 which you can see from below log. We checked the CUP and memory also,
it is normal. And the server generated many postmaster process at the
interrupted time. U
On 05/30/2014 01:31 PM, Tom Lane wrote:
Adrian Klaver writes:
On 05/30/2014 11:52 AM, Tom Lane wrote:
If you do the ld call by hand without the -syslibroot option, it works.
AFAICS it could never have worked with such an option, so I'm thinking
this is some new misbehavior in the latest versio
Any one knows how sorting works?
I am using postgresql 9.3 and runs on Linux machines.
I see different sorting order for the same set of return data.
On linux machines, databases are configured the same.
Database have encoding set to 'utf8' and locale='C'
query:
Select host_id, host_name from ho
On May 30, 2014, at 5:13 PM, Quang Thoi wrote:
> Any one knows how sorting works?
>
> I am using postgresql 9.3 and runs on Linux machines.
> I see different sorting order for the same set of return data.
>
> On linux machines, databases are configured the same.
> Database have encoding set to
Thanks Steve!
Just want to get confirmation that postgres does not use any special rules
When no sorting order specified.
Thanks,
Quang.
On 5/30/14 5:20 PM, "Steve Atkins" wrote:
>
>On May 30, 2014, at 5:13 PM, Quang Thoi wrote:
>
>> Any one knows how sorting works?
>>
>> I am using pos
Quang Thoi wrote
> Thanks Steve!
>
> Just want to get confirmation that postgres does not use any special rules
>
> When no sorting order specified.
Didn't your testing prove that out sufficiently? I'd be more concerned,
though, if you took random congruence between the two results (I.e. If
32 matches
Mail list logo
