Mathz.nu

Category: Postgresql

  • Postgres database dump

    —

    by

    admin
    in

    To export schema from postgres database use: pg_dump -s databasename

  • Postgres on Ubuntu 14.04

    —

    by

    admin
    in ,

    Install postgres 9.4 Add source sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt trusty-pgdg main” >> /etc/apt/sources.list’ add key wget –quiet -O – http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add – update sudo apt-get update install sudo apt-get install postgresql-9.4-postgis-2.1 pgadmin3 postgresql-contrib Add user # sudo su – postgres $ createdb mydb $ psql -s mydb # create user…