Re: Postgresql with nextcloud in Windows Server

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 but still tried to
> connect PostgreSQL server. This problem blocks to connect server and
> can't stop PostgreSQL service. What I can do is just restart the server
> and recover PostgreSQL data(I don't know why some data disappear.).
> Can I get some help about this problem?

Not sure I entirely understand the above, so to help can you answer the
following:

1) The Postgres server is running on nextcloud, correct?

2) The client you are using to connect to the server is on nextcloud
also or somewhere else?

3) The log files do not show a problem, is this correct?

4) Do you see an error message on the client end when you try to connect?

5) Have you looked at your pg_hba.conf to see if allows connections from
your client?

6) Not sure what you mean when you say you cannot stop the service, but
that you can restart it?

7) How do you know that data has disappeared?

>
> My OS and PostgreSQL version is
> PostgreSQL 10.5
> Windows Server 2012 R2
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com