Re: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-27 Thread Atul Kumar
As per your error, it seems replication slot has been dropped. On Saturday, March 27, 2021, FOUTE K. Jaurès wrote: > Hello EveryOne, > > How can I solve Issue. ??? > > > > *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" > does not exist2021-03-27 11:48:33.012 WAT [1090] LO

Re: Hello - About how to install PgAdmin4 on Debian 10

2021-03-27 Thread Benedict Holland
The containers for postgres and pgadmin4 are incredible. This entire thread, worrying about configurations settings and options, it all disappears. You just run the container. There are tutorials to help you get it set up with nginx. It just works. The developers and maintainers have done an incred

Re: = t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

2021-03-27 Thread Adrian Klaver
On 3/26/21 2:16 PM, Bryn Llewellyn wrote: /Tom Lane wrote:/ Finally, I discovered that this is OK: *create table t(i interval);* But I can’t find a definition of the semantics of a bare interval. However, I did find a column headed “Mixed Interval”  at https://www.postgresql.org/docs/11/d

Re: Hello - About how to install PgAdmin4 on Debian 10

2021-03-27 Thread Ray O'Donnell
On 27/03/2021 14:59, Ray O'Donnell wrote: If you can, include the relevant bits from the pgAdmin log, which according to [2] should be here:  ~/.pgadmin/pgadmin4.log A quick find + grep also found me these: ~/.local/share/pgadmin4.startup.log ~/.local/share/pgadmin/pgadmin4/.pgAdmin4.start

Re: Hello - About how to install PgAdmin4 on Debian 10

2021-03-27 Thread Ray O'Donnell
Hello Carlos, This sounds like a different issue, and you would have more luck asking about it on the pgadmin-support list [1], which the developers follow. If you can, include the relevant bits from the pgAdmin log, which according to [2] should be here: ~/.pgadmin/pgadmin4.log Ray. [

Re: = t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

2021-03-27 Thread Bryn Llewellyn
Tom Lane wrote: b...@yugabyte.com writes: > There's more. We see that while the two "interval second” values '1 day > 01:00:00' and '25 hours' test as equal, the results of adding each to the > same timestamptz value are different. You're misunderstanding how it works… > PLEASE STATE THE RULES

Re: Hello - About how to install PgAdmin4 on Debian 10

2021-03-27 Thread Carlos Montenegro
Hello Adrian. First I installed postgresql version 12.6 then for pgadmin4 followed this guide: https://www.pgadmin.org/download/pgadmin-4-apt/ So, when try to open pgadmin have the next message: The PgAdmin4 server could not be contacted: pgAdmin Runtime Environment ---

ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

2021-03-27 Thread FOUTE K . Jaurès
Hello EveryOne, How can I solve Issue. ??? *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist2021-03-27 11:48:33.012 WAT [1090] LOG: background worker "logical replication worker" (PID 8458) exited with exit code 12021-03-27 11:48:38.019 WAT [8461] LOG: logi

Re: = t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

2021-03-27 Thread Francisco Olarte
Bryn: ( 1st, sorry if I misquote something, but i use text-only for the list ) On Fri, Mar 26, 2021 at 10:16 PM Bryn Llewellyn wrote: > I’d deduced the conceptual background that both Tom and Francisco referred > to. And I’ve coined the terms “horological interval” and “cultural interval” > t