PostgreSQL ‐ Setup
Install xServer on your VPS or dedicated PC
The x42 Core development team highly advises users to create vps' that have at least 2 gb of RAM for dedicated hosting of xServers on Linux [TUX], for newer Windows [WIN] systems like Windows 10 or Windows Server 2019 we advise 4 gb of RAM or above.
Smaller systems can be used but the results may be less than satisfactory, the xServer owner also has to take into consideration that each and every new DApp hosted on this machine will take resources, make sure you have enough CPU, RAM and network bandwidth to properly host all applications you want to support.
First, we will install xServer’s database using PostgreSQL.
PostgreSQL Installation Steps:
-
Download the latest version of PostgreSQL for your operating system here.
-
Install PostgreSQL by following these steps:
a. Open the file you have downloaded, if you are prompted to run the program click ‘Yes’ or ‘Allow’, then click ‘Next >’
b. Select the default Installation Directory, click ‘Next >’
c. Stack Builder does not need to be installed, uncheck it, click ‘Next >’
d. Use the default Data Directory, click ‘Next >’
e. This section will only show for machines that had previously installed PostgreSQL, if it does not show up for you that is not a problem, click ‘Next >’
f. Choose a password you will remember and retype it, for this example we will be using ‘123456’ as a password for ease of configuration, your password should be stronger than that, click ‘Next >’
g. You can use the default PostgreSQL port, if you don't save that port selection somewhere, you will need it later, click ‘Next >’
h. You can change the default locale, if you do save that selection somewhere, you will need it later, click ‘Next >’
i. You will receive a Pre Installation Summary, click ‘Next >’
j. Click ‘Next >’
k. PostgreSQL will begin to install, this will take a few minutes.
l. You are done with the installation of PostgreSQL, click ‘Finish’
o. Now you will be prompted to reboot your computer, save your work and click ‘Yes’.
Optional steps proposed by buta on discord (installation check and errors):
a. [WIN] Open this webpage: http://127.0.0.1:49684/ and enter your chosen PostgreSQL password.
b. [WIN] Click on 'Servers', if no error pis shown than you can initiate the installation of your xServer client. If you get any errors restart your PC/VPS again.
c. [WIN] If there is still an error the installation may have been corrupted. Uninstall PostgreSQL then delete all remaining files located here 'C:\Program Files\PostgreSQL'
d. Restart your computer.
e. Reinstall PostgreSQL with the steps given above.
The PostgreSQL database is now installed, you can move on to the next step of installation, the guide can be found here.