Cannot connect to postgresql database

[bclay1297]

I cannot connect to our PostgeSQL database using the code shown below. This used to work but no longer.
The connect string I use is std::string connectionStr = "PG:host = 'localhost' port = '5433' user = 'postgres' password = 'pwd' dbname = 'aviation'";. I can connect to the daatabase using osgInfo with the same string so I know the database works. I copied ogrinfo into the same directory as my osgEarth application so it would use the same dll's in the test. The only error I get when callin open is Failed to open "PG:dbname=aviation host=localhost port=5433 user=postgres password=geoData2024"

I have the following environment variables set
_putenv("OSG_PLUGIN_PATH = /Tools/EarthViewer/Debug/osgPlugins-3.6.5");
_putenv("OSG_FILE_PATH=/Tools/data");
_putenv("OSG_NOTIFY_LEVEL=DEBUG");
_putenv("OSG_GL_ERROR_CHECKING=ON");

_putenv("OSGEARTH_NOTIFY_LEVEL=DEBUG");
_putenv("OSGEARTH_HTTP_DEBUG=1");
_putenv("GDAL_DRIVER_PATH=C:/Program Files/GDAL/");
_putenv("OSGEARTH_CACHE_PATH=/OsgEarthCache");

Any thoughts or help would be greatly appreciated

Bruce

source code
/////////////////////////////////////////////////////////////
void VectorDataLayer::AddPostgresLayer(std::string nodeName,
std::string connectionStr, std::string sqlQuery, std::string labelFieldName,
float lineWidth, unsigned int lineColor)
{
int status = -1;
char* strPtr;
osgEarth::Style style;
osgEarth::FeatureDisplayLayout layout;

//osgEarth::OGRFeatureSource::Options options;

// options.query()->set_expression(sqlQuery);

osgEarth::OGRFeatureSource* featureSrc = new osgEarth::OGRFeatureSource();

if (featureSrc != NULL)
{
	featureSrc->setConnection(connectionStr);

	osgEarth::Query query;

	osgEarth::Geometry::Type geomType = featureSrc->getGeometryType();

	osgEarth::Bounds bounds;

	bounds.xMin() = -180.0;
	bounds.yMin() = -90.0;
	bounds.xMax() = 180.0;
	bounds.yMax() = 90.0;

	if (bounds.valid() == true)
	{
		query.bounds() = bounds;
	}

	query.set_expression(sqlQuery);

	featureSrc->setName(nodeName);

	featureSrc->setOGRDriver("PostgreSQL");

	osgEarth::Status opened = featureSrc->open();

	if (opened.isOK() == true)
	{
		int numFeatures = featureSrc->getFeatureCount();

		if (featureSrc->getStatus().isError())
		{
			OE_WARN << featureSrc->getStatus().message() << std::endl;
		}

		// Get the features
		osg::ref_ptr< osgEarth::FeatureCursor > cursor = featureSrc->createFeatureCursor(query);

		const osgEarth::Profile* profile = featureSrc->getProfile();

		osgEarth::FeatureList features;

		if (cursor.valid() == true)
		{
			cursor->fill(features);
		}

		osgEarth::Feature *feature = features[0].get();

		osgEarth::Geometry* geometry = feature->getGeometry();
			
		osgEarth::Geometry::Type geomType = geometry->getType();

		switch (geomType)
		{
			case osgEarth::Geometry::Type::TYPE_POINT:
			{
				osgEarth::PointSymbol* point = style.getOrCreateSymbol<osgEarth::PointSymbol>();

				point->fill()->color() = osgEarth::Color((unsigned int)0x0000ffFF);
				point->size() = 100;
				point->smooth() = true;

				// Clamp the lines to the terrain.
				osgEarth::AltitudeSymbol* alt = style.getOrCreate<osgEarth::AltitudeSymbol>();
				alt->clamping() = alt->CLAMP_TO_TERRAIN;

				osgEarth::RenderSymbol* rs = style.getOrCreateSymbol<osgEarth::RenderSymbol>();
				{
					rs->depthOffset()->minBias()->set(6.6, osgEarth::Units::METERS);
				}

				osgEarth::TextSymbol* text = style.getOrCreate<osgEarth::TextSymbol>();
				{
					text->size() = 24.0f;
					text->declutter() = false;
					text->alignment() = osgEarth::TextSymbol::ALIGN_CENTER_CENTER;
					text->fill().mutable_value().color() = osgEarth::Color(0xffffffff);

					if (labelFieldName.length() > 0)
					{
						text->content() = osgEarth::StringExpression(labelFieldName);

						text->halo() = osgEarth::Stroke(osgEarth::Color::Red);
					}
				}

			}
			break;

		default:
			break;
		}

		osg::ref_ptr< osgEarth::FeatureNode > featureNode = new osgEarth::FeatureNode(features, style);

		mMapNode->addChild(featureNode.get());
	}
	else
	{
		if (featureSrc->getStatus().isError())
		{
			OE_WARN << featureSrc->getStatus().message() << std::endl;
		}
	}

}
else
{
	if (featureSrc->getStatus().isError())
	{
		OE_WARN << featureSrc->getStatus().message() << std::endl;
	}
}

}

[jasonbeverage]

Do you get any error messages that you could share?

[bclay1297]

Thanks Jason for the reply There were no error messages other than to say it could not open. I assumed that since ogrinfo could open it when executed from the same directory that I had all of the required dlls. Are there any tha osgEarth requires in addition to the GDAL ones?

…

On Fri, Feb 20, 2026 at 11:54 AM Jason Beverage ***@***.***> wrote: Do you get any error messages that you could share? — Reply to this email directly, view it on GitHub <#2921 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADNLDTTNGFVU3QDT4ZGYXWL4M436BAVCNFSM6AAAAACV2TYKJGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTKOBXGQZTONQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[bclay1297]

Jason: Is it possible that postgresql is not included in the gdal build when using the osgearth vcpkg builder? When I do ogrinfo --formats in my osgEarh application directory postgresql does not show on the list. If I go to a recent download of gdal i see postgresql Unfortunately thhose dlls are not compatible.

…

On Fri, Feb 20, 2026 at 2:06 PM Bruce Clay ***@***.***> wrote: Thanks Jason for the reply There were no error messages other than to say it could not open. I assumed that since ogrinfo could open it when executed from the same directory that I had all of the required dlls. Are there any tha osgEarth requires in addition to the GDAL ones? On Fri, Feb 20, 2026 at 11:54 AM Jason Beverage ***@***.***> wrote: > Do you get any error messages that you could share? > > — > Reply to this email directly, view it on GitHub > <#2921 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ADNLDTTNGFVU3QDT4ZGYXWL4M436BAVCNFSM6AAAAACV2TYKJGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTKOBXGQZTONQ> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >

[bclay1297]

It turns out the problem was with GDAL. When I rad ogrinfo with the gdal.dll created by the earth vcpkg build 64 formats were listed. Pgdump was one of them but Postgresql was not.

I pulled a fresh copy of GDAL and ran vcpkg on that. As a result 194 formats were listed including Postgresql.

[jasonbeverage]

Glad you figured it out!