OpenSUSE环境配置 Environment

server

network

route -n

route add defaut gw 192.168.0.1 eth0

sudoer

software

# zypper install openssl

# zypper install php7 php7-pgsql php7-mbstring php7-bcmath php7-mcrypt php7-fpm php7-openssl php7-fileinfo php7-gd php7-zip

# zypper install php7-zlib php7-curl php7-posix

# zypper install postgresql postgresql-contrib postgresql-server

systemctl enable nginx|postgresql|php-fpm

postgresql

# 简单管理

su postgres

psql

postgres=# show config_file;
postgres=# du+;

/etc/init.d/postgresql restart

systemctl status postgresql

CREATE DATABASE benz_inventory ENCODING 'UTF8';

ALTER DATABASE name RENAME TO new_name

• Backup & Restore *

# dump
pg_dump dbname > outfile

# restore
psql dbname < infile