Tech Talk~ ← Tim.Tang

• Home
• Categories
• About

Ubuntu12.04 postgreSQL9.1 installation

Introduce postgresql installation and configuration on ubuntu12.04.

Preparation

• Install language packages on ubuntu.

    $export LANGUAGE=en_US.UTF-8
    $export LANG=en_US.UTF-8
    $export LC_ALL=en_US.UTF-8
    $sudo locale-gen en_US.UTF-8
    $sudo dpkg-reconfigure locales
  

Install postgresql9.1 with apt-get install

$sudo apt-get install -y postgresql-9.1 postgresql-client-9.1 postgresql-contrib-9.1 postgresql-server-dev-9.1

Modify default postgres user password

• Use postgresql client login to postgres:

    $sudo -u postgres psql
    $ALTER USER postgres WITH PASSWORD 'postgres'
  

Modify password for postgres in ubuntu

• Delete existing postgres user passowrd:

    $sudo passwd -d postgres
  

• Reset postgres user passowrd:

    $sudo -u postgres passwd
  

If you need to alter postgresql max_connection, you need to edit /etc/sysctl.d/30-postgresql-shm.conf

	kernel.shmmax = 2141943040
	kernel.shmall=524288

Cheers!