My environment OS: AWS linux python 3.7 psql (PostgreSQL) 13.3 I am trying to use PostgreSQL with Django. I changed setting.py like below: I created a password for PostgreSQL and I successfully logged in as this user. However, when I tried to execute this: I got this error: pg_hba.conf looked like this first:…
Tag: postgresql
Cannot run Apache2 server in ubuntu [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack …
Adacore GNATCOLL Postgres library not installing on CentOS 8
I posted a question a couple of days ago regarding installing the GNATCOLL library on CentOS 8, which was kindly answered. I have now attempted to install the gnatcoll postgres library, which I was hoping would be the same process. However, when I attempt this, I receive the following error: Any help as to wh…
How can l start postgresql database using linux crontab?
postgresql database is starting in this way. but when I use linux crontab to start postgresql,it has failed. postgresql is not starting. I want to know why. Thank you! Answer You need to define which PostgreSQL instance to start. Try to add -D “PGDATA”. For example: If your Linux distribution is u…
PostgreSQL ERROR: could not access file “$libdir/postgis-2.5”
I’ve got a database with postgis installed, but it doesn’t work anymore: I found other answers which suggested running ALTER EXTENSION postgis UPDATE;, so I did, but it has no effect: Does anybody have any idea on how to solve this? (I’m on Ubuntu 20.04 with Posrgresql version 12.3. and I re…
x86_64-conda_cos6-linux-gnu-cc: Command not found with postgres function makefile
I am trying to do this tutorial: https://linuxgazette.net/139/peterson.html so I can learn to write postgres functions. It says to use this makefile, which fails: Errors: I have tried several things, including updating conda and anaconda, as per the answers to similar questions. Nothing has worked yet. How do…
How to fix syntax error at or near “psql” in psql ubuntu
I am entirely new to psql and not particularly familiar with some terms. I am following instructions on an ETL process for mimic-in the link here: https://github.com/chichukw/mimic-omop/blob/master/README-run-etl.md. When I run this code, it shows no output but this error: syntax error at or near “psql&…
How to concatenate a query with knextjs
Im trying to archive this SQL to Knext but i dont know how to do it THIS IS THE ORIGINAL QUERY and is fully functional in postgresql using the console THIS IS HOW IM TRYING TO ARCHIVE with knextjs Expected result: Get: Answer Ok. this is the final and correct answer using the same subquery; thanks to Mikael f…
can not connect to postgres db from node server
I want to connect my apps nodejs using node-posgres to PostgreSQL. My apps in linux server and my postgresql in another linux server by 176.9.154.123 IP. this is my error: this is my pg_hba.conf: Answer i can solve this problem by add this line to postgressql.conf:
[unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so’ : file not found
I have installed Postgresql 9.4 on Ubuntu 16.04, and installed postgresql ODBC and Unix ODBC drivers. When I test the ODBC connection with isql it works fine. Also, I am able to connect to the databases using pgadmin III from local and remote locations. But, when I am trying to install a software which will c…