Postgresql version issue

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • Solved
We are running the following:



Product Delphix Engine - Demo
Version Delphix Engine - Demo 4.2.1.1
Build Date Mon, 30 Mar 2015 02:20:17 GMT

I have added a Linux server running Postgresql 9.3 as an Environment.

The environment page correctly identifies it as:

Data Type: PostgreSQL Linux
Version: 9.3.2

When I try to add a dSource, I get the following error during the SnapSync.

LOG: unrecognized configuration parameter "unix_socket_directory" in file "/data/delphix_toolkit/4228a1da-f588-977f-b4cb-16f2401864cb-staging-39/datafile/dlpx_postgresql.conf" line 13
FATAL: configuration file "/data/delphix_toolkit/4228a1da-f588-977f-b4cb-16f2401864cb-staging-39/datafile/postgresql.conf" contains errors

The issue seems to be that the "unix_socket_directory" parameter was removed in Postgres 9.2 and replaced by "unix_socket_directories" in 9.3.  I've tried updating the conf in the toolkit area and re-running the SnapSync, but the conf is just refreshed/overwritten during the process and the change is lost.

It looks like PG 9.3 is supported with Delphix 4.2; I'm unsure of where the version issue is or what I can update to get the correct conf settings.  Our LinuxSource/LinuxTarget machines are using a PG 9.2 installation but I am adding a dSource from our own server that only has 9.3.
Photo of Patrick

Patrick

  • 90 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Hey Patrick, first awesome that you are using Delphix! Let me run this past my team and see what insight they have. 
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Patrick, what server are you specifying as your staging server on your production source? The staging server must be another Postgres 9.3 instance in Delphix. 
Photo of Patrick

Patrick

  • 90 Points 75 badge 2x thumb
The Staging Environment is the same machine as the one I'm trying to create the dSource from.  I've turned 'Use as Staging' off for the 9.2 servers and recreated the env/dSource and still have the same issue.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Ahh. Ok Patrick. I confirmed that PG support was added in 4.2.3, which is a couple minor releases ahead of where you are at. I am currently looking at options to get you on a more current release. Will get back to you shortly.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Hey Patrick, shoot me an email and I will get you squared away so you can move forward. hsic'at'delphix.com
Photo of Patrick

Patrick

  • 90 Points 75 badge 2x thumb
Look like that did the trick.  Thanks!
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Supreme. Glad to hear it!