[GENERAL] PGpool question

This may be the wrong list, but I am not sure where it needs to go. I am trying to set up pgpool, and I keeping on getting this message: NOTICE: add node from hostname:"xxx" port:9000 pgpool_port: rejected. Jul 28 22:11:49 xx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid 10768: DET

Re: [GENERAL] Developer GUI tools for PostgreSQL

You can try DBeaver. It is a generic GUI tool which works with practically all RDBMS. It is java based, and I find it bit slow. However judging by the frequent updates I get, it seems to be very active. -- View this message in context: http://www.postgresql-archive.org/Developer-GUI-tools-for

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

> On Wed, Jul 27, 2017, PAWAN SHARMA wrote: > > On Wed, Jul 26, 2017, wrote: > > > > You have an environment problem in that the 2 different users have a > > different > > PATH and you're getting 2 different perl executables, or at least that's > > what > > it looks like to me. Please note tha

Re: [GENERAL] tzdata version

Jerome Wagner writes: > When compiled with "--with-system-tzdata", does postgres need a restart > after the system is updated with the new tzdata ? No, but existing sessions will carry on with whatever data they've read from the tzdata files; we don't have a provision to reload a timezone definit

Re: [GENERAL] tzdata version

Thank you for your answer. When compiled with "--with-system-tzdata", does postgres need a restart after the system is updated with the new tzdata ? regards, jérôme wagner On Fri, Jul 28, 2017 at 4:06 PM, Tom Lane wrote: > Jerome Wagner writes: > > As i understand it, the tzdata on which th

Re: [GENERAL] upsert: is there a shortcut?

Daniele Varrazzo wrote: Is there a way to avoid replicating the list of fields and use instead something like (new.*) = (excluded.*) as one could do in a trigger? (that would also imply an (id = excluded.id but it seems harmless). This is certainly something that I've seen requests for before.

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

Hello, everybody. I solved the problem. The index has been corrupted after replication despite it was appeared as not corrupted. It was solved by recreating the index. Thank you for the help. -- Пожалуйста! Используйте кнопку "ответить всем". Не удаляйте историю переписки. Спасибо. С уважением,

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling postgre

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

Vincenzo Romano writes: > I would like to understand the typo protection mentioned by Tom earlier: > I need to understand the reason for creating that special case. Well, case A: create function foo(out x int4) returns setof int8 ... This is indubitably a typo. Case B: create function foo(out

Re: [GENERAL] tzdata version

Jerome Wagner writes: > As i understand it, the tzdata on which the timezone information is based > is updated regularly (semi-manually) in https://github.com/ > postgres/postgres/tree/master/src/timezone > Am i correct in stating that there is currently no way to update the tzdata > database exc

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/ postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling postgr

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 11:36 PM, wrote: > On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA > wrote: > > > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA > > wrote: > > > > > > Hi All, > > > > > > I am fac

Re: [GENERAL] Developer GUI tools for PostgreSQL

I don't run windows so I haven't looked at the EMS product. On Fri, Jul 28, 2017 at 6:53 PM, vinny wrote: > On 2017-07-28 06:31, Tim Uckun wrote: > >> I think it's funny that after all these years pgadmin3 is still the >> most comprehensive GUI for postgres. >> > > Have you looked at EMS SQL-Man

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

2017-07-28 8:36 GMT+02:00 David G. Johnston : > On Thursday, July 27, 2017, David G. Johnston > wrote: >> >> On Thursday, July 27, 2017, Vincenzo Romano >> wrote: >>> >>> The main difference is that with RETURNS SETOF RECORD I still get the >>> "usual"(tm) function argument list in the usual plac