Difference between revisions of "Install server"
Jump to navigation
Jump to search
Line 38: | Line 38: | ||
** Go to the [http://www.enterprisedb.com/products-services-training/pgdownload PostgreSQL download page] | ** Go to the [http://www.enterprisedb.com/products-services-training/pgdownload PostgreSQL download page] | ||
** Download the appropriate installer (x86-32 or x86-64 according your Windows version) | ** Download the appropriate installer (x86-32 or x86-64 according your Windows version) | ||
− | ** Execute the postgresql-(version)-windows(-x64).exe, using a privileged account. | + | ** Execute the ''postgresql-(version)-windows(-x64).exe'', using a privileged account. |
** You can accept the default paths for installation and data | ** You can accept the default paths for installation and data | ||
− | ** Define a non-blank superuser password: ''' | + | ** Define a non-blank superuser password: '''remember it!''' |
− | ** You can accept the default port number (5432). If you define a new one: ''' | + | ** You can accept the default port number (5432). If you define a new one: '''remember it!''' |
** Define your locale settings | ** Define your locale settings | ||
** After files were copied, uncheck '''Execute Stack Builder''' on exit | ** After files were copied, uncheck '''Execute Stack Builder''' on exit | ||
+ | ** You should open a used port (''default 5432'') in your firewall on a client-server configuration | ||
[[Installing|Back to Gestinux installation]] | [[Installing|Back to Gestinux installation]] |
Revision as of 12:33, 1 March 2014
{{#CustomTitle:Installing a server}}
If you do not want to use a database hosted in the internet, Gestinux requires either MySql Server or MariaDb Server (>= 5.0) or PostgreSQL Server (>= 8.4) installed on your local system, or on any server your network can access.
The easiest installation is setting up MySql on Linux.
The power of current computers means you will still have spare processing capacity after installing a server locally.
You must have an administrator account before you can install.
The following is a short guide to installing either MySql or PostgresSQL. For more details, please refer to the official documentation.
To install MySql server :
- On Ubuntu :
- Use Synaptic to install the package mysql-server.
- Confirm a few options
- You can enter a blank password for the root account if you are evaluating.
- On Windows :
- Go to the mysql download page
- Download the appropriate installer (in most cases, the first one)
- Execute the setup.exe, using a privileged account.
- You can accept the default options
- You can choose a standard configuration
- A non-blank root password is required: Remember it !
To install MariaDb Server :
- On Linux Ubuntu :
- On Windows :
- Download from this page
To install PostgreSQL server :
- On Ubuntu :
- Install the package postgresql
- On Windows
- Go to the PostgreSQL download page
- Download the appropriate installer (x86-32 or x86-64 according your Windows version)
- Execute the postgresql-(version)-windows(-x64).exe, using a privileged account.
- You can accept the default paths for installation and data
- Define a non-blank superuser password: remember it!
- You can accept the default port number (5432). If you define a new one: remember it!
- Define your locale settings
- After files were copied, uncheck Execute Stack Builder on exit
- You should open a used port (default 5432) in your firewall on a client-server configuration