Posts

Showing posts with the label admin

Installing postgresql 9.1 on Ubuntu 11.10

Image
Ok, so my first blog entry will be about how I recently installed postgresql 9.1 on Ubuntu 11.10 and some links. I couldn't get apt-get install to work, so I had to download a deb file and install it myself. Here are the steps: Verify that it has started: In order to talk with postgresql you can run this (then you don't have to modify PATH): To load this postgres into your environment, source the env file (if you don't run this you will get errors like stuff you need to install): Now you can try: Try to create a database (will ask for postgres password). Backup and restore that worked: Backup: http://www.commandprompt.com/blogs/joshua_drake/2010/07/a_better_backup_with_postgresql_using_pg_dump/ References: http://wiki.openscg.com/index.php/Postgres_9.1_DEB http://library.linode.com/databases/postgresql/ubuntu-10.10-maverick http://www.commandprompt.com/blogs/joshua_drake/2010/07/a_better_backup_with_postgresql_using_...