Skip to content

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 Exchange site, you can leave a comment to explain where the question

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 using systemd and a systemd unit has been defined

x86_64-conda_cos6-linux-gnu-cc: Command not found with postgres function makefile

I am trying to do this tutorial: 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 I compile postgres function given this situation? Answer This error has occurred

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: When I run this code, it shows no output but this error: syntax error at or near “psql” I have tried adding semicolon, removing the psql part and removing the quotes and dollar

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 for the

Can not INSERT INTO Postgresql

simplechan In other words, I installed a message board named simplechan, but I can not log in to a site dedicated to the administrator. Because you need a password to get there. I do not know the password. I entered in psql as follows In “simplechan/sql/create_table_query.sql” it was drawn as follows. — tables for moderator things create extension if not