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 revisionPrevious revision
Next revision
Previous revision
how_to:vpop3_cannot_access_postgresql_-_timeout_expired [2014/04/07 10:16] – external edit 127.0.0.1how_to:vpop3_cannot_access_postgresql_-_timeout_expired [2018/11/14 10:45] (current) – external edit 127.0.0.1
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 by 127.0.0.1