You can use an exiting linux user to ease authentication (if peer is enabled in pg_hba.conf). Now you should create at least one super user. If none found: initialise your database: This is where you will find nf and pg_hba.conf for example. TODO: (database initialisation steps, in case they would be required).Įnable postgres server to start at system boot:ĭefault PostgreSQL home directory ~postgres for OpenSUSE is: /var/lib/pgsql/Ĭonfiguration files are in data directory: ~postgres/data/.
> postgres is not a native service, however systemctl can manage it very well Sudo zypper in postgresql-plperl postgresql-plpython postgresql-pltcl Perl / Tcl / Python (postgres supports 2.x and 3.x, please check official documentation):
Commercial postgresql odbc driver suse linux license install#
Install the optional procedural languages, according to your needs: Recommendation: install the postgresql-devel as well if you plan to use external libraries like fdws. Sudo zypper in postgresql postgresql-server postgresql-contrib >contrib provides some extensions that are not yet part of root tree Install the postgresql client, server and contrib. Zypper -non-interactive -quiet addrepo -refresh -p 90 PostgreSQL The specific postgres repository will provide most stable and feature rich releases and tools with the latest patches.Īdd repository ( change last dir to fit your distribution):
The packages provided by the basic repository are most tested and sufficient for most use cases. In case you are targeting a simple installation (single node, testing purposes, simple web-browser, etc.), you can skip this optional step. 3.3 RAM optimization with ZRAM and huge pages.
0 kommentar(er)
