147服务器postgre服务

#!/bin/bash



set -e



sudo psql -h 123.xx.xx.xx-p 5432 -U postgres -d cesiumdb -c "

alter table \"public\".\"sys_user\" drop geo_detail;

ALTER TABLE \"public\".\"sys_user\" ADD \"geo_detail\" text COLLATE \"pg_catalog\".\"default\";

COMMENT ON COLUMN \"public\".\"sys_user\".\"geo_detail\" IS 'geo_detail';"



cd ~



echo "success！"

一、启动数据库服务

cd /usr/local/pgsql/bin

su postgres

./pg_ctl start -D /usr/local/pgsql/data

二、创建一个postgres 用户

adduser postgres

cd /usr/local/pgsql
mkdir data
chown postgres /usr/local/pgsql/data //赋予权限
su postgres //切换用户
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
su //切回到root用户
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &

 重启： /usr/local/pgsql/bin/pg_ctl restart -D /usr/local/pgsql/data

 

psql  

 

 

 

原文链接 https://blog.csdn.net/m0_38026518/article/details/93588035