[PostgreSQL]: Write-Ahead Logging (WAL)
Write-Ahead Logging (WAL) Write-Ahead Logging (WAL) is a standard method for ensuring data integrity. A detailed description can be found in most (if not all) books about transaction processing. Briefly, WAL‘s central concept is that changes to data files (where…
10 Reasons PostgreSQL is Better Than SQL Server
Why would anyone want to use PostgreSQL instead of SQL Server? There are a lot of factors to consider when choosing how to store your data. Sometimes we need to look deeper than the standard choice and consider something new….
[ RDBMS to MongoDB ] Best practices for Migration
Relational databases are being pushed beyond their limits because of the way we build and run applications today, coupled with growth in data sources and user loads. To address these challenges, many companies, such as MTV and Cisco have migrated…
SQL Converter
Database and SQL Migration Tools : ========================= This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online SQLines provides database migration tools: Database Schema (DDL) Conversion…
PostgreSQL Replication
Refer to http://dbversity.com/postgresql-installation/ for PostgreSQL Installation procedure on your both Master & Slave servers. Replication Now we are testing something that called hot standby replication. Configure the Master Server We will begin by configuring our master server. All of these…
SSH issues with Incomplete SOE Build VMs
Do you have issues with you SSH in your lab/test VMs which has no proper builds and thus it’s effecting SSH Tectia functionality. No issues, below works for me – please have a try. Not sure how far this is…
PostgreSQL Installation
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL…