PostgreSQL Information

From Free Hosting Wiki
(Difference between revisions)
Jump to: navigation, search
[checked revision][checked revision]
(Created page with "With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. Thi...")
 
 
Line 1: Line 1:
 +
{{Illuminated}}
 +
{{Premium}}
 +
 
With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. This usually means interacting with a database management system, such as MySQL.
 
With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. This usually means interacting with a database management system, such as MySQL.
  

Latest revision as of 23:37, 7 January 2012

The following content applies to our Illuminated package and as such may not be relevant for Free Hosting.
The following content applies to our Premium package and as such may not be relevant for Free Hosting.

With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. This usually means interacting with a database management system, such as MySQL.

Before being able to use PostgreSQL, you should create a PostgreSQL database and user through cPanel.

Then you need to configure your script to connect to PostgreSQL, the following settings should be used:

Host/Server Name
localhost
Port
5432 (not necessary)
Username
Your cPanel username followed by an underscore and the PostgreSQL username you configured in cPanel.
Password
The password that you used when creating the PostgreSQL user.
Database
Your cPanel username followed by an underscore and the name of the database that you created in cPanel.


Remember: Free hosting accounts do not have remote PostgreSQL access.

Personal tools
Namespaces

Variants
Actions