jpablobr.com

→ Postgresql Setup

More on: ubuntu, debian, linux, postgresql, Mon Mar 28 05:34:04 +0000 2011

Install

$ sudo apt-get install postgresql

Check that postgres is really listening on port 5432:

$ netstat -atn | grep -v tcp6 | grep 5432
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN

Make first database user (a superuser is required for practical migrations) in postgres:

$ sudo su postgres
$ createuser postres-user
Shall the new role be a superuser? (y/n) y
$ exit
$ psql

Go do some damage!

blog comments powered by Disqus