Stack Overflow
Stack Overflow

Questions tagged [apache-age]

Use this tag for programming, integration and configuration questions related to using Apache AGE in your software project. Apache AGE is a extension to PostgreSQL which provides graph database capabilities.

Apache AGE is an extension to PostgreSQL providing graph database capabilities.

A core objective of Apache AGE, from their overview, is:

"to create single storage that can handle both relational and graph model data so that users can use standard ANSI SQL along with openCypher, the Graph query language."

Resources:

420 questions
-1
votes
13 answers

How to use the official Apache AGE docker image?

I have followed the official documentation in order to run the container, using docker pull apache/age docker run \ --name age \ -p 5455:5432 \ -e POSTGRES_USER=postgresUser \ -e POSTGRES_PASSWORD=postgresPW \ -e…
Marco Souza
  • 296
  • 7
-1
votes
9 answers

How Do I Fix 'Metadata Load Error' in AGE Viewer?

When using npm start to start AGE Viewer, I get the following error in my terminal. Error: Not connected at _callee4$ (/home/hallixon/age-viewer/backend/src/controllers/databaseController.js:64:19) at tryCatch…
Emmanuel Allison
  • 56
  • 1
  • 6
-1
votes
6 answers

Is it possible to insert a tuple to two tables at the same time?

Im developing a feature for the apacheAGE extension and basically I want to insert a tuple to two tables at the same time. I know that Postgres provides the inheritance system, so you can access the tuples from the parent table and the child table.…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
-1
votes
3 answers

Error while configuring the PEM server Either database server installation path is incorrect or the required psql binary is not installed

I am trying to install Postgres Enterprise manager in my Linux distro Ubuntu for my Windows machine by following this tutorial on their official website. Postgres Enterprise Manger requires two different Postgres to function, first the server it…
Chidera Stella Onumajuru
  • 35
  • 5
-1
votes
3 answers

Error in SQL Query: Retrieving Users with Duplicate Email Addresses Registered in the Last 30 Days

I am trying to retrieve data from public.users tables and this the query I am using but I am not able to retrieve, what i actually require: WITH duplicates AS ( SELECT email, COUNT(*) AS duplicate_count FROM public.users GROUP BY email …
Mahina Sheikh
  • 43
  • 5
-1
votes
5 answers

Facing error while creating an extension in PostgreSQL

There is an error while creating an extension of the performance benchmark in PostgreSQL. I have already made pawankukreja superuser, but it is not working and keeps giving me this error while following this manual. cd ~ time psql postgres -c…
Pawan Kukreja
  • 3
  • 8
-1
votes
7 answers

Apache age extension setting error while installation

I have followed all steps to install apache age with postgres 12 but i have encountered error while setting extension CREATE EXTENSION age; ERROR: could not open extension control file "/usr/local/share/postgresql@14/extension/age.control": No such…
MOIEZ IBRAR
  • 39
  • 5
-1
votes
4 answers

Error while installing PostgreSQL in Ubuntu

I am downloading PostgreSQL on my Ubuntu version 18.04 and getting these errors while installing Postgresql version 12. I have ran following command sudo apt-get install postgresql postgresql-client Error How to resolve these errors.
Pawan Kukreja
  • 3
  • 8
-1
votes
9 answers

Error while creating an extension in PostgreSQL

In the PostgreSQL client (postgres): create extension addme; Error: ERROR: extension "addme" has no installation script nor update path for version "0.0.1" How can I resolve this error while creating an extension in PostgreSQL? How do I resolve…
Pawan Kukreja
  • 3
  • 8
-1
votes
9 answers

Relation "user" does not exist

For some reason, I am facing this issue that in the existing database I have a user table where I have stored data manually, but when I am trying to access it through the query, I get this error. ERROR: relation "user" does not exist Can you kindly…
Mahina Sheikh
  • 43
  • 5
-1
votes
11 answers

Facing Error While Reinstalling Apache Age in Ubuntu 22.04

I was trying to reinstall Apache Age on my Laptop which uses Ubuntu 22.04, the command I used to install Apache Age is sudo apt install postgresql-12 postgresql-server-dev-12 followed by using the command make install But then I face the following…
Mahina Sheikh
  • 43
  • 5
-1
votes
3 answers

Cannot drop "ag_catalog" schema or other tables from PostgreSQL (ERROR: table "ag_label" does not exist)

On my postgres database, I have some tables that were created on the wrong schema ("ag_catalog") and I decided to drop it anyway since it was just for testing. I had also installed the age extension, but then I dropped it with DROP EXTENSION age;.…
Matheus Farias
  • 716
  • 1
  • 10
-1
votes
6 answers

Creating a graph with Python and AGE

I wanted to create a Python file that has multiple functions for creating graphs, nodes and edges. The code that I wrote only includes the function for creating a graph: import psycopg2 GRAPH_NAME = "test_graph" conn =…
Matheus Farias
  • 716
  • 1
  • 10
-1
votes
4 answers

Connectedness of a graph in Apache AGE?

How can we check connectedness of a graph in Apache AGE? If nodes are labeled as "vertex" and edges labeled as "distance," Then, Here's my Cypher query: MATCH (start:vertex) OPTIONAL MATCH path = (start)-[:distance*]-(end:vertex) WHERE end IS…
MAHMUDUL
  • 1
  • 2
-1
votes
6 answers

Apache Age Query

I am building an educational application and one of its features is at once student can only be enrolled in 5 courses so for that purpose I need to create a trigger which executes once the student enrolls in the 6th course. Basically the trigger…
Umer Freak
  • 21
  • 3
1 2 3
…
27 28