sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Install PostgreSQL:
sudo yum install -y postgresql12-server
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12
1、在线安装
yum install postgresql-server -y
2、初始化数据库
service postgresql initdb
3、设置自动启动
hkconfig postgresql on
4、启动
service postgresql start
如何修改默认密码
su - postgres psql alter user postgres with password 'newpassword';
修改后重启服务
service postgresql restart或者 /bin/systemctl restart postgresql.service
测试登陆
psql -h 127.0.0.1 -p 5432 -U postgres
设置所有网络都可以访问(默认是本机)
cd /var/lib/pgsql/data/ vim postgresql.conf listen_addresses = '*'
设置认证模式,在pg_hba.conf文件中增加
host all all 0.0.0.0/0 password
=======================================================================
导出dump
# hly 数据库
# postgres 用户名
cd /usr/pgsql-12/bin
#进入psql界面
sudo -i -u postgres
~$ psql
pg_dump -h 127.0.0.1 hly -U postgres -p 5432 -f hly.sql
pg_dump -h 127.0.0.1 metric -U postgres -p 5432 -f metric.sql
window 安装目录/bin下执行
pg_dump -h 127.0.0.1 -U postgres -p 5432 -d hly -f "E:/hly.dmp"
pg_dump -h 127.0.0.1 -U postgres -p 5432 -d metric -f "E:/metric.dmp"
密码:HlyP@ssW0rd
导入数据
bin/psql -U postgres metric < C:\Users\hui\Desktop\fsdownload\metric.sql