Category: Postgres

Safely increase size of a column in a PostgreSQL table without changing data

Sometimes we find that the size of a column is not sufficient to hold the data we need to store. We need to safely increase size of a column in a PostgreSQL table without changing data. Say, we have default

Posted in Postgres Tagged with: , , , , , , , , , ,

psql: FATAL: password authentication failed for user – error in Postgresql

Hi all, I am writing after a long time. This will be a short post on the error we get in postgresql. The error is : psql: FATAL:  password authentication failed for user “username”. The following code snippet shows the

Posted in Postgres, Ubuntu 12.04 LTS Tagged with: , , , , , , ,

Execute .sql file from command line in postgresql

Hi all, Every now and then we have/want to run a .sql file or sql script from command line instead of typing each and every sql commands. So, I will write how to execute .sql file from command line in

Posted in Linux, Postgres, Ubuntu Tagged with: , , , , , , , , , , , , , , ,

Install Postgresql in Ubuntu 12.04 LTS

Hi all, Its common to all that we need to install database in our machine now or then due to re-installation of OS or any other reasons whatever that may be. I too use to install most of the time

Posted in Postgres Tagged with: , , , , , , , , , , , , , , , , , , , ,
%d bloggers like this: