QuickTip: Postgresql DB Creation on Ubuntu

Recently I resumed working on Ubuntu. While setting up the working environment, I had to setup Postgressql followed by creating a new database and stuff like that. In between I encountered certain problems and correspondingly found solutions also. Through this blog I thought things should be at one place for a newcomer.

From initial installation point of view https://help.ubuntu.com/community/PostgreSQL is a good resource. Though instead of using pgadmin3 I like to use SQuirreL SQL Client.

I had to create a new user which could be used to create a new database. Everything worked except postgres didn’t allow new user to enter into new database. I found a solution at http://www.cyberciti.biz/faq/psql-fatal-ident-authentication-failed-for-user and it worked like a charm.

Tagged with: , ,
Posted in QuickTip, Ubuntu
One comment on “QuickTip: Postgresql DB Creation on Ubuntu
  1. Kathleen says:

    Having read this I thought it was rather enlightening.

    I appreciate you finding the time and effort to put this information together.
    I once again find myself spending a lot of time both reading and leaving comments.
    But so what, it was still worthwhile!

    Check out my web-site: Kathleen
    Kathleen recently posted…KathleenMy Profile

Leave a Reply

Your email address will not be published. Required fields are marked *

*

CommentLuv badge

Welcome to Sampreshan
Technology Strategist, Speaker, Scrum/XP/Agile Trainer Coach and Trainer
Your interest areas
Follow

Get every new post on this blog delivered to your Inbox.

Join other followers: