Skip to main content

centos7 install postgresql

Using stock CentOS repositories

Installing PostgreSQL on CentOS7 can be done two ways:
  • From the PostgreSQL repositories
  • From the official CentOS repositories
The later will be described in this document
Installation
[root@localhost ~]#yum install -y postgresql postgresql-server postgresql-libs postgresql-contrib
Initialization
[root@localhost ~]# postgresql-setup initdb
Make sure it starts at boot
[root@localhost ~]# systemctl enable postgresql
Start the service
[root@localhost ~]# systemctl start postgresql
Switch to the service user
[root@localhost ~]# su - postgres
MAke sure you access locally
-bash-4.2$ psql
postgres=#
User and database creation
-bash-4.2$ createuser --interactive --pwprompt jira
-bash-4.2$ createdb --owner=jira jira
Switch to the Jira user
[root@localhost ~]# su - jira
[jira@localhost ~]$ psql --username=jira --password
psql (9.2.10)
Type "help" for help.
jira=#
If you want to access PostgreSQL without being "jira" user, you need to configure
[root@localhost ~]# nano -w /var/lib/pgsql/data/pg_hba.conf
And add
[...]
host   jira jira     127.0.0.1/32     md5
[...]


Popular posts from this blog

npm run build base-href

Using NPM to specify base-href When building an Angular application, people usually use "ng" and pass arguments to that invocation. Typically, when wanting to hard code "base-href" in "index.html", one will issue: ng build --base-href='https://ngx.rktmb.org/foo' I used to build my angular apps through Bamboo or Jenkins and they have a "npm" plugin. I got the habit to build the application with "npm run build" before deploying it. But the development team once asked me to set the "--base-href='https://ngx.rktmb.org/foo'" parameter. npm run build --base-href='https://ngx.rktmb.org/foo did not set the base href in indext.html After looking for a while, I found https://github.com/angular/angular-cli/issues/13560 where it says: You need to use −− to pass arguments to npm scripts. This did the job! The command to issue is then: npm run build -- --base-href='https://ngx.rktmb.org/foo&
Read more

Jenkins invalid privatekey

Publish over SSH, Message "invalid privatekey:" With quite recent (June-July 2020) installations of Jenkins and OpenSSH, I have the following error message when using the "Deploy overs SSH" Jenkins plug-in and publishing artifacts to the target overs SSH: jenkins.plugins.publish_over.BapPublisherException: Failed to add SSH key. Message [invalid privatekey: [B@d8d395a] This problem seems to be referenced here: https://issues.jenkins-ci.org/browse/JENKINS-57495 Just regenerate a key with the right parameters To solve it: ssh-keygen -t rsa -b 4096 Or ssh-keygen -t rsa -b 4096 -m PEM
Read more

AzureCLI Custom Python

Installing Azure CLI on Archlinux When trying to install Azure CLI on Archlinux, I follow the documentation, in the "script" tab , and it leads to the following errors: [mihamina@arch-00 ~]$ curl -L https://aka.ms/InstallAzureCli | bash [...] Running install script. -- Verifying Python version. -- Python version 3.11.3 okay. [...] -- Executing: ['/usr/bin/python3', 'virtualenv.py', '--python', '/usr/bin/python3', '/home/mihamina/lib/azure-cli'] /tmp/tmpn0w4l6w9/virtualenv-16.7.11/virtualenv.py:24: DeprecationWarning: The distutils package is deprecated and slated for removal in Python 3.12. Use setuptools or check PEP 632 for potential alternatives import distutils.spawn /tmp/tmpn0w4l6w9/virtualenv-16.7.11/virtualenv.py:25: DeprecationWarning: The distutils.sysconfig module is deprecated, use sysconfig instead import distutils.sysconfig Already using interpreter /u
Read more