All posts tagged: Postgresql

Install RazorSQL on Ubuntu 12.04 LTS x64

Leave a comment
Postgresql

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 downloaded the .zip file to the Downloads/razorsql directory. cd ~/Downloads/razorsql unzip razorsql5_6_4_linux_x64.zip mv razorsql ~/bin/ cd ~/bin/razorsql chmod 755 razorsql.sh […]

Enable TCP/IP Connections to Postgresql 9.1

Leave a comment
Postgresql

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 you want to allow remote connections, then you need to set listen_address to something like (assuming your machine’s IP Address […]

Initial Configuration of Postgresql on Ubuntu 12.04 LTS

Leave a comment
Postgresql

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 you exited the postgres=# prompt, then enter the following command to connect to Postgresql. However, if your prompt still looks […]

Install Postgresql on Ubuntu 12.04 LTS

comment 1
Postgresql

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 Wikipedia Installation Open a command prompt and enter the following commands. sudo apt-get install postgresql postgresql-common postgresql-contrib \ postgresql-client postgresql-client-common […]