Freebsd postgresql: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Thomas (Diskussion | Beiträge) (→Start) |
Thomas (Diskussion | Beiträge) |
||
| Zeile 8: | Zeile 8: | ||
=Start= | =Start= | ||
*service postgresql start | *service postgresql start | ||
| − | =Create a user= | + | =Create a user and a database= |
*su postgres | *su postgres | ||
*createuser -P user_test | *createuser -P user_test | ||
| + | *createdb db_test -O user_test | ||
=Set more security= | =Set more security= | ||
Version vom 31. Oktober 2017, 22:24 Uhr
Install
- pkg install -y postgresql96-server
Enable
- sysrc postgresql_enable="YES"
Initdb
- service postgresql initdb
Start
- service postgresql start
Create a user and a database
- su postgres
- createuser -P user_test
- createdb db_test -O 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