1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo yum install -y postgresql11-server sudo /usr/pgsql-11/bin/postgresql-11-setup initdb sudo systemctl enable postgresql-11 sudo systemctl start postgresql-11 vim /var/lib/pgsql/11/data/postgresql.conf listen_addresses = '*' port = xxxx vim /var/lib/pgsql/11/data/pg_hba.conf host all all 127.0.0.1/32 md5 systemctl restart postgresql-11 systemctl status postgresql-11 su - postgres psql -U postgres ALTER USER postgres WITH PASSWORD 'xxx'; CREATE DATABASE xxxx OWNER postgres; GRANT ALL PRIVILEGES ON DATABASE postgres_t1 to postgres;
|