Editing PostgreSQL Notes

== Advocacy == * [http://www.jiaozhoujob.com/newsprint-995.html "Postgres is not for sale"] (compared to MySQL which has been bought and sold twice now and is now owned by Oracle...) * [http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 Why PostgreSQL Instead of MySQL 2009] * [http://episteme.arstechnica.com/eve/forums/a/tpc/f/6330927813/m/377006385931/p/1 Is MySQL really this bad?] (a nice snarky thread on Ars Technica == pg_hba.conf file location == On Debian, pg_hba.conf (etc.) are in /etc/postgresql/8.3/main/ == Migration from other RDBMSes == * [http://trac-hacks.org/wiki/SqliteToPgScript Sqlite to Pg Script] (written in python) * [http://justbarebones.blogspot.com/2007/10/copy-model-data-between-databases.html Copy model data between databases] (for Rails) * [http://articles.techrepublic.com.com/5100-10878_11-1045665.html?tag=rbxccnbtr1 What to consider when moving from MySQL to PostgreSQL] == Rails stuff == * [http://wiki.rubyonrails.org/database-support/postgres PostgreSQL] on Rails Wiki * [http://olmonrails.wordpress.com/2008/08/12/switching-rails-to-postgresql/ Switching Rails to PostgreSQL] == tsearch - full text == * [http://www.postgresql.org/docs/8.3/static/textsearch.html Chapter 12 of the PostgreSQL docs] * [http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-guide.html tsearch2 guide]