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.

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-11 Thread 김준형
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. What do you think of appropriate value

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-09 Thread Adrian Klaver
On 4/8/19 6:51 PM, 김준형 wrote: Thanks for your answers. 1) First time, I set that value to 200. I think it is connection issue, so increase max_connection = 1200. Connections consume resources, that can come back to hurt you. After I show this email, I search max connection is associated to

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-08 Thread 김준형
Thanks for your answers. 1) First time, I set that value to 200. I think it is connection issue, so increase max_connection = 1200. After I show this email, I search max connection is associated to shared_buffers. My configuration set shared_buffers = 192GB because PostgreSQL documents says set

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-08 Thread Adrian Klaver
On 4/7/19 9:53 PM, 김준형 wrote: Sorry for late but my server works without problem for a while. > What problem occurs? > Where is the Windows server? Problem means Windows server doesn't accept new connection and non-admin connection. Only connected admin connection lives. Windows server is

Re: Fwd: Postgresql with nextcloud in Windows Server

2019-04-07 Thread 김준형
Sorry for late but my server works without problem for a while. > What problem occurs? > Where is the Windows server? Problem means Windows server doesn't accept new connection and non-admin connection. Only connected admin connection lives. Windows server is not so close on my work space. So I

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 > Thanks for your reply and I hope this answers can help your questions 1) The

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