Differences

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

--- how_to:move_the_message_store_-_alternative_method [2012/04/13 11:22] – created paul
+++ how_to:move_the_message_store_-_alternative_method [2018/11/14 10:45] (current) – external edit 127.0.0.1
@@ Line 8: / Line 8: @@
   - [[stop VPOP3]]
-  - 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'')
+  - [[backup_vpop3#manual_database_backup|Backup the database]]
+  - 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')
-  - 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;''
   - Wait (while the data is all moved across to the new location)
   - Type ''\q'' to leave the psql command prompt
   - [[start VPOP3]]

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools