PostgreSQL is another Relational Database Management System (RDBMS) that is supported on our servers. The database stores information and the data is structured in tables – rows and columns.

A great deal of web applications that you can use on your website, such as shopping carts, forums, blogs or content management systems (CMS), require the use of a database.

Most open source applications use MySQL databases since they are easier to use and generally work faster. PostgreSQL, on the other hand, is more complex, which allows the developer more flexibility and provides more features.

For more information on comparing MySQL and PostgreSQL databases, please refer to this article: What is the difference between MySQL and PosgreSQL?

Important notice: Not all hosting plans include support for PostgreSQL databases. If you can’t see the PostgreSQL Databases section under the Databases menu on your hosting control panel, your plan does not support PostgreSQL.

You can create a PostgreSQL database using the Databases > PostgreSQL Databases menu of the Web Hosting Control Panel. Once you open that menu you’ll see the form for creating new PostgreSQL databases. You have to specify the name of the database.

It always starts with the username of your hosting account (username_) and then you can choose the unique part that will distinguish the particular database.

Then you have to specify and confirm the password for that database and click on the button below to create the database.

Below the form for creating new databases there is a table with all the existing PostgreSQL databases in your account.

For each database you have the option to change the password, delete the database or log in via the phpPgAdmin tool. For more information on how to log in, please refer to the respective article in this knowledge base.

Additional notes:

• A database created on our servers will have only one user that is created by default (new users cannot be created) and the default user of the database has all the priviliges.
• The database name and the database username in our system coincide.
• It is advisable to create separate databases for every application that you use for easier management.

As a customer-oriented company, we strongly believe that the quality of our services should exceed clients expectations at the lowest possible price.

On account of this, our management team decided to have all our servers running on the open-source platform called Linux – an Operating System that has gained tremendous popularity in the last several years among desktop users, as well as impressive growth on the server market.

This in turn has attracted more interest in the development of reliable and inexpensive (free, in most cases) products ranging from desktop applications and office suites to high-end database solutions.

The MSSQL and Access databases, developed by Microsoft, run exclusively on Windows-based servers, such as Windows Server 2003 and Windows Server 2008.

To be fair, there are applications that could theoretically provide MSSQL and Access support under Linux with questionable results and none of those meet our quality standards.

The alternative our company offers is MySQL – the fast, cross-platform database from ”MySQL AB”. Its portability means that you can use it on a variety of Operating Systems – Windows, Linux, Unix, Apple XServe, IBM mainframe, and many more.

If you have already developed your application using a MSSQL or an Access database, we can recommend you the following three options for conversion to MySQL:

Option 1: MSSQL2MySQL https://www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-sql-server-to-mysql/

Option 2: Microsoft Data Transformation Services (DTS). Microsoft has included a data manipulation tool within the SQL server. It provides options for data export in various formats and systems. For more information on how to use this feature, please refer to these documents from Microsoft.com:

http://msdn.microsoft.com/en-us/library/cc917688.aspx

http://technet.microsoft.com/en-us/library/ms345120(SQL.90).aspx

Option 3: Similar to Microsoft DTS, Access has its own tool for table export in many formats (including ODBC). All you need to do here is right-click the table in Access and select ‘Export’. A new wizard will appear, guiding you through the conversion process.

There is a tool that allows you to set password protection for a specific folder. Just go to the Advanced > Password Protection section of the Web Hosting Control Panel.

Click on the New Password Protected Area button.

Select your domain from the “Drop-down menu” or type the full path to the protected folder in the “Path” field (e.g. /www/my-best-domain.com/protected_folder). Enter the username and the corresponding login password. Click the Add PPA button to confirm.

If you need to set more users, repeat the above steps, just use different usernames.

IMPORTANT: If there is an .htaceess file within the protected folder, the protection would not work, so either remove it or consider another password protection technique.

Uploading a lot of files to your hosting space could be a burden if your Internet connection gets interrupted.

Besides, your FTP client opens a new connection for each file in the upload queue, thus taking more time for the files to upload.

The more the files you are trying to upload are, the longer the upload time will be. For that reason, we have included a useful function in the File Manager tool in your Web Hosting Control Panel – unzipping an archive that has been uploaded on the server.

If you want to upload a whole website, you can archive it using a freeware archivator like WinRar or 7Zip.

Upload the file in the corresponding folder, for example /www/my-best-domain.com either via FTP or via the File Manager (Files > File Manager) tool.

Then open the File Manager tool and navigate to the folder where you uploaded the file. You should see the archive that you have just uploaded.

Right Click on the file name – a small window opens, prompting you what you would like to do.

All options are listed in a drop-down menu.

You can open the file with a WYSIWYG editor, a plain text editor or in a browser.

To unpack the archive file in the current folder, you have to select the Extract option.

You can also zip (create an archive) a whole folder by clicking on the Compress icon. The supported archive file types are .zip, .rar, and .tar.gz.

By choosing the Zip/Archive option from the drop-down menu, you can create a zip file of all the files within that folder, making it easier to download the entire folder at once.

Sometimes when you install a script manually, you would see an instruction “change the permissions of file.php to 666“, for example.

Those permissions are associated with the read, write and execute rights that the file owner, group members and everybody else has for that file.

There are several ways to change the permissions of a file or a folder – through the File Manager section, SSH, or through an FTP client, such as FileZilla.

If you go to the File Manager section of the Web Hosting Control Panel (Files > File Manager), you will see a column “Perm“.

There is a value for every file or folder in your account, with default values 644 for files and 755 for folders.

If you want to change the permissions of a particular file or folder, simply click on the Change Permissions icon from the top list menu or click right button of the mouse. A drop-down menu will appear and you have to choose Change Permissions. A small window will show up and you’ll be able to choose the new value.

If you want to change the permissions of multiple files or folders, you have to select them first, then select the Change Permissions icon located at the top of the File Manager section.

Click on the Change button for the changes to take effect. 

An alternative to using our File Manager tool would be changing the file permissions using an FTP client.

That option would also give you the opportunity to change the permissions of all subdirectories and files within a folder recursively. 

We recommend FileZilla, a freeware FTP client. Here is how you can change the permissions using that client: 

First, connect to your account on the server via FTP to see a list of all the files and folders that you have.

To change the permissions, right-click on a file and choose the File Attributes option. You can type a numeric value or choose the Read/Write/Execute permissions marking the checkboxes.

If you choose the File Attributes option when you right-click a folder, you will see an extra option – Recurse into subdirectories.

You can change the permissions of all the files, all the folders, or both, as long as they are located in the folder you have just clicked on. 

Last, but not least, you can change the permissions via Secure Shell (SSH) if it is active for your account. The command is:

chmod number filename

For example:

chmod 644 example.php

For additional details about SSH – how to activate and use it, refer to this article: What is SSH, how do I activate and use SSH?

Here are step-by-step instructions on how to move your emails from the previous hosting provider:

Option 1: Works in all cases (does not require assistance from your current/old provider)

Set up an IMAP account for each of your mailboxes, using a mail client like Outlook, Thunderbird, etc. 

If you are not sure, ask your old hosting provider what the IP of the IMAP mail server you need to connect to is.

Detailed information on how to set up a POP3 account could be found in the email related articles.

Step 1: Download all your emails locally (including all the folders that you might have, like Sent, Draft, etc.) to your computer using the IMAP accounts.

Step 2: Update the domain name servers (if you haven”t done it yet) to the ones listed in the Hosted Domains section of your hosting Control Panel. 

Step 3: Create all the mailboxes that you will be using via the Email Manager section of the Control Panel.

Step 4: You will now have to create IMAP accounts in your mail client for each of the mailboxes. Please note that the previously created IMAP accounts must remain – do not delete them yet!

Step 5: Once you have the two IMAP accounts for each mailbox, just drag and drop all the messages and folders from the IMAP account with the old hosting provider to the new one. This way you will upload all the emails from your computer to our mail server. 

Option 2 – May requires assistance from your current/old provider

Step 1: Check with your old hosting provider if you can have access to the /mail/ directory. There should be folders for each of your email accounts that you have to download to your computer.

Step 2: Create all the mailboxes that you will be using from the Email Manager section of your Control Panel.

Step 3: Upload all mailbox folders to your hosting account with us, using FTP. The folders could be uploaded directly to the /www/ directory.
Each of your mailbox folders (e.g. mail@my-best-domain.com) should contain the following sub-folders: “cur” and “new”.

Step 4: Go to the File Manager section of the hosting Control Panel and navigate to the directory which contains the uploaded folders from the old hosting provider. 

Copy all the files as follows:
– from /www/uploaded-mail/mail@my-best-domain.com/cur/ to /mail/mail@my-best-domain.com/cur/
– from /www/uploaded-mail/mail@my-best-domain.com/new/ to /mail/mail@my-best-domain.com/new/

If you experience problems – check if /mail/mail@my-best-domain.com/ and the subfolders have permissions 755.

Log into the mailbox and see if the messages were copied successfully.

Repeat the steps for each of your mailboxes.

For your convenience and safety we provide the option to enable Anti-SPAM protection for any mailbox that you have with us.

This is an automatic protection based on multiple criteria, which can filter all incoming mail and protect your email account(s) from different types of SPAM (including virus-infected mail attachments).

There are 3 options to activate the Anti-SPAM Protection option for a certain mailbox:

OPTION 1: Enable Anti-SPAM Protection for several email accounts.

Go to the Email Manager menu in your Control Panel (Email > Mailboxes tab).

There you will see a list of all existing email accounts.

You can select each of these email accounts (put a check mark in front of it). Above  the list of mailboxes, there are rows with identical buttons – the second one is the Anti-SPAM button.

OPTION 2: Using the icon located in Actions column. If you want to enable the Anti-Spam option for certain mail you must click on the red icon. Once the option is enable, the icon will be green.

Once you select the desired email account(s) and click on the Anti-SPAM button, you will be forwarded to a page where you will be able to select the level of protection and choose between two SPAM message options – to delete or to forward them to an e-mail address specified by you.

IMPORTANT: The higher the level of protection you choose, the better the chance of rejecting a valid e-mail message that you actually wish to receive will be.

It is recommended that you start off with a lower level or use the option to redirect the SPAM messages so that you can review them manually.

OPTION 3: Go to Mailboxes > Spam section of your Contron Panel and click on the “Activate SPAM Protection” button.  From this section, you can activate and control the Anti-spam protection levels for your email accounts.

SPF (Sender Policy Framework) is a way to prevent sender address forgery in emails. SPF will not directly stop SPAM (junk email).

It will give domain owners a way to define which mail sources are legitimate for their domain and which ones are not.

To enable SPF for your domain, go to the Email > SPF Manager section of your Control Panel.

Choose the exact domain name you wish to protect and switch the Status to ON from the drop-down menu next to your domain name.

If you’re using our mail service, all you need to do is check the box labeled “Allow my domain’s MX records only” under the IPv6 field—that’s it!

This means that only the MX records stored for your domain name in the DNS zone will be able to send mail on behalf of your domain name.

If not, here are the required settings for each field:

• Hosts: Fill in a list of all the hosts, which are authorized to send mail on behalf of the chosen domain name, e.g. mail.my-best-domain.com. Separate the hosts with a space or a comma.
• IPv4: Type in the IP address of your SMTP mail server (e.g. mail.my-best-domain.com). Please have in mind that most of the mail servers have more than one IP address and in order to determine all of them, you can use an online tool like the one at https://www.whatsmydns.net/.
• IPv6: Leave this field blank.

Once all the above is done, click on the Edit SPF Protection button. Please note that the SPF Record propagation may take up to 24 hours.

You can create mailboxes at any of your hosted domains.

To create a mailbox go to Email > Mailboxes in your Control Panel. On the right you see a Create A New Email Account button.

After you click on it, you see several text boxes that you need to be filled in.

Email address – Here you enter the name for your mailbox, which is the part of your email address before the @. Next you choose one of your hosted domains from the drop-down menu on the right. The domain would be the part of your email address after the @.

Password – Here you need to enter the password for your mailbox. You will be using this password to login to the webmail and also when you setup your email account in Outlook and other email clients. You can enter a password using the symbols a-z and 0-9. The password should be between 3 and 32 symbols long. You can use a random password by pressing “Generate password” button.

Forward email – If you select this option, you will be able to enter an email address where all messages received in your new mailbox will be forwarded to. There is also a “Save a copy” option. If you select it, a copy of every message that is forwarded will also be saved in this mailbox. You will be able to setup email forwarding later.

Use Autoresponder – Select Auto-Reply option if you want to enter an auto-reply message, which would be sent back to anyone who sends you an email. Usually this option is used to setup a message informing people that you are on vacation, for example, so it is unlikely that you need this right now. You can setup an auto-responder at any time. (see: How to set an auto-reply message to my e-mail account?)

When you are ready, you can click the Add a Mailbox button to create the mailbox. It will appear in the list of Mailboxes.

You may also find these articles helpful:

• How to setup my email account in MS Outlook?
• How to setup my email account in Mozilla Thunderbird?
• How to setup my email account in Windows Live Mail?
• How to setup my email account in Entourage mail?
• What is a catchall email account and how to setup and use one?

Here is how you can manually set up an email account in Entourage:

1. Open Entourage, click on the Tools menu at the top of the screen and then click on Accounts.
2. When the Accounts window opens, click on the New button in the upper-left corner of the window to start the Account Setup Assistant.
3. Select the button Configure account manually.
4. The New Account box appears. Select either POP or IMAP for your server type (we recommend IMAP). Click OK.
5. The Edit Account box appears. In the Account name box enter your e-mail address (mail@my-best-domain.com)
6. In the Name box enter your name as you would like it to appear on the messages you send (e.g., John Smith)
7. In the E-Mail address box enter your e-mail address (e.g., mail@my-best-domain.com)
8. In the Account ID box enter your e-mail address (e.g., mail@my-best-domain.com)
9. In the POP/IMAP server box enter: mail.supremecluster.com
10. In the Password box enter the password for your e-mail account.
11. Enable “Save password in my Mac OS keychain”
12. In the SMTP server box enter: mail.supremecluster.com
13. Click on the “Click here for advanced sending options” button.
14. Check the “SMTP server requires authentication” box and close by clicking on the small square in the upper left-hand corner. Click OK.

Your Entourage mail account is now ready to go.