User Tools

Site Tools


how_to:move_the_message_store_-_alternative_method

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
Last revisionBoth sides next revision
how_to:move_the_message_store_-_alternative_method [2012/04/13 11:23] paulhow_to:move_the_message_store_-_alternative_method [2012/04/13 11:25] paul
Line 9: Line 9:
   - [[stop VPOP3]]   - [[stop VPOP3]]
   - [[backup_vpop3#manual_database_backup|Backup the database]]   - [[backup_vpop3#manual_database_backup|Backup the database]]
-  - Create a new folder on the disk where you want the data to be stored. Set the security permissions for this to give the **vpop3postgres** user (or **postgres** if you are using VPOP3 version 3 and 4) to have full permissions in that folder (eg ''d:\vpop3data'')+  - Create a new folder on the disk where you want the data to be stored (eg 'd:\vpop3data'). Set the security permissions for this to give full permissions in that folder to the **vpop3postgres** user (or **postgres** if you are using VPOP3 version 3 and 4)
   - Open a command prompt, and go to the VPOP3 directory (eg 'cd \vpop3')   - Open a command prompt, and go to the VPOP3 directory (eg 'cd \vpop3')
-  - Type ''pgsql\bin\psql -U postgres -p 5433 vpop3'' (for version 5 or later. If you are using version 3 or 4, omit the ''-p 5433''+  - Type ''pgsql\bin\psql -U postgres -p 5433 vpop3'' (for version 5 or later. If you are using version 3 or 4, omit the ''-p 5433''). The default password here is 'pgsqlpass' 
-  - Type ''CREATE TABLESPACE vpop3ts OWNER  vpop3 LOCATION 'd:\vpop3data';''+  - Type ''CREATE TABLESPACE vpop3ts OWNER  vpop3 LOCATION 'd:\vpop3data';''   //(use the appropriate folder name here)//
   - Type ''ALTER DATABASE vpop3 SET TABLESPACE vpop3ts;''   - Type ''ALTER DATABASE vpop3 SET TABLESPACE vpop3ts;''
   - Wait (while the data is all moved across to the new location)   - Wait (while the data is all moved across to the new location)
how_to/move_the_message_store_-_alternative_method.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1