Most likely you haven't created PostGIS extension onto the database yet. Make sure that the database has the PostGIS extension with pgAdmin.

If not yet, you can create the extension with this SQL statement. Assuming, of course, PostGIS has been installed into your machine already.

create extension postgis;

create extension postgis;

• One thing to note is that the different user was able to successfully create reader. 
• These errors are only specific to one user, but need to be resolved.

Sounds like grant issues. Make sure your user has sufficient rights.

To debug, try first to give the user full rights on the database schema. If that works, it's definitely a rights issue and you need to backtrack to find what's missing.

Hi @fmeuser_gc,

It seems you are with a solution already. You mention in a reply to Takashi that you have one user that can successfully create the reader. Expanding on David_r, I would look at the differences between these users and see what might need to be granted to the user with the error.

Also, in case there is an an issue with FME and the version of PostgreSQL involved, can you confirm the version of PostgreSQL/PostGIS you are using here? And can you provide the SQL script used to create the user with the error and the SQL script to create the user that works. Thanks.

The user reported they were able to get it to work by updating the search_path for the user.

Hi. I have worked on PostGIS previously but never encountered this error of extension.

So, I was working on a database with postgis version 2.4.4 and was working fine. But, this new database is version 2.3.4 and showing me the below error:

Any solutions for this?

Thanks.

Assuming postGIS extension has been enabled and you are writing to a schema 'staging' for example setting the search path explicitly to the schema you are going to write to first and public second. If public is not included this will also produce this error as FME cannot access public where all the postgis functions are.

This can be achieved by setting the search path in the SQL to Run Before Write.