摘要：/var/lib/pgsql/9.2/data/pg_hba.conf打开之后找到local all postgres/all peer改成local all postgres trust保存之后重新加载文件sudo /etc/init.d/postgresql reload
阅读全文
摘要：错误：Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb checking for pg_config... noNo pg_config... trying anyway. If building fails, please try again with --with-pg-config=/path/to/pg_configchecking for libpq-fe.h... noCan't find th...
阅读全文
摘要：1 启动：pg_ctl startpg_ctl -D PGDATA(data目录） start2 查看版本创建数据库，登陆，查看createdb testdbpsql testdbSELECT version();3 查看端口（默认5432）netstat -lnp杀死进程：kill -INT 187334 查看配置文件nano ~postgres/.bash_profile 5 进入postegres 用户su - postgres6 数据备份和还原pg_dumpall > backup0307/usr/local/pgsql/bin/psql -d postgres -f /var/
阅读全文
