score:3
You have several approaches here:
Search for the file yourself, using some command like
find / -name "postgres.h" -print
this will tell you (on my Mac does) the file is in:
/usr/local/Cellar/postgresql/11.2_1/include/server/postgres.h
and add the
-I /usr/local/Cellar/postgresql/11.2_1/include/server
option to the compiler. Check your postgresql version for the possibility of having a different one.Probably there's another package for database development. Search for a package named
postgresql-dev
or similar, and install it. After searching packages with:brew search postgres
and
brew search psql
on my system doesn't appear anything that matches.
EDIT
I've checked a FreeBSD system for that file and it appears on
/usr/local/include/postgresql/server/postgres.h
So probably you have to #include <server/postgres.h>
instead, and use the appropiate -I
flag (as mentioned above)
score:45
Install postgresql-server-dev package with this command:
sudo apt install postgresql-server-dev-XX
Replace [XX] with your already installed version of postgresql:9.5, 10, 11, 12
More questions
- How to fix 'postgres.h' file not found problem?
- How to fix "InternalError: variable not found in subplan target list"
- Postgres error after updating TimescaleDB on Ubuntu: file not found
- How to fix Error: pg_config executable not found on Elastic Beanstalk permanently
- Rails and Postgres problem querying record that was stored in UTC; app Timezone is UTC but record is not being found
- How to fix this problem in postgres psql command?
- how can i solve this error "Conversion from string "\N" to type 'Double' is not valid" when loading from a csv file to postgres database?
- How to fix Postgres error column does not exist?
- How to fix this ERROR: could not open file "pg_wal/00000003.history", or what *not* to do when PostgreSQL runs out of disk space
- how to fix the problem of zero bytes file getting generated when using pg_dump through cron job for regular backup?
- How to fix "ERROR: column c.relhasoids does not exist" in Postgres?
- Postgres ERROR: could not open file for reading: Permission denied
- How to restore PostgreSQL dump file into Postgres databases?
- Postgres is failing with 'could not open relation mapping file "global/pg_filenode.map" '
- How can I import a .sql file into my Heroku postgres database?
- How to fix error "Error: Database is uninitialized and superuser password is not specified."
- How do I fix stale postmaster.pid file on Postgres?
- How to allow permission to access CSV file using postgres in Ubuntu
- How to make Postgres Copy ignore first line of large txt file
- How to download Postgres bytea column as file
- Postgres - Return error on update if record not found
- How do I fix Postgres so it will start after an abrupt shutdown?
- How to fix "Error: The server does not support SSL connections" when trying to access database in localhost?
- Postgres Tutorial: pg_restore: [archiver] input file does not appear to be a valid archive
- How to save a image file on a Postgres database?
- how to fix postgres after updating/upgrading brew
- How to spy on a transaction that is not yet committed in Postgres for debugging?
- How to fix error on postgres install ubuntu
- Postgres JDBC maven dependency not found
- What does Import Error: Symbol not found: _PQencryptPasswordConn mean and how do I fix it?
More questions with similar tag
- Can't set boolean values when import data from csv to postgresql
- PostgreSQL match a string from a nested query
- Count unique rows GROUP(ed) BY different columns than used in DISTINCT ON
- PGPool 'SHOW pool_nodes' returns 'ERROR: unrecognized configuration parameter "pool_nodes"' over jdbc
- Loop inside the function runs as a single transaction and reads data of a single snapshot
- How to pipeline different scrapy spider results into different tables
- Please give me example for differences of cidr and inet datatypes in PostgreSQL
- Return right content searching a substring in dictionary- Postgresql
- How do I apply a condition on a related table for the last records?
- Docker with Python and PostgreSQL
- Determine if PostgreSQL query ran from disk or from memory cache?
- Get amount of all used ingredients in ordered dishes (Django ORM) to make a shopping list
- postgresql function confusion
- What does it mean when psql has blank database access privileges?
- libpq only inserts first character in string column
- How to find which entry has the most identical values in other columns
- POSTGRES JSON: Updating array value in column
- SQL Server MERGE statement in Postgresql?
- Error in ./configure step in installation of libpqxx
- PostgreSQL, drag and swap
- PostgreSQL - Count Number of Classes that uses Lecture Theaters
- Golang: Multiple SQL query generate extra empty {{range.}}
- Heroku flask UndefinedTable relation doesn't exist
- Select the 5 sport disciplines in which there is the less sport event
- More than one row returned by a subquery used as an expression but only in function
- How to select from a table with condition from json column?
- Django ORM vs PostgreSQL raw sql
- SQLAlchemy: how to refer to filtered fields
- I can't connect to my postgres database on Docker from Intellij
- SELECT ... INTO a variable within a postgres CTE