Pages
Popular Posts
-
Let we have a database like: postgres=# \c testdb You are now connected to database "testdb" as user "postgres". test...
-
A few days back, I faced a disaster with one of the databases with xid wrap around issue. I started to dig into the details about the actu...
-
To make an ssh connection to remote server and scp files from that server through Python script, I used the python package " paramiko &...
-
Postgresql failover with Pgpool II replication can be configured for 24x7 database system where no downtime is allowable. The followings des...
-
"remove_non_alphanum_char_f" - this function is used remove non-alphanumeric character from a string Input: varchar(255) Output: v...
-
RAID, an acronym for Redundant Array of Independent Disks, is a technology that provides increased storage functions and reliability through...
-
I had to upgrade Postgresql 9.0 to 9.2 with less downtime. Earlier I used to complete this kind of upgrade work using pg_dump. But as I h...
-
Once I found in Postgresql 9.0.1 that one of the report queries was hanged in the DB server while it was perfectly running on the developmen...
-
Our data scientists wanted to read some data from Dynamodb. In order to do this, we had to increase the Read Capacity of the table to a hi...
-
We got into a problem with the follwoing error: "FATAL: database is not accepting commands to avoid wraparound data loss in database...
Labels
- Athena (1)
- AWS (2)
- Case Study (2)
- Data Model (1)
- Dynamodb (2)
- Failover (4)
- Linux (11)
- Mysql (12)
- Nagios (1)
- Oracle (3)
- Pgpool (2)
- Postgresql (51)
- PowerShell (1)
- Python (7)
- Query Tune. Wordpress (1)
- Sql (7)
- Sql Server (3)
- Wordpress (5)