Postgresql | AkbarAhmed.com

Install RazorSQL on Ubuntu 12.04 LTS x64

akbarsahmed

July 26, 2012

Introduction RazorSQL is a GUI tool for working with Postgresql. Install RazorSQL First, create the razorsql directory. mkdir ~/Downloads/razorsql Download RazorSQL into the ~/Downloads/navicat directory. Open a web browser to http://www.razorsql.com/download_linux.html. Click Download next to Linux (64-bit). After the download completes, open a command prompt and enter the following commands. I have assumed that you …

Enable TCP/IP Connections to Postgresql 9.1

akbarsahmed

no comments

July 26, 2012

Introduction The default installation of Postgresql does not allow TCP/IP connections, which also means JDBC connections wont’ work. Enable TCP/IP Connections cd /etc/postgresql/9.1/main Let’s make a backup of the original config file. sudo cp postgresql.conf postgresql.conf.org sudo vi postgresql.conf Find the line that contains #listen_addresses = ‘localhost’ and change it to: listen_addresses = ‘localhost’ If …

Initial Configuration of Postgresql on Ubuntu 12.04 LTS

akbarsahmed

no comments

July 26, 2012

Introduction After installing Postgresql on Ubuntu, you will need to complete a few basic setup steps. Set the Password for the postgres User The first step is to update the password for the postgres user. sudo -u postgres psql postgres Then enter the following command at the postgres=# prompt. \password postgres Create a Database If …

Install Postgresql on Ubuntu 12.04 LTS

akbarsahmed

1 comment

July 25, 2012

Introduction Postgresql is an open source object relational database. It is often thought of as an alternative to MySQL. In this post I’ll provide the steps required to install Postgresql on a developer laptop, assuming that work will be done in both SQL and Python. You can learn more at: Postgresql web site Postgresql on …