pgloader简介
pgloader从各种来源加载数据到PostgreSQL。安装apt-get install sbcl unzip libsqlite3-dev make curl gawk freetds-dev libzip-dev
cd /path/to/pgloader
make pgloader
./build/bin/pgloader --help从Mysql迁移到Postgresql./bui...
Ubuntu安装PgAdmin
# Install the public key for the repository (if not done previously):
sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
# Create the repository configuration fil...
mariadb/mysql忘记密码的解决办法
首先停止MariaDB服务：systemctl stop mariadb以跳过权限方式启动MariaDB：mysqld_safe --user=mysql --skip-grant-tables&以root登录mysql：mysql -uroot进入mysql数据库：use mysql修改root用户密码：UPDATE user SET password=PASSWORD('...
CentOS安装Postgresql
当前环境: CentOS 7.6（x64）安装# 添加库
yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# 安装包
yum install postgresql12 postgresql12-server
...