For questions related to web hosting and email, please refer to the searchable information guide below.
Request support using the 24/7 support ticket system located within your Web Hosting Control Panel. You may access your Control Panel by visiting http://www.yoursite.com/cp. Alternatively, you may log-in directly by visiting http://www2.suresupport.com.
24 Hours A Day Tech Support
Absolutely the best ticketing system ever created. Open online a tech support ticket via an easy to use form. Our techs view your ticket, and as soon as they fix the problem or answer your question, you will receive a notification by e-mail.
15 Minutes Response Guarantee
Is your previous host taking days to return your support requests? We reply to each support ticket within 15 minutes of its posting, and to each e-mail message within one hour… Guaranteed!
Get Help With Various Issues
Ask anything about web hosting and the services we provide. You can get help with configuring e-mail, setting up message boards, form mailers or guestbooks, resetting nameservers, etc.
Maintenance & Support Contracts
Clients enrolled in our Maintenance & Support contracts may use any of the following Customer Support Options.
Discounted rates apply to our Monthly Maintenance & Support Contract holders. If you’re interested in our Monthly Maintenance & Support Contract please call (914) 202-9468
If you would like to request On-Demand Phone or E-Mail Support, you may reserve time blocks in advance. We are available to assist you during Monday – Friday between 9am and 5pm.
1/2 HOUR RESERVE
- On-Demand Phone / E-Mail Support
1 HOUR RESERVE
- FeaOn-Demand Phone / E-Mail Supportture 1
NOTICE: Customers that do not have a monthly website maintenance contract -or- monthly website support contract, please allow a minimum of three business days for our staff to review and correspond to your inquiry. Once a staff member contacts you, they will provide estimated time frame or ETA for fully addressing your concern. Customers without a monthly website support contract that request immediate support, will be billed at our Hot-Rush hourly rate (equivalent to double the standard current hourly rate for development) for any support provided within 72 hours of the initial inquiry.
Reporting Website Related Issues
More often than not, we will need to be able to replicate an issue in order to fix it. Therefore, it is best to provide as much detail as possible when addressing a technical concern. Providing us with sufficient detail will help us to expedite the handling of your request and reduce any fees associated with support services provided.
Description of the problem
Date & Time the incident was encountered.
Device being used: Windows PC, Mac, Tablet, Smart Device
- Web browser being used: Firefox, Internet Explorer, Safari, Chrome, etc. If possible also provide version of browser, typically found under Help > About.
- Steps taken that lead up to the incident (how it can be replicated).
- Web page address (URL) where the incident occurred.
- If E-Commerce related: Customer’s name along with the SKU of the Item the customer was trying to purchase.
- If possible, it would also help to know the internet address of the person who is experiencing the issue. To obtain this, please have them visit http://www.whatismyip.com and provide the IP Address shown.
As much of an inconvenience it may be for you or one of your website visitors/customers to provide this amount of detailed information, the effort at the very least will allow us to rule out recurring instances. Please notify all staff (if applicable) to follow the protocol indicated and include the requested details (on a best effort basis) when reporting issues to us.
Running a PostgreSQL Instance
In this tutorial, we will show you how to configure a PostgreSQL database server on your account using the WebApps platform.
If you do not see a WebApps section in the Control Panel of your hosting account, this tutorial may not be suitable for your particular hosting environment. Please contact our support team for more information.
You need SSH access to the server in order to make the changes described in this tutorial. If you haven't set up SSH for your account yet, you should do this now.
If you want to quickly set up a PostgreSQL server running on your account, you can download this PostgreSQL setup shell script to your account and run it. The script will set up the WebApps project and the PostgreSQL instance on your account and you will be able to start using them immediately.
In order to run the setup script, you have to change its permissions to 755 after you download it to your account. You will then be able to run it from the command line:
In that case, you can skip the "PostgreSQL Server Setup" and "Custom WebApps Project" sections of this article and go directly to the Creating Databases and Roles section.
PostgreSQL Server Setup
The PostgreSQL binaries are already installed on the server. You only have to set up a PostgreSQL instance to handle your databases using the WebApps platform.
To do that, you first have to create the directory structure to hold your data on the server. You can use the
The next step is to initialize your database cluster and set up a superuser role. By default, the username of the superuser role is the same as the username of your hosting account ("example" in this case):
Now, you have to configure the PostgreSQL server to listen for requests using a UNIX socket at the correct location in your account:
To make starting the PostgreSQL service easier, the following commands will create a startup script:
In order to use various PostgreSQL management tools such as
Custom WebApps Project
To run the database server, you have to set up a PostgreSQL service. There are two ways to do this:
The following sections describe how to do this.
On the WebApps Page of the Control Panel
If you choose the Control Panel way, you should create a new app with the following settings:
After you create and enable the app, you will be able to use the new PostgreSQL database server.
Using the Command Line Interface of the WebApps Platform
WebApps projects can be manipulated with the
After running these commands, the PostgreSQL server will be running and you will be able to use it.
Once the server is running, you should set up a new user role and a database for your application. To do that, you can use the following commands over SSH:
You should replace the username and the database name in the example with the actual details you are going to set up in your application.
We create automatic system backups every 12 hours so that you don't have to worry about data loss. These backups allow you to restore your data from backup if anything goes wrong with your site.
Database engines like PostgreSQL and MySQL store data in a special way on the server, so extra care must be taken in order to ensure backup archives are consistent and usable.
For MySQL, which is integrated with our hosting environment, this is already done automatically by the Control Panel. All MySQL data is backed up at regular intervals by our system and it can be easily restored using the "Restore" page of the Control Panel.
For PostgreSQL databases running on the WebApps platform, you have to set up a backup procedure separately. The following code will create two scripts in the WebApps project,
After the scripts are created, you can set up a cron job that runs the
This cron job will overwrite the
Hopefully, you won't have to use the
To restore from a particular backup, you can restore the
If you are going to use a PHP application with PostgreSQL, you have to update the
You have to enable the correct PHP extension depending on the application you want to use via the Control Panel -> PHP Settings section by following these steps:
The extensions can also be activated by manually adding the respective line listed below to a PHP configuration file (php.ini):
PDO driver for PostgreSQL: