Configuring a PostgreSQL database

The DB Config utility is used to modify the present PostgreSQL database configuration. This utility is located at:

• 32-bit: C:\Program Files\Ipswitch\WS_FTP Server\Utilities\dbconfig.exe
• 64-bit: C:\Program Files (x86)\Ipswitch\WS_FTP Server\Utilities\dbconfig.exe

Note: You must be a local system administrator to use this utility.

To modify the present configuration, enter these fields:

• PostgreSQL server address. Enter the IP address of the PostgreSQL database server.
• Port. Enter the port on which the PostgreSQL database server is listening for connections.
• Administrator account name. Enter the username for the PostgreSQL database server administrator. If the PostgreSQL database server you are connecting to was installed when you installed WS_FTP Server, the account name is IPS_<username>, with <username> replaced with the username you specified during the WS_FTP Server installation.
• Password and Confirm password. Enter and confirm the password for the PostgreSQL database server administrator. If the PostgreSQL database server you are connecting to was installed when you installed WS_FTP Server, the password should be the password you entered during the WS_FTP Server installation.

If the PostgreSQL database server you are connecting to does not already contain a database for WS_FTP Server, the Create Host dialog appears. This dialog is used to create the WS_FTP Server database. The WS_FTP Server database requires at least one host, which the information you provide is used to create.

• Host name. Enter the name of the WS_FTP Server host. This should be the fully qualified host name that clients will use to connect to the file transfer server.
• Administrator. Enter a username for the WS_FTP Server system administrator account. This username is used to log in to the Web-based WS_FTP Server Manager.
• Password and Confirm password. Enter and confirm a password for the WS_FTP Server system administrator account.

After the WS_FTP Server Database Configuration Utility completes, you can open the WS_FTP Server Manager by double-clicking the shortcut located on the desktop of the computer where WS_FTP Server is installed.

Important: This utility restarts the WS_FTP Server, SSH Server, web server, and Ipswitch Notification Server services.

Microsoft SQL Server Database Migration

You can migrate your PostgreSQL database to MS SQL Server 2008/2012. Click Migrate to launch the Microsoft SQL Server Configuration dialog. (Click Help on Microsoft SQL Server Configuration dialog for more assistance.)