Tags » PostgreSQL

How to Rename and Change Boolean column to Integer in PostgreSQL

Today, I faced a situation where I had to change a column type from Boolean to Integer. Also, I wanted to rename the column. Let’s suppose, we have… 68 more words


Install PostgreSQL on Fedora 26 Workstation

The packages from the standard Fedora repository are almost as recent than the packages in the official PostgreSQL repository. No need to add the PostgreSQL repository. 417 more words




sudo apt-get install postgresql postgresql-contrib

With phppgadmin

sudo apt-get -y install postgresql postgresql-contrib phppgadmin

Configure user

sudo su - postgres
\password postgres
… 19 more words

Data Platform Summit 2017

I will be speaking at the Data Platform Summit happening at Bangalore from Aug 17-19, 2017. I will be delivering sessions on achieving a million predictions/sec using SQL Server and introduce our latest entrants into the Azure Database family: MySQL and PostgreSQL. 453 more words

Webcasts And Events

How to tune postgresql performance for OLTP application

postgresql come with average confirguration for average hardware, make it available for all people across the globe. if your hardware above the average, you need to fine tune, to optimize postgresql performance. 403 more words

Tanpa Kategori

Perform Failover testing Postgresql replication

On this article i will show the failover testing postgresql replication with repmgr, repmgr already configure automatic failover, reference from this article

Begin failover

Stop service postgresql on master node… 1,272 more words


實習 -day 18

2017/8/8 (二)


因為李總好像以為我們要幫Vincent做很多事(Eric是幫Vincent做滿多事的啦),而且他原本想要我們做的事情我們都沒有做過,雖然我真的沒有做過很多事但我覺得如果李總派下來我們還是會想辦法完成,畢竟每個工作如果都有做過那就不用來學了啊。結果李總就說我們還是研究車辨軟體就好了,讀參數設定的文件,看要怎麼設定才能辨到最多車牌。 131 more words