Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-12 Thread Adrian Klaver
On 4/11/19 1:45 AM, 김준형 wrote: 1.  It spends more resources but I think this setting endure that problem. Actually, after this setting, Windows server(include PostgreSQL server) endures that problem more. But I know it's not a solution. 2. No. MS-SQL SERVER, PostgreSQL Server, and Tomcat. Wha

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-11 Thread 김준형
> > > p.s) PostgreSQL max_connections =1200. Is there problem in here? > > > > Yeah, it looks like you are maxing out the connections. The overhead > of > > maintaining 1200 connections is probably a contributing factor to > your > > issu

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-09 Thread Adrian Klaver
om> > <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>>님이 작성: > >     On 4/1/19 10:03 PM, 김준형 wrote: >      > >      > 보낸사람: *김준형* mailto:wnsuddl...@gmail.com> >     <mailto:wnsuddl...@gmail.com <m

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-08 Thread 김준형
or to your > issues. So: > > 1) Why is 1200 connections set? > > 2) Have you looked at connection poolers? > > 3) When the server is running properly you should monitor pg_stat_activity: > > > https://www.postgresql.org/docs/11/monitoring-stats.html#PG-STAT-ACTIVITY-VIE

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-08 Thread Adrian Klaver
.com> <mailto:wnsuddl...@gmail.com <mailto:wnsuddl...@gmail.com>>> > Date: 2019년 4월 2일 (화) 오후 2:02 > Subject: Re: Postgresql with nextcloud in Windows Server > To: Adrian Klaver mailto:adrian.kla...@aklaver.com> > <mailto:adrian.kla...@aklaver.co

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-07 Thread 김준형
준형 wrote: > > > > 보낸사람: *김준형* mailto:wnsuddl...@gmail.com>> > > Date: 2019년 4월 2일 (화) 오후 2:02 > > Subject: Re: Postgresql with nextcloud in Windows Server > > To: Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> > > > > > > Thanks fo

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-02 Thread Adrian Klaver
On 4/1/19 10:03 PM, 김준형 wrote: 보낸사람: *김준형* mailto:wnsuddl...@gmail.com>> Date: 2019년 4월 2일 (화) 오후 2:02 Subject: Re: Postgresql with nextcloud in Windows Server To: Adrian Klaver <mailto:adrian.kla...@aklaver.com>> Thanks for your reply and I hope this answers can help your qu

Fwd: Postgresql with nextcloud in Windows Server

2019-04-01 Thread 김준형
보낸사람: 김준형 Date: 2019년 4월 2일 (화) 오후 2:02 Subject: Re: Postgresql with nextcloud in Windows Server To: Adrian Klaver Thanks for your reply and I hope this answers can help your questions 1) The nextcloud is running on PostgreSQL server. Cloud system needs PostgreSQL server. 2) Nextcloud system

Re: Postgresql with nextcloud in Windows Server

2019-04-01 Thread Adrian Klaver
On 4/1/19 6:21 PM, 김준형 wrote: Hi Community, I have problem so I wanna help from PostgreSQL community. My problem is using PostgreSQL with nextcloud(cloud system) and It can make no more connection to server. I checked log files and knew reason. PostgreSQL prevented to disconnecting connection b

Postgresql with nextcloud in Windows Server

2019-04-01 Thread 김준형
Hi Community, I have problem so I wanna help from PostgreSQL community. My problem is using PostgreSQL with nextcloud(cloud system) and It can make no more connection to server. I checked log files and knew reason. PostgreSQL prevented to disconnecting connection but still tried to connect PostgreS