Datavalley Community

3

Anonymous

Asked: July 7, 2023In: Data Engineering

How to change the retention policy time interval in Timescale DB?

3

Hyper table’s retention time interval is unable to be changed in Timeframe DB. Is there a solution or alternative methods to change the time period after a Hyper table’s retention policy is set?

3

PeggyProfessional

Asked: July 7, 2023In: Programs

Getting an error after updating to PostgreSQL version 11.

3

I am looking to upgrade PostgreSQL from old version to version 11 on a Linux server. I dumped the database, by the way. Afterwards I installed PostgreSQL 11 and ran the script to import the dump into PostgreSQL 11. But I’m getting this ...

2

MeetPundit

Asked: July 7, 2023In: Data Engineering

How to query using TIMESTAMP in PostgreSQL?

2

I have a datetime stamped object 2023-07-07 02:12:18.624. I tried using the following query: select * from device where to_char(device_created_at,'YYYY-MM-DD HH24:MI:SS.FFF') = '2023-07-07 02:12:18.624' How to query using TIMESTAMP in PostgreSQL?

1

AdithyaPundit

Asked: July 6, 2023In: Data Engineering

How to block users from editing a table in PostgreSQL?

1

I want to block users from editing the table like adding or deleting rows or columns from the table. Please mention how to restore those user privileges later.

3

CalvinExplainer

Asked: July 1, 2023In: Data Engineering

Getting ERROR: relation "user" does not exist in PostgreSQL

3

I’m getting an error when accessing the table named ‘user’ in postgreSQL. Even though the table is available, it displays an error stating that the table does not exist. ERROR: relation "user" does not

2

MeetPundit

Asked: July 1, 2023In: Data Engineering

How to convert csv files to parquet in nodejs?

2

I want to convert Postgres database tables to parquet file format. Since the format is not supported Postgres, I converted it into csv format. How can I convert this csv file to parquet format using NodeJS?

1

PeggyProfessional

Asked: July 1, 2023In: Programs

Getting error on dbListonnections in Postgres.

1

I’m getting an error in connection with Postgres whereas dbListConnections(dbDriver(PostgreSQL)) is working. On using dbListConnections(dbDriver(“Postgres”)) it is showing an error. Error:unable to find an inherited method for function ‘dbListConnections’ for signature ‘"PqDriver"’

5

PeggyProfessional

Asked: June 27, 2023In: Data Engineering

How can I Install pgAgent on Postgres Alpine?

5

I’m having a Postgres container that uses Postgres alpine as its base image. On this base image, I would like to install pgAgent. How to do that? I have attempted to install the source code within the container ...