Postgres Basics on Ubuntu 8.10
Posted by pebuchmann_super on 15 Mar 2009 | Tagged as: Ubuntu
Installation sudo apt-get install postgresql postgresql-client postgresql-contrib Changing the User Password sudo -u postgres psql postgres ALTER USER postgres WITH ENCRYPTED PASSWORD ‘<***password***>’; \q Creating a New DB sudo -u postgres createdb dev Setting up PgAdmin III Don’t know exactly what this is good for, better performance? sudo -u postgres psql < /usr/share/postgresql/8.3/contrib/adminpack.sqll Installing PgAdmin [...]