随笔分类 -  PostgreSQL

Rails: could not connect to database postgres: FATAL: Peer authentication failed for user "username"
摘要：/var/lib/pgsql/9.2/data/pg_hba.conf打开之后找到local all postgres/all peer改成local all postgres trust保存之后重新加载文件sudo /etc/init.d/postgresql reload 阅读全文

posted @ 2013-09-14 21:56 小浪鼓 阅读(1491) 评论(0) 推荐(0)

CentOS 安装PostregSQL9.2 同时出现pg安装错误
摘要：错误：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... 阅读全文

posted @ 2013-09-14 02:27 小浪鼓 阅读(765) 评论(0) 推荐(0)

PostgreSQL 常用命令
摘要：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/ 阅读全文

posted @ 2013-03-07 16:47 小浪鼓 阅读(342) 评论(0) 推荐(0)

导航