Tags » PostgreSQL

Postgresql Data In Microsoft Office Applications

In this blog we will go through simple steps in connecting microsoft office applications with postgresql using ODBC, which will be helpful for those who would like to use Excel as a front-end for data analysis. 336 more words

Odoo

Installing PostgreSQL on Raspberry PI 2

Continuing with my web server project, it needs to be data driven.  For now, I am going to use PostgreSQL as my data store.  That may change, but for now it will suffice. 430 more words

Installing psycopg2 on a Mac

Sometimes I really miss apt-get. Wish for the old days of linux and command prompt, lol. Pretty crazy installation for a Mac. Here’s what I had to do: 234 more words

Python

How to see blocking situation ?

To see the blocking situation :

SELECT kl.pid            AS blocking_pid
, ka.usename             AS blocking_user
, ka.query               AS blocking_statement
, now() - ka.query_start AS blocking_duration
, bl.pid                 AS blocked_pid
, ba.usename             AS blocked_user
, ba.query               AS blocked_statement
, now() - ba.query_start AS blocked_duration
FROM  pg_catalog.pg_locks        bl
JOIN pg_catalog.pg_stat_activity ba ON ba.pid = bl.pid
JOIN pg_catalog.pg_locks         kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid
JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid
WHERE NOT bl.granted
ORDER BY 4 DESC;
How To...

How to see the activity in postgres ?

The very important point in administration is to see the activity :

SELECT state,pid,datname,usename,application_name,client_addr,client_port,query_start FROM pg_stat_activity ORDER BY state,pid;

To see the inactivity more than one day : 19 more words

How To...

CREATE, BACKUP, RESTORE, INSERT FILE SQL POSTGRESQL ::CMD MODE:: [DRAFT]

Sebagai catatan…hal sepele yang sering terlupakan…biar ga kelupaan ane catat disini aja…

MASUK PostgreSQL\9.1\bin>

:: CREATE DATABASE ::

#create database nama_database owner=admin encoding=’sqlascii’ template=template0;

:: BACKUP DATABASE :: 40 more words

Database

Eknaprasath reblogged this on Eknaprasath.

Using Postgres to Integrate MongoDB, Hadoop and Others with FDWs

Presenter: Bruce Momjian, Co-Founder of the PostgreSQL Global Development Group and a Senior Database Architect at EnterpriseDB

Date: Wednesday, April 29 at 8:00am EDT / 2:00pm CEST … 135 more words

Postgresql