title: How to find (decode) PostgreSQL query from Wireshark File?
body: <p>I am on Linux platform with PostgreSQL 5.5. I am trying to monitor all traffic related to PostgreSQL between Master and Slave. To that end, I used Wireshark to monitor the traffic. Then, I started PostgreSQL and ran three queries (Create table Hello, Create table Bye &amp; inserted an image to PostgreSQL database). During queries, I ran Wireshark on Master just to capture the traffic between Master and Slave.<br>
  But there is one problems with PostgreSQL traffic captured using Wireshark. All the traffic is sent/received in TCP packets and that traffic is in coded form. I can't read that data. I want to find out all those three queries from Wirehsark that I inserted in PostgreSQL database. 
  <strong>What is the best way to go about finding queries of PostgreSQL?</strong>
  On the other hand, I ran same queries on MySQL database and repeated above mentioned experiment. I can easily read all those three queries in wireshark dump because they are not in coded form.</p>
  
  <p>Wireshark file of PostgreSQL experiment is available on <a href="https://www.researchgate.net/post/How_to_find_decode_PostgreSQL_query_from_Wireshark_File" rel="nofollow noreferrer">Wireshark-File</a>. I need to find out above three queries from Wirehsark file. 
  <strong>About File:</strong>
  192.168.50.11 is the source machine from where I inserted queries to remote PostgreSQL's Master server. 192.168.50.12 is the IP of Master's server. 192.168.50.13 is the slave's IP address. Queries were executed from .11 and inserted into .12 and then replicated to .13 using Master-Slave approach. 
  Pointers will be very welcome.</p>