serie of serie

2020-04-18 Thread Olivier Leprêtre
Hi, I would like to generate a serie of serie and didn’t find how. With generate_series. I can generate a serie 1 1 1 2 2 2 3 3 3 But how can I repeat this serie several times ? 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 Thanks for any help,

Re: serie of serie

2020-04-18 Thread Rory Campbell-Lange
On 18/04/20, Olivier Leprêtre (o.lepre...@gmail.com) wrote: > I would like to generate a serie of serie and didn’t find how. With > generate_series. I can generate a serie ... > But how can I repeat this serie several times ? Something like this? gotest=> select a, b from generate_series(1, 3) a

Re: serie of serie

2020-04-18 Thread Achilleas Mantzios
On 18/4/20 10:18 π.μ., Olivier Leprêtre wrote: Hi, I would like to generate a serie of serie and didn’t find how.  With generate_series. I can generate a serie 1 1 1 2 2 2 3 3 3 But how can I repeat this serie several times ? 1 1 1 2 2 2 3 3 3 1 with foo as (select flo

Re: Replication issue

2020-04-18 Thread Adrian Klaver
On 4/17/20 7:47 AM, Sonam Sharma wrote: Yes, you are right. It's for connection failover from application end. I have set up db replication using repmgr. Version : 9.5 Can you reach the database crowd at host 172.29.195.216:50001 using psql or some other client? On Fri, Apr 17, 2020, 8: