Skip to main content

Posts

Showing posts from October, 2015

postgres

* install http://tecadmin.net/install-postgresql-server-on-ubuntu/ * server start /etc/init.d/postgresql start * checkout postgre version locate postgres | xargs -i xargs -t '{}' -V * change account sudo su - postgres (or sudo -i -u postgres) * if having problem peer authentication open the file pg_hba.conf for ubuntu it will be in /etc/postgresql/9.x/main and change the this line: from "local   all             postgres                                peer" to   "local   all             postgres                              ...