Hi Michael ,
Thank you for your information!!
I understand.
I'll consider to upgrade to 9.4.5.
I'm grateful for all your support.
Yoji
--
View this message in context:
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880550.html
Sent from the PostgreSQL - general
2016-01-06 8:08 GMT+01:00 Oleg Bartunov :
>
>
> On Wed, Jan 6, 2016 at 7:41 AM, Jim Nasby
> wrote:
>
>> On 1/5/16 10:03 PM, John R Pierce wrote:
>>
>>> On 1/5/2016 5:31 PM, Jim Nasby wrote:
>>>
IMHO, the real problem here is not simply a CoC, it is that the
Postgres community doesn't fo
On Wed, Jan 6, 2016 at 7:41 AM, Jim Nasby wrote:
> On 1/5/16 10:03 PM, John R Pierce wrote:
>
>> On 1/5/2016 5:31 PM, Jim Nasby wrote:
>>
>>> IMHO, the real problem here is not simply a CoC, it is that the
>>> Postgres community doesn't focus on developing the community itself.
>>> The closest we
On 1/5/2016 6:13 PM, Joshua D. Drake wrote:
On 01/05/2016 05:31 PM, Jim Nasby wrote:
Well, that highlights that it's not just about a CoC, it's the things
that surround it. Especially what the conflict resolution policy is.
I suspect JD thought about this because of a recent Facebook thread[1]
On Tue, 2016-01-05 at 22:41 -0600, Jim Nasby wrote:
> On 1/5/16 10:03 PM, John R Pierce wrote:
> > On 1/5/2016 5:31 PM, Jim Nasby wrote:
> >> IMHO, the real problem here is not simply a CoC, it is that the
> >> Postgres community doesn't focus on developing the community itself.
> >> The closest w
> On 6 Jan 2016, at 03:47, Joshua D. Drake wrote:
>
> In reflection, the only thing a CoC does is put in writing what behaviour we
> as a project already require, so why not document it and use it as a tool to
> encourage more contribution to our project?
I fully agree with you. No one would
On 1/1/16, Andrew Bailey wrote:
> I would like to do the following:
>
> select id, row_number() over w as rownum, lag(id, 1) over w as prev,
> lead(id, 1) over w as next from route where id=1350 window w as (order by
> shortname, id asc rows between 1 preceding and 1 following) order by
> shortna
On 2 January 2016 at 16:39, Andrew Bailey wrote:
> I would like to do the following:
>
> select id, row_number() over w as rownum, lag(id, 1) over w as prev,
> lead(id, 1) over w as next from route where id=1350 window w as (order by
> shortname, id asc rows between 1 preceding and 1 following)
On 1/1/16 9:39 PM, Andrew Bailey wrote:
select id, row_number() over w as rownum, lag(id, 1) over w as prev,
lead(id, 1) over w as next from route where id=1350 window w as (order
by shortname, id asc rows between 1 preceding and 1 following) order by
shortname, id ;
However this gives the resul
On 1/5/16 10:03 PM, John R Pierce wrote:
On 1/5/2016 5:31 PM, Jim Nasby wrote:
IMHO, the real problem here is not simply a CoC, it is that the
Postgres community doesn't focus on developing the community itself.
The closest we come to "focus" is occasional talk on -hackers about
how we need more
On 1/5/2016 5:31 PM, Jim Nasby wrote:
IMHO, the real problem here is not simply a CoC, it is that the
Postgres community doesn't focus on developing the community itself.
The closest we come to "focus" is occasional talk on -hackers about
how we need more developers. There is no formal
discu
Hi Adrian,
Thank you very much for that link. It confirms what JD and John said, plus
explains couple other moments to me.
Thanks,
Oleg
On Tue, Jan 5, 2016 at 7:04 PM, Adrian Klaver
wrote:
> On 01/05/2016 04:12 PM, oleg yusim wrote:
> > Hi Adrian,
> >
> > I meant a scenario, when user is tryi
On 1/4/16 12:18 PM, Luke Coldiron wrote:
Is there a way to achieve the performance of the COPY FROM STDIN command
within a C extension function connected to the db connection that called
the C function? I have text that I would like to receive as input to a C
function that contains many COPY comm
On 1/1/16 4:11 AM, Thomas Kellerer wrote:
You only need to provide the text value to be casted (no format mask).
Use only a single expression without those unnecessary parentheses:
SELECT gmt_date||' '||lpad(gmt_time,8,'0')::timestamp
You don't need the lpad() either:
SELECT gmt_date
On 1/5/16 8:13 AM, Mohammed Ajil wrote:
Now my problem consists of two steps:
- First I need to decide if the algorithm supports the trigger type
(only of LANGUAGE PLPGSQL).
plpgsql is NOT the only language that supports triggers.
- Second I need to get the SQL command that the function will
On 1/4/16 7:40 PM, Adrian Klaver wrote:
or even better yet could you post the section of the log above the error?
The server log itself might be useful, especially if full query logging
was turned on. Dunno how easy/possible that is with pg_upgrade.
--
Jim Nasby, Data Architect, Blue Treble C
On 01/05/2016 05:31 PM, Jim Nasby wrote:
Well, that highlights that it's not just about a CoC, it's the things
that surround it. Especially what the conflict resolution policy is.
I suspect JD thought about this because of a recent Facebook thread[1]
about how the FreeBSD community just screwed
On Wed, Jan 6, 2016 at 9:27 AM, Yoji wrote:
> Hi Andreas and Michael,
>
> Thank you for your information!
>
> Let me know, which should I choose update to 9.4.5
Updating to 9.4.5 is highly recommended, and a separate issue.
> or hot_standby_feedback off?
Switching hot_standby_feedback to off de
On 1/5/16 6:32 PM, Scott Marlowe wrote:
I don't think I am a good person to rationalize their reasoning because I
>don't like the idea of a CoC. That said, I think a lot of boils down to
>perception, responsibility, accountability and the fact that a lot of people
>are flat out jerks. I am not ta
Hi Joe,
Exactly how I marked it :)
Thanks,
Oleg
On Tue, Jan 5, 2016 at 6:50 PM, Joe Conway wrote:
> On 01/05/2016 04:32 PM, John R Pierce wrote:
> > On 1/5/2016 4:12 PM, oleg yusim wrote:
> >> I meant a scenario, when user is trying to connect to database
> >> (doesn't matter what interface)
John,
Thanks, what you are saying makes sense. I agree, it would cause all user
to go through authentication/authorization loop all over and terminate all
running transactions too.
Thanks,
Oleg
On Tue, Jan 5, 2016 at 6:32 PM, John R Pierce wrote:
> On 1/5/2016 4:12 PM, oleg yusim wrote:
>
> I
On 01/05/2016 04:12 PM, oleg yusim wrote:
> Hi Adrian,
>
> I meant a scenario, when user is trying to connect to database (doesn't
> matter what interface) and database fails at this moment. If all
> authentication/authorization/validation functions are written to return
> false in case of abno
On Wed, Jan 6, 2016 at 6:09 AM, Joshua D. Drake wrote:
> On 01/05/2016 11:08 AM, Roland van Laar wrote:
>> On January 5, 2016 5:47:16 PM GMT+01:00, "Joshua D. Drake"
>> wrote:
>>> I had a hard time writing this email. I think Code of Conducts are
>>> non-essential, a waste of respectful people's
On 01/05/2016 04:32 PM, John R Pierce wrote:
> On 1/5/2016 4:12 PM, oleg yusim wrote:
>> I meant a scenario, when user is trying to connect to database
>> (doesn't matter what interface) and database fails at this moment. If
>> all authentication/authorization/validation functions are written to
>>
On 01/05/2016 09:17 AM, Belju Paul wrote:
Please include list in replies.
Yes plv8.dll exists. I found plv8 downloads for win 32 and for win 64
bit. But there is a difference in file count in bin folder. The exe file
d8.exe is absent in win32 bit down load file.
I downloaded and installed th
On 1/5/2016 4:12 PM, oleg yusim wrote:
I meant a scenario, when user is trying to connect to database
(doesn't matter what interface) and database fails at this moment. If
all authentication/authorization/validation functions are written to
return false in case of abnormal termination, we are f
On Tue, Jan 5, 2016 at 2:09 PM, Joshua D. Drake wrote:
> On 01/05/2016 11:08 AM, Roland van Laar wrote:
>>
>>
>>
>> On January 5, 2016 5:47:16 PM GMT+01:00, "Joshua D. Drake"
>> wrote:
>>>
>>> Hello,
>>>
>>> I had a hard time writing this email. I think Code of Conducts are
>>> non-essential, a w
Hi Andreas and Michael,
Thank you for your information!
Let me know, which should I choose update to 9.4.5 or hot_standby_feedback
off?
Best regards.
Yoji
--
View this message in context:
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880487.html
Sent from the Postg
Hi Adrian,
I meant a scenario, when user is trying to connect to database (doesn't
matter what interface) and database fails at this moment. If all
authentication/authorization/validation functions are written to return
false in case of abnormal termination, we are fine. If not, we can
potentially
Thanks JD.
Let me confirm I got you right. So, by exception you mean the
authentication/authorization/validation functions would return false in
case of DB failure?
Thanks,
Oleg
On Tue, Jan 5, 2016 at 5:33 PM, Joshua D. Drake
wrote:
> On 01/05/2016 03:21 PM, oleg yusim wrote:
>
>> Thanks JD.
On 01/05/2016 03:21 PM, oleg yusim wrote:
Thanks JD.
From what I read about WAL (you have been referring to this:
http://www.postgresql.org/docs/current/static/wal-internals.html
pg_xlog, right?) it allows us to know what happened, but does it
warranty known secure state? I mean, I do not think
On 01/05/2016 03:21 PM, oleg yusim wrote:
Thanks JD.
From what I read about WAL (you have been referring to this:
http://www.postgresql.org/docs/current/static/wal-internals.html
pg_xlog, right?) it allows us to know what happened, but does it
warranty known secure state? I mean, I do not think
Thanks JD.
>From what I read about WAL (you have been referring to this:
http://www.postgresql.org/docs/current/static/wal-internals.html pg_xlog,
right?) it allows us to know what happened, but does it warranty known
secure state? I mean, I do not think it would help with this:
"In general, secu
On 01/05/2016 03:09 PM, oleg yusim wrote:
The question here, what is PostreSQL 9.4.5 (hosted on Linux box)
behavior? Does it fail to known/secure state in these 3 cases? I tried
to find the description of the way PostgreSQL fails in this regard, but
didn't find much.
Based on what you paste
Greetings,
One more security requirement I'm battling with:
The DBMS must fail to a secure state if system initialization fails,
shutdown fails, or aborts fail.
Failure to a known state can address safety or security in accordance with
the mission/business needs of the organization.
Failure t
On 01/05/2016 11:08 AM, Roland van Laar wrote:
On January 5, 2016 5:47:16 PM GMT+01:00, "Joshua D. Drake"
wrote:
Hello,
I had a hard time writing this email. I think Code of Conducts are
non-essential, a waste of respectful people's time and frankly if you
are going to be a jerk, our commun
On Tue, Jan 5, 2016 at 1:59 AM, Alban Hertroys wrote:
> with list_of_ids as (
> select unnest(list_of_ids) as id from table
> )
> select a.id, b.id
> from list_of_ids a, list_of_ids b
> where b.id > a.id;
Or, to morph this to array output (which the OP seemed to want):
test=# with list_of_
Steve Rogerson writes:
> On 05/01/16 19:47, Tom Lane wrote:
>> That's operating as designed. A unique constraint needs an index,
>> but not vice versa.
> I can see that might be plausible , hence the question but as a "unique index"
> imposes as constraint they seem equivalent. What's the functi
On Tuesday, January 5, 2016, Steve Rogerson
wrote:
> On 05/01/16 19:47, Tom Lane wrote:
> > Steve Rogerson > writes:
> >> Is this a bug? I create a "unique" index, directly but it doesn't add a
> unique
> >> constraint. Add a unique constraint and it adds the index and the
> constraint.
> >
> > T
On 05/01/16 19:47, Tom Lane wrote:
> Steve Rogerson writes:
>> Is this a bug? I create a "unique" index, directly but it doesn't add a
>> unique
>> constraint. Add a unique constraint and it adds the index and the constraint.
>
> That's operating as designed. A unique constraint needs an index,
Steve Rogerson writes:
> Is this a bug? I create a "unique" index, directly but it doesn't add a unique
> constraint. Add a unique constraint and it adds the index and the constraint.
That's operating as designed. A unique constraint needs an index,
but not vice versa.
r
On January 5, 2016 5:47:16 PM GMT+01:00, "Joshua D. Drake"
wrote:
>Hello,
>
>I had a hard time writing this email. I think Code of Conducts are
>non-essential, a waste of respectful people's time and frankly if you
>are going to be a jerk, our community will call you out on it.
>Unfortunatel
On 01/05/2016 09:06 AM, Adrian Klaver wrote:
Brendan Eich fiasco
Has absolutely nothing to do with a CoC. At least from my understanding
of what happened.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and developm
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> In reflection, the only thing a CoC does is put in writing what
> behaviour we as a project already require, so why not document it and
> use it as a tool to encourage more contribution to our project?
+1, been thinking about this same thin
Is this a bug? I create a "unique" index, directly but it doesn't add a unique
constraint. Add a unique constraint and it adds the index and the constraint.
(pg version 9.4.5 on fedora 22, but also occurs in other versions).
Functionally I can't see a difference.
mydb=# create table test_table ( f
On 01/05/2016 09:02 AM, Belju Paul wrote:
Ccin list
Both Postgre 9.4 and plv8 are downloaded from postgre site
So does plv8.dll exist?
Belju Paul
On Jan 5, 2016 9:30 PM, "Adrian Klaver" mailto:adrian.kla...@aklaver.com>> wrote:
On 01/05/2016 12:56 AM, Belju Paul wrote:
Hi,
Please read the links below:
http://www.depesz.com/2007/08/29/better-results-paging-in-postgresql-82/
https://wiki.postgresql.org/wiki/File:Pagination_Done_the_PostgreSQL_Way.pdf
https://coderwall.com/p/lkcaag
I am reading the articles right now.
>There are about 35 milion records in the ta
On 01/05/2016 08:47 AM, Joshua D. Drake wrote:
Hello,
I had a hard time writing this email. I think Code of Conducts are
non-essential, a waste of respectful people's time and frankly if you
are going to be a jerk, our community will call you out on it.
Unfortunately a lot of people don't agree
On 01/05/2016 08:56 AM, Melvin Davidson wrote:
Joshua,
I have to agree that a COC is in order. But to add to that, I would like
to see basic requirements when submitting a problem.
IE: 1. Version of PostgreSQL
2.. O/S
3. Enough info to duplicate the problem EG: minimal schema & data
Joshua,
I have to agree that a COC is in order. But to add to that, I would like to
see basic requirements when submitting a problem.
IE: 1. Version of PostgreSQL
2.. O/S
3. Enough info to duplicate the problem EG: minimal schema & data
On Tue, Jan 5, 2016 at 11:47 AM, Joshua D. Drake
Hello,
I had a hard time writing this email. I think Code of Conducts are
non-essential, a waste of respectful people's time and frankly if you
are going to be a jerk, our community will call you out on it.
Unfortunately a lot of people don't agree with that. I have over the
course of the las
Em 05/01/2016 11:42, Riley Berton escreveu:
Edson Richter writes:
BTW, I'm also looking for a "synchronous multi-master" solution... If
you find one, please share :-)
The only solution I've found so far is a middleware that is close, the
C-Jdbc/Sequoia, which seems not being actively maintaine
Dear Postgres Team,
For my thesis about secure access control for database systems I need to
implement a new decision algorithm for deciding if commands can be
executed. For that algorithm to work I need to keep a stack that holds
all the commands that are currently running, like a stacktrace.
Ea
Hi,
I'm installing BDR on a ubuntu 14.04 (Trusty) machine. I can reproduce
this error.
It happens locally with a new VM and on Digital ocean.
The error is:
/var/lib/dpkg/info/postgresql-bdr-9.4.postinst: 95:
/var/lib/dpkg/info/postgresql-bdr-9.4.postinst: db_stop: not found
How can I fix th
On 01/04/2016 06:07 PM, John Hong wrote:
Hello Everyone,
On 2015/12/30 17:51:01, Transaction was failed on our system.
I checked the pg_log, it states as below:
2015-12-30 17:51:01 CST [11260]: [42-1] LOG: 0: server process (PID
14272) was terminated by signal 11: Segmentation fault
Just to add a final resolution to this thread, my solution was to add "use
Net::SSL" to the top of my script. Even though my script does not use SSL
directly, I think this must have helped in loading the libraries in an
order that let everything work.
Thanks for the help
iGLASS Networks
www.igla
Edson Richter writes:
> BTW, I'm also looking for a "synchronous multi-master" solution... If
> you find one, please share :-)
> The only solution I've found so far is a middleware that is close, the
> C-Jdbc/Sequoia, which seems not being actively maintained for a while
> now.
See Postgres-R
Grzegorz Kuczera wrote:
> This is my first question here, so I would like to say hello to everyone:)
>
> In my case, the problem appears when I want to fetch some data to inflate the
> table with it. First of all, I am counting the records from the table (for
> paging, over indexed column), then
This is my first question here, so I would like to say hello to everyone:)
In my case, the problem appears when I want to fetch some data to
inflate the table with it. First of all, I am counting the records from
the table (for paging, over indexed column), then the select query is
performed (
Michael Paquier wrote:
> As Andreas has already outlined, as hot_standby_feedback is enabled
> the master has to wait for the slave and the slave cannot replay from
> the master as transactions are running on the hot standby.
Oh, thanks for the confirmation ;-) (wasn't really sure)
Andreas
--
On Tue, Jan 5, 2016 at 5:13 PM, Yoji wrote:
> I'm using version of 9.4.3.
You should update to 9.4.5 as soon as possible.
> And I have seen same behavior on version of 9.3.4.
As Andreas has already outlined, as hot_standby_feedback is enabled
the master has to wait for the slave and the slave
Makes sense.
Thank you both for clarifications!
Was only wondering if this feature is there so I could elegantly do
equivalent of perl's (small 'a', anycase 'sd', small 'f'):
$,="\n";
my $testr='1asdf
2AsdF
3AsDF
4asDf
5aSDf
6aSdf
7ASdf
8Asdf';
my @res = $testr =~ /a(?i:sd)f/g;
print @res;
-
a
Thanks to John for your remarks. My reply is posted below.
Steve
- Original Message -
From: "John R Pierce"
To:
Sent: Sunday, January 03, 2016 4:40 PM
Subject: Re: [GENERAL] Question -- Session Operations - Feasibility Of
Proposed Synchronization Method?
On 1/3/2016 1:32 PM, Melvi
Thanks to Adrian for your remarks. My replies are posted below.
Steve
- Original Message -
From: "Adrian Klaver"
To: "Melvin Davidson" ; "Pavel Stehule"
Cc: "Steve Petrie, P.Eng." ;
Sent: Sunday, January 03, 2016 4:38 PM
Subject: Re: [GENERAL] Question -- Session Operations - Feasib
Thanks to Melvin for your remarks. My reply is posted below.
Steve
From: "Melvin Davidson"
Sent: Sunday, January 03, 2016 4:32 PM
More to the point, if you absolutely must
store session data, then why not just do it in a TEMPORARY table, which
will reside in memory and clean itself up when the
Thanks to Pavel for your remarks. My reply is posted below.
Steve
- Original Message -
From: "Pavel Stehule"
To: "Steve Petrie, P.Eng."
Cc:
Sent: Sunday, January 03, 2016 3:43 PM
Subject: Re: [GENERAL] Question -- Session Operations - Feasibility Of
Proposed Synchronization Method?
Andreas Kretschmer wrote:
> ok, i think it's clear now: because of running transactions on the
> standby (and hot_standby_feedback on) the master has to wait for the
> slave and can't replay all from the master.
Mhh. Maybe i'm wrong, can't reproduce that.
Andreas
--
Really, I'm not out to des
Hello Arjen.
Thank you for replying.
I'll try OR query on my environment.
Thanks.
2016年1月4日(月) 23:03 Arjen Nienhuis :
>
> On Jan 4, 2016 09:45, "Hiroyuki Sato" wrote:
> >
> > Hello Arjen
> >
> > Thank you for replying.
> >
> > 2016年1月4日(月) 16:49 Arjen Nienhuis :
> >>
> >>
> >> On Dec 28, 201
Yoji wrote:
> Hi, Andreas
>
> Thank you for replying.
>
> You're right, I have only 1 slave.
>
> And I need running transactions on slave.
> Once I restarted postgres service on slave and then process began to move.
ok, i think it's clear now: because of running transactions on the
standby (
Hi Michael,
Thank you for replying.
I'm using version of 9.4.3.
And I have seen same behavior on version of 9.3.4.
Best regards.
Yoji
--
View this message in context:
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880329.html
Sent from the PostgreSQL - general mai
Hi, Andreas
Thank you for replying.
You're right, I have only 1 slave.
And I need running transactions on slave.
Once I restarted postgres service on slave and then process began to move.
Best regards.
Yoji
--
View this message in context:
http://postgresql.nabble.com/Streaming-replicatio
> On 04 Jan 2016, at 21:08, Wells Oliver wrote:
>
> Hey all, happy new year.
>
> I am trying to get unique pairs from an array of N numbered items, usually 5,
> but possibly 4 or 6.
>
> If I just wanted unique values, I could do SELECT UNNEST(list_of_ids) AS id,
> COUNT(*) FROM table GROUP B
72 matches
Mail list logo
