ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
I have a scientific database with currently 4,300,000 records. It's a scientific database, and an API is feeding it. In june 2020, I will probably have about 100,000,000 records. This is de layout of the table 'output': ID | sensor_ID | speed | velocity | direction ----------------------------------------------------- 1 | 1 | 10 | 1 | up 2 | 2 | 12 | 2 | up
I am using docker-compose.yml to create multiple running containers but failing to start Postgres docker server, with following logs and yes I have searched many related SO posts, but they didn't helped me out. Creating network "complex_default" with the default driver Creating complex_server_1 ... done Creating complex_redis_1 ... done Creating complex_post
I have just started to use TimescaleDB and want to create a hypertable on a table with events. Originally I thought of following the conventional pattern of: CREATE TABLE event ( id serial PRIMARY KEY, ts timestamp with time zone NOT NULL, details varchar(255) NOT NULL ); CREATE INDEX event_ts_idx on event(ts); However, when I tried to create the hypertable
I am trying to speed up the querying of some json data stored inside a PostgreSQL database. I inherited an application that queries a PostgreSQL table called data with a field called value where value is blob of json of type jsonb . It is about 300 rows but takes 12 seconds to select this data from the 5 json elements. The json blobs are a bit large but the
My operating system is Linux. I am going to connect Superset to PostgreSQL. PostgreSQL port is open and its value is 5432. PostgreSQL is also running and not closed. Unfortunately, after a day of research on the Internet, I could not solve the problem and it gives the following error: The port is closed. Database port: command: lsof -i TCP:5432 python3 13127
My Node.js app is able to work with local Postgres database via npm pg module. I can connect to the Heroku hosted Postgres database (free Hobby Dev plan) via command line with heroku pg:psql command as well. But when my Node.js app is trying to query to Heroku hosted Postgres database I am receiving an self signed certificate error. Here is the output with s
In our company we have a dump of PostgreSQL database - file db.sql . It weighs 8 Gigabyte. How to restore this database in DBeaver? And we don't have another databases in DBeaver 7.0.5. I have digged all Internet and haven't found anything how to do this without another database/
I need assistance as I'm having trouble connecting to a managed Postgres database on RDS. I'm encountering the following error message: "no pg_hba.conf entry for host '16.151.149.51', user 'analytics', database 'database', no encryption" I have confirmed that encryption is functioning properly, and I've also added the IP to the security groups. What steps sh
I have a scenario, where I have data for informal communications that I need to be able to search. Therefore I want full text search, but I also to make sense of spelling mistakes. Question is how do I take spelling mistakes into account in order to be able to do fuzzy full text search?? This is very briefly discussed in Postgres Full Text Search is Good Eno
docker
json
heroku
javascript
dbeaver