Server slowed down or hanging

[Akramhar]

I will PM you the link to access the file.

Hope you can help me.
Alex

[manics]

Thanks Alex

The ordering of the entries in pg_hba.conf is important- postgres will attempt to authenticate a user with the first matching line. Can you try moving the line ending with ident to below the lines ending with md5?

[Akramhar]

I will try it asap and I will let you know if it works.

Thank you
Alex

[Akramhar]

Hi,

I tried to modify the file as you suggest, I hope I did it correctly.
You can look at the modified file at the same link I sent you.
The file is labeled as "pg_hba_2.conf".

If I modified the file correctly, the solution you proposed is not working.
I get always the same error.

Thanks for your help.
Best,

Alex

[manics]

Thanks Alex.

Could you try passing the -h option to psql, e.g.:

Code: Select all

psql -h localhost dbname username

There are two ways of connecting to the Postgres server: via a network connection, or using a local socket, and it's possible for them to use different authentication mechanisms. OMERO requires the former. Without the '-h hostname' psql will attempt to use the latter- sorry for not spotting this earlier.

Simon

[Akramhar]

Sorry for the late answer.

I tried

Code: Select all

psql -h localhost dbname username

and it is working.

The major issue should be solved because of the line moved in the configuration file, am I right?

Thanks for your patience.
Alex

[manics]

Hi Alex

Yes, it looks like your database is setup correctly. If you have any further problems post them here and we'll try and help you out.

[Akramhar]

Hi,

It seems that we still have problems.

At the end of the last week some users reported a slow down of the service, they had to wait a long time for insight to load data from the server. The problem lasted a couple of hours.

Today a user told me that the server was not accessible. I tried it and neither insight nor the web service were able to access the server. The web server was not even reachable (endless loading).

Do you need that I put the new log online?

Thank you for your help.
Alex

[manics]

Hi Alex

If you could zip up the log directory and put them online again that would be most helpful. Could you also tell us what dates/times the slowdowns occurred, to make it easier for us when going through the logs?

Thanks

Simon

[Akramhar]

I uploaded the logs in the same location where I told you last time.
The following problems happened:

slow down - friday 6.9.2013
server non accessible - monday 9.9.2013

Tell me if you need more information.
Thanks for your help.
Alex