Fulltext results:
- How to Restore a backup of VPOP3 @how_to
- ere you restored VPOP3. This should reinstall the PostgreSQL database system. //Do not start VPOP3 at this tim... op3**. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**. (<port n... stamps). When it prompts for a password enter the PostgreSQL master password - default **pgsqlpass**. (<port n... ere you restored VPOP3. This should reinstall the PostgreSQL database system. //Do not start VPOP3 at this tim
- v3/4 - Move the message store to a new folder/drive @how_to
- n directory where it is. - Stop VPOP3 - Stop PostgreSQL - Remove the PostgreSQL service - Move database to the new folder - Reassign permissions for PostgreSQL - Reinstall the PostgreSQL service - Restart PostgreSQL - Restart VPOP3 Note that we can do this for y
- How to move the VPOP3 Message Store to a new PC @how_to
- re database on another PC. =====Manually Install PostgreSQL on the new PC===== Download the 'pgInstaller' version of PostgreSQL from the [[http://www.postgresql.org/download/windows|PostgreSQL website]]. VPOP3 has been developed using the 8.3 versions of PostgreSQL (the
- What is PostgreSQL? @faq
- =====What is PostgreSQL?====== [[http://www.postgresql.org|PostgreSQL]] is an SQL database engine. =====VPOP3 and PostgreSQL===== In VPOP3 2.x, VPOP3 uses a database engine called
- Database Maintenance @how_to
- ase Maintenance====== VPOP3 uses the [[http://www.postgresql.org|PostgreSQL]] database server for most of its data storage. Normally this will not require any special ma... you will need to close down VPOP3 first, because PostgreSQL needs exclusive access to the database to perform... ese operations may take some time! There are some PostgreSQL utility programs in the VPOP3\pgsql\bin directory
- How to Backup VPOP3 @how_to
- '' (This assumes a standard installation, if your PostgreSQL installation is non-standard, then you may need t... ing the pg_dump program, or create a [[http://www.postgresql.org/docs/9.1/static/libpq-pgpass.html|pgpass.conf... overy/incremental backups=== VPOP3 version 5 uses PostgreSQL 9.1, and stores all settings/messages in the database. This means that you can use alternative PostgreSQL backup procedures. These are outside the scope of
- v5 - Move the message store to a new folder/drive @how_to
- n directory where it is. - Stop VPOP3 - Stop PostgreSQL - Remove the PostgreSQL service - Move database to the new folder - Reassign permissions for PostgreSQL - Reinstall the PostgreSQL service - Restart PostgreSQL - Restart VPOP3 See the [[video:move_the_vpop3
- How to move VPOP3 V3 to a new folder @how_to
- ew folder on the same PC - Stop VPOP3 - Stop PostgreSQL - Remove the PostgreSQL service - Move VPOP3 to the new folder - Reassign permissions for PostgreSQL - Install the PostgreSQL service - Reset some paths in the registry - Reinstall VPOP3 Note that we can
- How to install PostgreSQL to use another port @how_to
- ======How to install PostgreSQL to use another port====== If the VPOP3 computer has a version of PostgreSQL older than version 8.3 installed for other softwa... /don't want to remove that you need to set up the PostgreSQL 8.3 or later for VPOP3 to use a different TCP/IP ... you, so you have to do it manually =====Install PostgreSQL manually===== [[Install PostgreSQL manually]] ont
- Database schema used in VPOP3 5.x @reference
- well. Also note that VPOP3 5.x uses [[http://www.postgresql.org/docs/9.1/static/release-9-1-3.html|PostgreSQL 9.1]] or later, whereas 3.x-4.x use PostgreSQL [[http://www.postgresql.org/docs/8.3/static/release-8-3-15.html|8.3]] or later. The default database name us
- PostgreSQL server won't start due to damaged log files @how_to
- ======PostgreSQL server won't start due to damaged log files====== If the PostgreSQL server won't start at all, because its transactio... a password, type in the password you want for the PostgreSQL superuser - we use **pgsqlpass**. If you choose t... remember what it is! - Type <code>copy data_old\postgresql.conf data</code><code>copy data_old\vpop3db.conf
- Database -> Backups Tab @reference
- the VPOP3 backup feature, or manually backup the PostgreSQL database using the pg_dump command, or use another program to backup the PostgreSQL database if you wish. Note that a simple disk cop... _to:restore_a_backup_of_vpop3]] In general the **PostgreSQL Binary Directory** and **Dump Command Options** s... rent location, or with a different filename. ====PostgreSQL Binary Directory==== This is where the PostgreSQL
- FATAL: connection limit exceeded for non-superusers @fatal
- means that there are too many connections to the PostgreSQL database server. =====VPOP3 having exclusive use of database===== If only VPOP3 is using the PostgreSQL database, then you can reduce the number of conne... sharing the database===== If VPOP3 is sharing the PostgreSQL database with some other software, then you will ... nnection limits accordingly. =====Increasing the PostgreSQL Server Limit===== In the **VPOP3\pgsql\data** dir
- VPOP3 Not Starting Properly @how_to
- In VPOP3 v3 and later, VPOP3 uses a [[http://www.postgresql.org|PostgreSQL]] Database server for data storage, so if the database server is not running, VPOP3 will not b... en first of all, check that the **VPOP3DB** (or **PostgreSQL-VPOP3** in VPOP3 v3 and v4) service is running in... r starts and stops immediately, see the [[VPOP3DB_PostgreSQL service not starting|VPOP3DB service not starting
- Database Issues @how_to
- = VPOP3 version 3 and later use the [[http://www.postgresql.org|PostgreSQL]]] database server. This is an open source enterprise level database server. Several VPOP3 pro... oftware conflicting with database]] * [[VPOP3DB/PostgreSQL service not starting|VPOP3DB Service not starting... rocess is running, then that is often because the PostgreSQL service is not running. If the PostgreSQL service