![]() It is not recommended to set the password for 'postgres' user or creating 'root' user for productive environments! 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): 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |