brew install/uninstall postgres

=install database sever=
{{{class=”brush: bash”
brew update

brew install postgres
}}}

= initializes the database during installation.=
data dictery is /usr/local/var/postgres
{{{class=”brush: bash”
postgres -D /usr/local/var/postgres
}}}

=Login to PostgreSQL for the first time.=
{{{class=”brush: bash”
createdb ‘whoami’

psql
}}}

=Install AdminPack=
AdminPack is used by PgAdmin. If you plan on using the PgAdmin UI, then installing AdminPack is a good idea.
{{{class=”brush: bash”
psql postgres -c ‘CREATE EXTENSION “adminpack”;’
}}}

=Configure PostgreSQL to start automatically=
{{{class=”brush: bash”
mkdir -p ~/Library/LaunchAgents

ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents

}}}

删除自动启动服务:

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

=sart postgresql server=
{{{class=”brush: bash”
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
}}}

=stop postgresql server=
{{{class=”brush: bash”
pg_ctl -D /usr/local/var/postgres stop -s -m fast
}}}

=install pgadmin3=
PgAdmin is a free GUI for Postgres management, user dmg package install
[[http://www.pgadmin.org|pgAdmin.dmg]]

创建postgres用户。

createuser -d -a -P postgres

导入sql文件，如导入back.sql：

psql -d database_name -f back.sql

导出数据库到文件:

pg_dump database_name > back.sql

卸载postgresql

如果是使用homebrew安装:

brew uninstall postgresql

如果是下载安装包安装的，有两种方法。
1. 自动卸载，在安装目录下，mac下是/Applications/Postgresql下有个uninstall-postgresql.app，双击执行就可以了。
2. 手动删除。

停止服务
sudo /sbin/SystemStarter stop postgresql-9.2

移除菜单图标
sudo rm -rf /Applications/PostgreSQL 9.2

移除ini文件
sudo rm -rf /etc/postgres-reg.ini

移除startup items
sudo rm -rf /Library/StartupItems/postgresql-9.2

移除数据和安装文件
sudo rm -rf /Library/PostgreSQL/9.2

移除postgres用户
sudo dscl . delete /users/postgres