Skip to Content
The Database Hacker's Handbook: Defending Database Servers
book

The Database Hacker's Handbook: Defending Database Servers

by David Litchfield, Chris Anley, John Heasman, Bill Grindlay
July 2005
Intermediate to advanced
528 pages
12h 21m
English
Wiley
Content preview from The Database Hacker's Handbook: Defending Database Servers

The PostgreSQL Protocol

There are three versions of the PostgreSQL protocol. PostgreSQL 6.3 introduced protocol version numbers starting from 1.0. PostgreSQL 6.4 introduced protocol version 2.0 and PostgreSQL 7.4 introduced protocol version 3.0. The most recent version of the database, 8.0, uses protocol version 3.0.

Unlike the protocols that other DBMS use, the PostgreSQL protocol does not willingly surrender the database version number. During the connection handshake, the protocol version is the only information that is required to determine client-server compatibility. Once the handshake is complete, the client application may query the server version to determine whether specific SQL features are supported. This means that in order to fingerprint the server remotely and anonymously, the attacker must make inferences based on observing both the message flow and content:

  • The server version can be inferred from the highest version number of the protocol that the postmaster supports.
  • The server version can be inferred from error messages returned by sending malformed responses to certain messages.
  • The server version can be inferred by studying responses to requests found in later versions of the protocol (SSL support was only introduced in version 7.1).
  • The server version can be inferred by the presence of certain authentication types (md5 was only introduced in version 7.2).

The startup packet sent from the client typically contains a username, database name, and protocol version. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

The Oracle® Hacker's Handbook: Hacking and Defending Oracle

The Oracle® Hacker's Handbook: Hacking and Defending Oracle

David Litchfield
The Mac Hacker's Handbook

The Mac Hacker's Handbook

Charlie Miller, Dino Dai Zovi
The Browser Hacker's Handbook

The Browser Hacker's Handbook

Wade Alcorn, Christian Frichot, Michele Orru

Publisher Resources

ISBN: 9780764578014Purchase bookDownloads