Managed Postgres is missing libprotobuf-c (support for vector tiles)

Posted on November 28, 2020

DigitalOcean Managed PostgreSQL Database

Hello,

I’m really excited about the managed postgres offering, especially with PostGIS enabled by default.

Unfortunately, it was not compiled with support for protocol buffers (protobuf). I found out during runtime when I got this error message: django.db.utils.InternalError: Missing libprotobuf-c.

This makes functions like ST_AsMVT() unavailable. They’re at the core of my product (which is a map-based product using dynamic vector tiles).

Are there short-term plans for inclusion of this library? If not, I’m going to have to stick to Droplets instead of Apps.

Thanks!

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby

August 21, 2023

Hey,

I’ve just tested this out and it seems like that the ST_AsMVT() function is available now. I was able to verify this with:

SELECT * 
FROM pg_catalog.pg_proc 
WHERE proname = 'st_asmvt';

And then used the following sample query to test it out as well:

SELECT ST_AsMVT(tile)
FROM (
  SELECT ST_AsMVTGeom(
    ST_GeomFromText('POINT(30 10)', 4326), -- Geometry
    ST_MakeBox2D(ST_Point(0, 0), ST_Point(4096, 4096)), -- Tile bounding box
    4096, -- Size
    0, -- Buffer
    false -- Clip geom
  ) AS geom
) AS tile;

If you still have a feature in mind that is missing, the best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.