Yes, pgChess extension now allows you to play a chess game with Postgres Instance(computer). Thanks to authors. Installation is very simple with pgxnclient. pgChess extension supported with another extension called pg2podg. Documentation Link: https://github.com/gciolli/pgChess/blob/master/doc/ pgxnclient install pgchess pgxnclient install pg2podg After installing, just run CREATE EXTENSION commands create extension pgchess; create extension pg2podg; Two types of play, (1) PC vs PC and (2) PC vs Human. To play a new game of PC vs Human run below file (download source from the above link for the files) in unaligned format of psql terminal. Continue reading →
Some of new Oracle feature included in PostgresPlus Advanced Server 9.2 beta. Most of them are charm to the product and needed if anyone has migrated from Oracle to PostgreSQL. Many more new features in the product itself, however I would like to walk-through few of them which are related to Oracle compatibility. 1. Object Type Support: In this version, member functions are supported, but not yet MAP member functions. Continue reading →
psql is a great tool. Oftentimes, output of the particular command in psql is too big to fit on one screen, hence outputs are wrapped to fit in one screen which becomes output unreadable. To custommize command output in readable format we have system variable called PAGER. If its on linux, I can simply set PAGER variable with LESS command + options to view command ouptut in readable format. Eg:- Continue reading →
If you are from linux then its simple to see all processes names (writer process, wal writer, autovacuum etc.,) just by typing ‘ps -ef | grep postgres’, but if you are from windows then its bit tough to see without any help of windows system internal tools. Process Explorera windows system internal tool will brief about active/running process including names. Many options in Process explorer which are very useful to know about processes in windows. Continue reading →
My title might be slight contradictory, as per Slony-I, swapping can be achieved among nodes, if nodes are connected to each other by anyway as PROVIDER or RECEIVER and replicating. If you see in my diagram, “DR-Prod” is nowhere related to Slony replicating nodes, still swapping is possible(with some extra care). Here are some valueable inputs from Steve & Jan.Thanks. When we need such kind of swapping, if you are planning to move “PROD” from one data center to another or from existing disk volumn to another (many reasons). Continue reading →