The reference platforms and their recommended settings are:
service postgresql start su - postgres createdb da createuser sa Superuser? yes psql da create language plpgsql; \q exit
pg_hba.conf - relace authentication method 'ident same' with 'trust' for localhost
postgresql.conf - set parameters depending on server memory size
Parameters/Memory | Default | 4GB | 8GB | 16GB |
---|---|---|---|---|
max_connections | 100 | 200 | 400 | 1000 |
shared_buffers | 32MB | 1GB | 2GB | 4GB |
work_mem | 1MB | 512MB | 1GB | 2GB |
maintenance_work_mem | 16MB | 512MB | 1GB | 2GB |
effective_cache_size | 64KB | 1GB | 3GB | 6GB |
statement_timeout | 3600000 | 3600000 | 3600000 | 3600000 |
*For OpenSuse 12.1 and later, you will need to add the following lines in /etc/sysctl.conf
kernel.shmmax=17179869184 #if you want max shared_buffer size of 16GB. kernel.shmall=4194304
sysctl -p /etc/sysctl.conf
service postgresql restart
(*for Tomcat 7 on OpenSuse 12 and later, see at the end of the page)
ln -s /usr/share/tomcat /usr/tomcat
CATALINA_OPTS="-Djava.awt.headless=true -Xmx1400M"
Note: -Xmx (Maximum Java heap size) for a production system with 4GB of memory should be around 1400M, leaving ample room for PostgreSQL. You may need to change this for systems with higher memories.
cp /usr/tomcat/webapps/da/index.html /usr/tomcat/webapps/ROOT
service tomcat6 start
Using Yast, set up System Services(Runlevel) so that PostgreSQL and Tomcat are automatically started at boot. Reboot server to complete installation
The next step is to license your server. Click here for details of the licensing process
OpenSuse now uses systemd based service runner, instead of /etc/init.d/tomcat.
ln -s /usr/share/tomcat /usr/tomcat
You need to make the following changes
- /usr/tomcat/conf/server.xml – change port 8080 to 80
- /usr/tomcat/conf/tomcat.conf – add the lines
TOMCAT_USER="root" TOMCAT_GROUP="root" SECURITY_MANAGER="false" CATALINA_OPTS="-Djava.awt.headless=true -Xmx1400M" #for RAM with 4GB, more for servers with higher RAM
- /usr/lib/systemd/system/tomcat.service – comment out user and group.
- /usr/sbin/tomcat-sysd – comment out the routine for checking uid=0
There is a bug in the yast in 12.3. You cannot stop automatic startup of firewall. You need to run these commands
systemctl status SuSEfirewall2.service systemctl enable SuSEfirewall2.service systemctl start SuSEfirewall2.service systemctl stop SuSEfirewall2.service systemctl disable SuSEfirewall2.service
If the Java version is OpenJDK 1.7 in AWS, please copy the certificate from an Windows machine
copy C:\Program Files\Java\jdk1.8.0_25\jre\lib\security\cacerts to /var/lib/ca-certificates/java-cacerts from Windows to SUSE
To Change hostname in OpenSuse, edit the following files:
/etc/HOSTNAME /etc/hostnames