Freebsd postgresql

Aus Xinux Wiki
Zur Navigation springen Zur Suche springen

Install

  • pkg install -y postgresql96-server

Enable

  • sysrc postgresql_enable="YES"

Initdb

  • service postgresql initdb

Start

  • service postgresql start

Create a user

  • su postgres
  • createuser -P user_test

Set more security

  • mysql_secure_installation

Login

  • mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.6.37 Source distribution


Links