Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-20 Thread Venkata Balaji N
On Sat, May 21, 2016 at 1:04 AM, Tom Lane wrote: > Venkata Balaji N writes: > > "make" command is generating the following error while compiling > > postgresql-9.5.3 on Solaris SPARC. > > > Undefined first referenced > > symbol in file > > atomic

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-20 Thread Steve Atkins
> On May 20, 2016, at 1:43 PM, Guyren Howe wrote: > > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue > wrote: >> >> Le 04/05/2016 18:29, Szymon Lipiński a écrit : >>> On the other hand, when I was trying to store all my logic in a >>> database, there was just one thing that made me hat

Re: [GENERAL] PQcancel may hang in the recv call

2016-05-20 Thread Peter Juhasz
On Thu, 2016-05-19 at 15:32 -0400, Tom Lane wrote: > Peter Juhasz writes: > > > > We've found a situation where canceling a query may cause the > > client to > > hang, possibly indefinitely. This can happen if the network > > connection > > fails in a specific way. > > ... > > However, if the net

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-20 Thread Pierre Chevalier Géologue
Interesting conversation. While reading it, I sort of regret the times when a single guy was in charge of the whole thing, and managed to simply make it work, using all possible tools he had. "Informaticien" was the generic term, in French. Every single part of the big thing he built (hardwa

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-20 Thread Guyren Howe
On May 20, 2016, at 13:38 , Pierre Chevalier Géologue wrote: > > Le 04/05/2016 18:29, Szymon Lipiński a écrit : >> On the other hand, when I was trying to store all my logic in a >> database, there was just one thing that made me hate it. Testing. >> Testing the procedures inside the database wa

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-20 Thread Pierre Chevalier Géologue
Le 04/05/2016 18:29, Szymon Lipiński a écrit : On the other hand, when I was trying to store all my logic in a database, there was just one thing that made me hate it. Testing. Testing the procedures inside the database was not easy, not funny, and too much time consuming. Yes, very good point.

Re: [GENERAL] PostgreSql Doubts

2016-05-20 Thread George Neuner
On Fri, 20 May 2016 09:19:08 -0500, John McKown wrote: >I don't know much about FireBird. I (not a lawyer) think it has a very good >license. One interesting thing is that it says that it can run as a >"server", like PostgreSQL, or "embedded", like SQLite. But I can't really >figure out how the "

Re: [GENERAL] No warnings or errors after same sequential revoke

2016-05-20 Thread Tom Lane
Alex Ignatov writes: > Why we have no warnings or errors about that we have no such grant > after first revoke? Yes, that's intentional. There's no warning about granting twice in a row, either. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Debugging a backend stuck consuming CPU

2016-05-20 Thread k...@rice.edu
On Thu, May 19, 2016 at 05:52:26PM -0400, Tom Lane wrote: > "k...@rice.edu" writes: > > The stack trace just appeared to be what I would expect while a 'DISCARD > > ALL' > > command was being run: > > > #0 0x0073bc7c in MemoryContextSetParent () > > #1 0x0073bde3 in MemoryConte

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-20 Thread Michael Paquier
On Fri, May 20, 2016 at 11:04 AM, Tom Lane wrote: > src/include/port/atomics/generic-sunpro.h cites these references > as authority for believing that those functions exist in Solaris: > >http://www.unix.com/man-page/opensolaris/3c/atomic_cas/ >http://docs.oracle.com/cd/E23824_01/html/821-

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-20 Thread Tom Lane
Venkata Balaji N writes: > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solaris SPARC. > Undefined first referenced > symbol in file > atomic_cas_64 port/atomics.o > atomic_cas_32

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-20 Thread Michael Paquier
On Fri, May 20, 2016 at 10:38 AM, Jan de Visser wrote: > I would suggest reporting this on pgsql-hackers. I know some work was done on > the atomics over the last little while. If that's an issue (no sparc environment here), we're looking at b64d92f1 here that was new stuff in 9.5. -- Michael

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

2016-05-20 Thread Jan de Visser
On Friday, May 20, 2016 3:14:54 PM EDT Venkata Balaji N wrote: > Hi, > > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solaris SPARC. > > I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5. ... snip ... > > Regards, > Venkata B N >

Re: [GENERAL] PostgreSql Doubts

2016-05-20 Thread John McKown
On Fri, May 20, 2016 at 6:17 AM, aluka raju wrote: > Hello , > > 1) We are building an application where it needs a SQL engine to process > the data. We are evaluating whether to use postgreSQL along with the > foreign data wrappers. Can you please help us in letting know if postgreSQL > can be u

Re: [GENERAL] Londiste 3 pgq events_1_1 table huge

2016-05-20 Thread Leonardo M . Ramé
El 20/05/16 a las 10:19, Leonardo M. Ramé escribió: El 19/05/16 a las 12:39, Saiful Muhajir escribió: This has happened to us where we have dead or unmanaged consumer. Turns out londiste is keeping the event even if the consumer is unreachable. This is to ensure that the consumer gets what it sh

Re: [GENERAL] Londiste 3 pgq events_1_1 table huge

2016-05-20 Thread Leonardo M . Ramé
El 19/05/16 a las 12:39, Saiful Muhajir escribió: This has happened to us where we have dead or unmanaged consumer. Turns out londiste is keeping the event even if the consumer is unreachable. This is to ensure that the consumer gets what it should. To clean this up, delete the unused/dead consu

Re: [GENERAL] PostgreSql Doubts

2016-05-20 Thread David G. Johnston
On Fri, May 20, 2016 at 9:06 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, May 20, 2016 at 7:17 AM, aluka raju > wrote: > >> Hello , >> >> 1) We are building an application where it needs a SQL engine to process >> the data. We are evaluating whether to use postgreSQL along

Re: [GENERAL] PostgreSql Doubts

2016-05-20 Thread David G. Johnston
On Fri, May 20, 2016 at 7:17 AM, aluka raju wrote: > Hello , > > 1) We are building an application where it needs a SQL engine to process > the data. We are evaluating whether to use postgreSQL along with the > foreign data wrappers. Can you please help us in letting know if postgreSQL > can be u

[GENERAL] No warnings or errors after same sequential revoke

2016-05-20 Thread Alex Ignatov
Hello! Why we have no warnings or errors about that we have no such grant after first revoke? postgres=> grant select(i2) on table user1.t2 to user2; GRANT postgres=> revoke select(i2) on table user1.t2 from user2; REVOKE postgres=> revoke select(i2) on table user1.t2 from user2; REVOKE postgr

[GENERAL] PostgreSql Doubts

2016-05-20 Thread aluka raju
Hello , 1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode. 2) We want to have SQLEngine component al