Using VSCode. Installed latest Node.js (first time user) for Windows, and the desired modules, one of which was 'pg' (npm install pg) At the top of my script I have this: const pg = require('pg');...

I am using the Ruby on Rails 3.1 pre version. I like to use PostgreSQL, but the problem is installing the pg gem. It gives me the following error: $ gem install pg Building native extensions. This ...

I get this error every this I run my Rails app (It cannot connect to my local Postgresql) /Users/leonardo/.rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.11/lib/ active_record/connection_adapters/...

I'm trying to run an app with script npm run serve:dev but it gives an error Error: Please install pg package manually when trying to run npm run serve:dev I already tried npm install -g pg','npm i...

I just want to ask which database module is better, PG or sequelize? I heard that sequelize has sometimes problem with transaction. Thanks

I try to connect to rds postgresql version 12 from nodeJs as mentioned below. It works completely fine without any issue. const config = { user: process.env.PG_DB_USERNAME, password: process.en...

I am trying to create an ActiveRecord Object.But I'm getting this error while creating it. (0.1ms) ROLLBACK ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR: current transaction i...

Running postgreSQL 9.4.5_2 currently I have tried pg_ctl stop -W -t 1 -s -D /usr/local/var/postgres -m f Normally no news is good news but after I will run pg_ctl status -D /usr/local/var/p...

i have a query that goes select count(id), status, "createdAt"::date from "ProjectLog" where "projectId" = (select id from "Project" where slug = ${id}) and ...

I tried to install pg gem and I have had this warning: You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application. ...

There is an issue with installing ruby on ubuntu 22.04 with rvm as it will give you error below Error running '__rvm_make -j8', please read /usr/share/rvm/log/1655413907_ruby-2.5.0/make.log There...

I'm having trouble working through a gem load error on AWS Lambda. { "errorMessage": "LoadError: libpq.so.5: cannot open shared object file: No such file or directory - /var/task/vendor/bundle/ru...

I am using PostgreSQL in my NodeJS backend service. All of sudden, when I start the service I am facing below error connection error error: sorry, too many clients already. PostgresSQL connect...

Heyo. I apologize in advance if this question has been answered in another thread. I've searched through the site but I didn't find an answer. However, the closest related issue was Ruby on Rails /...

I have following errors in pg_log file several thousand times. How to resolve them. index "meeting_pkey" contains unexpected zero page at block 410.Please REINDEX it. index "faultevent_props_pkey"...

I have a model with calls the products with SORT/PAGE/PER PAGE It works fine with numerical values as parameters but not strings. This works fine... params.limit = 12 client.query('SELECT * FROM p...

I've been trying to install a rails project on my computer (Macbook Pro 2020 with M1) running Big Sur. I have the PostgresApp installed. When running bundle install it fails to build the pg gem so ...

Whenever I run bundle install on my VPS (CentOS Linux release 7.0.1406 (Core)) I get an error when installing the pg gem. No pg_config... trying anyway. If building fails, please try again with --...

I'm trying to develop in Ruby on Rails using PostgreSQL locally, so I'm trying to install the pg gem. On Ubuntu 12.04. In terminal, I typed in: gem install pg -v '0.12.2' Which throws the follo...

I'm trying to create a node app that can set itself up on the database end by creating a database then the table and fields after. Below are the two functions I'm using to do each task independentl...

$ sudo bundle install Result Fetching gem metadata from https://rubygems.org/........... Fetching gem metadata from https://rubygems.org/.. Using rake (0.9.2.2) Using i18n (0.6.1) Using multi_...

Pg-promise is Not returning anything for 60s and gets timed out while running server setup with express-generator. There are no error messages. All the routes without db.any or similar query, works...

I run a daily backup of my database using pg_dump and pg_restore that recently stopped working after I pushed an update. I have a function validate_id that's a Case/When statement just as a quick c...

I'm trying to install PostgreSQL's pg gem for Ruby. I issued the following command: gem install pg I installed Ruby 1.9.2 using RVM. The above command shows me the following error. The error ...

So I'm starting to use the Postgres JSON datatype, now that there's a lot of fun stuff you can do with it. In one of my Rails apps which is not yet Rails 4 (where support for Postgres JSON has been...