Postgresql
共 6 篇文章
postgresql install and configure for ubuntu
ABSTRACT PostgreSQL is an object-relational database system that has the features of traditional commercial database systems with enhancements to be found in next-generation DBMS systems. This blog entry documents the installation process of the PostgreSQL database on Ubuntu Linux. sudo apt-get ins…
2013-04-25 08:13 · Postgresql
ruby readline的两种写法
f = File.read('public/file.csv').read lines = f.each_line.map{|x|x} lines = File.readlines('public/file.csv')
2013-04-09 10:21 · Ruby On Rails · Postgresql
heroku quick deploy
#need pg in Gemfile #sqlite3 in dev 1) gem install heroku 2) heroku login 3) heroku create 4) heroku apps:rename newapp [https://devcenter.heroku.com/articles/renaming-apps] 5) git push heroku master [https://devcenter.heroku.com/articles/git] 6) heroku run rake db:version [https://devcenter.heroku…
2012-10-18 23:07 · Ruby On Rails · Postgresql
MAC 和 Postgresql 第二篇
非常有用的相关资料 UPDATE(05/06/2013): still works fine for MAC modify /usr/local/var/postgres/postgresql.conf get localhost works pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log restart 还是说brew安装,之前之后的事 用brew安装postgresql,很忌讳rvm的gcc,要用xcode的command line brew装完要设置路径,就是local那个不然,就会莫名其妙…
2012-10-16 11:56 · Postgresql
Mac OSX 和 posgresql (2013再次更新版)
UPDATE(2013/06/01) brew services restart postgresql psql -U kenlu -h localhost -d postgres 几个重要说明: mac 下brew安装后要initdb 启动后,默认管理员是系统当前帐户 psql不认的时候,就是brew的路径问题(见下代码) brew装的重启,启动什么的用brew services 在ubuntu下完全不同sudo aptitude 安装后,不许要initdb只要 sudo -u postgres psql template1 template1=# CREATE USER tom WITH…
2012-10-03 05:03 · Ruby On Rails · Postgresql
Postgresql 和 rails
update(05/13/2013) ubuntu only ALTER USER postgres with encrypted password 'your_password'; #/etc/postgresql/9.1/main/postgresql.conf #localhost Locate the line #listen_addresses = 'localhost' and change it to: listen_addresses = 'localhost' sudo -u postgres psql template1 \du list user 这里注意ubuntu下…
2012-09-24 02:46 · Ruby On Rails · Postgresql