WS_FTP Server - Backup and Restore PostgreSQL database from PGadmin3 Console

Product: WS_FTP Server, WS_FTP Server with SSH
Version: 6.0+
Platform: Windows XP Professional SP2 or later, Windows 2000 server SP4 or later,
Windows Server 2003 SP1 or later.

Question/Problem: Is it possible to backup and restore the PostgreSQL through PGadmin3?

Answer/Solution:

Navigate to the PostgreSQL installation directory which is C:\Program Files\Postgresql\bin and run the pgAdmin3 executable. Double click on PostgreSQL Database Server 8.1. You will be prompted for the IPS_account password.

Stop all Ipswitch services.

Backup WS_FTP Server database

Select the database you would like to back up (ws_ftp_server), right click, Backup. Select a location and name, Ok.

Restore WS_FTP Server database

Using pgAdmin3 login, delete the existing ws_ftp_server DB
Right click databases -> New Database.
Name your new database ws_ftp_server,

Owner = IPS_Admin (This will change depending on what you have named the account.)

Encoding = UTF8

Template = template0

Tablespace = pgdefault
Click Ok
Select your newly created DB -> right click -> restore
Browse to the location of the backup and using all the default setting click ok
Click Done.

Start all Ipswitch services and the World Wide Web Publishing service (if using IIS for web management).

Backup Notification Server database

Open pgAdmin3, select the database you would like to back up (ips_notifications), right click, Backup. Select a location and name, Ok.

Restore Notification Server database

Using pgAdmin3 login, delete the existing ips_notifications DB
Right click databases -> New Database.
Name your new database ips_notifications,

Owner = IPS_admin

Encoding = UTF8

Template = template0

Tablespace = pgdefault
Click Ok
Select your newly created DB -> right click -> restore
Browse to the location of the backup and using all the default setting click ok
Click Done.

Document #: FS-20080806-TG03.htm
Revision Date: 09/09/08