User Tools

Site Tools


how_to:vpop3_cannot_access_postgresql_-_timeout_expired

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
how_to:vpop3_cannot_access_postgresql_-_timeout_expired [2014/04/07 11:16]
127.0.0.1 external edit
how_to:vpop3_cannot_access_postgresql_-_timeout_expired [2018/11/14 10:45] (current)
Line 19: Line 19:
 You can check if this is the problem. Wait until PostgreSQL has started, then from a command prompt in the VPOP3\pgsql\bin directory run You can check if this is the problem. Wait until PostgreSQL has started, then from a command prompt in the VPOP3\pgsql\bin directory run
  
-  psql -U postgres -p 5433 -c "​select reltuples from pg_class where relname='​pg_attribute'"​+  psql -U postgres -p 5433 -c "​select reltuples from pg_class where relname='​pg_attribute'" ​vpop3
 (the password is '​pgsqlpass'​) (the password is '​pgsqlpass'​)
   ​   ​
-If the displayed value is over about 100,000, then this may be the problem. Contact support@pscs.co.uk for assistance.+If the displayed value is over about 100,000, then this may be the problem. Contact support@pscs.co.uk for assistance. Note that this command may take a long time to run if it is this problem.
  
 Also check the disk fragmentation,​ and defrag the disk if necessary. Also check the disk fragmentation,​ and defrag the disk if necessary.
  
  
how_to/vpop3_cannot_access_postgresql_-_timeout_expired.txt ยท Last modified: 2018/11/14 10:45 (external edit)