=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