pg Questions
3
Solved
I'm trying to do an insert or update in a postgres database using node.js with pg extension (version 0.5.4).
So far I have this code:
(...)
client.query({
text: "update users set is_active = 0, ...
Stubblefield asked 26/10, 2011 at 23:34
2
Solved
When I run the command psql --version within the railsApp container, I get 9.4.12 and when I run the same within the postgres container, I get 9.6.2. How can I get the versions to match?
I am gett...
Stale asked 26/6, 2017 at 21:22
2
Solved
I received this error after running
export DATABASE_URL=postgres://$(whoami)
on the command line. Now when I run the command
$$ rake db:migrate
This is the full error
rake aborted!
PG::Conne...
Fealty asked 17/8, 2016 at 19:18
5
I used this command to backup 200GB database (postgres 9.1, win7 x64):
pg_dump -Z 1 db_name > backup
It created 16GB file, which is fine I think because previous backups which works (and were pac...
Legumin asked 7/10, 2012 at 11:17
1
Solved
I am beginning to build out the user authentication part of my application and I am using PostgreSQL as my database. I have a table set up in PG with the following code. This is the code I used to ...
Belita asked 17/8, 2019 at 8:4
4
Solved
I have a column in postgres database with type date. It is a column like birthday, which is just a date and does not need to have a time part.
When fetching this column with knex, the result is a ...
Delora asked 6/6, 2018 at 8:52
18
Solved
WhenI run (as root)
gem install pg -v '0.12.0' -- --with-pg-config=/usr/pgsql-9.1/bin/pg_config
I get the following output:
#-> gem instal pg -v '0.12.0' -- --with-pg-config=/usr/pgsql-9.1...
Nichols asked 10/2, 2012 at 21:20
3
Solved
I am using node-postgres for a production application and I am wondering if there is anything I should be concerned about? Is the data sanitized automatically by node-postgres?
I couldn't find any...
Weakwilled asked 4/1, 2017 at 3:2
3
There is a frustrating issue where my rails migrations update the schema with whitespaces and the position of the table's columns.
So most times when I run bundle exec rake db:migrate it will do o...
Decomposed asked 18/7, 2013 at 2:27
1
Using pg in my NodeJS application I would like to be able to pass an array to a function so that I can use the IN statement as part of my query
Example
async function myMethod(array) {
// array ...
Hellfire asked 17/12, 2018 at 15:13
0
I have a database postgres on azure, whith General Purpose, 2 vCore(s), 100 GB.
at this moment, when i do a simple request to database, database answer me lot of times with message:
Unhandled rej...
Collin asked 25/10, 2018 at 13:28
4
Solved
There appears to be a lot of documentation (e.g. https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-node-js, but also elsewhere including this site) indicating that the proper me...
2
Solved
I have a script that connects to DB and can get data from it
Can I somehow make it to notify me, when any new record is added to the DB table
Majolica asked 12/9, 2018 at 7:6
1
Solved
I have following setup for my project, using the pg node-postgres package:
The simple table 'tmp' looks like this:
According to jsonORG and the postgres docs the object:
{"foo" : true}
is ...
Tarratarradiddle asked 28/6, 2018 at 9:54
2
Solved
I was using active record to get my stories and then generate a CSV, the standard way as done in the rails cast. But I have a lot of rows and it takes minutes. I think if I could get posgresql to d...
Garman asked 14/1, 2014 at 23:35
0
I'm developing a Rails application on Heroku that needs to make callout's to our customer's databases. We have setup a proxy to make our outbound IP address static and are now configuring our 'conn...
Rectal asked 16/7, 2018 at 2:34
0
I am creating code using just the pg module, where I have a general function for executing queries. This function can create a client on the spot if it doesn't take an already existing client as an...
Cyclostome asked 4/6, 2018 at 13:56
3
I have recently tried to upgrade my rail 3.2* application to rails 4.2.*. But, I was stopped while installing the 'pg' gem. When I googled it, the solutions which are mostly related to OSX only. Bu...
Perdu asked 6/2, 2015 at 10:53
3
I am trying to install the pg (PostreSQL) gem for Ruby. I am receiving this error:
postgres/9.2-pgdg/bin/64/pg_config
Using config values from /location/to/install/postgres/9.2-pgdg/bin/64/pg_conf...
Wedgwood asked 8/3, 2013 at 18:41
8
Solved
I am trying to install the pg gem for use with Postgres.app on my local machine. I am running Mavericks.
Postgres.app is installed and running fine, but I cannot get the gem to work. I've done the...
Logan asked 26/11, 2013 at 17:55
2
Solved
I have a production server running ubuntu 14.04, Rails 4.2.0, postgresql 9.6.1 with gem pg 0.21.0/0.20.0. In last few days, there is constantly error with accessing to a table customer_input_datax_...
Nieman asked 20/7, 2017 at 14:50
4
Solved
Getting:
An error has occurred:
Error connecting to the server: fe_sendauth: no password supplied
Settings in database.yml are the same as the app setup on other machines.
How can I set things...
So asked 17/9, 2012 at 1:9
2
Solved
I have a little or no knowledge at how to properly implement postgres connection pool in node.js modules.
My question is : Is it problem when I am creating new Pool in every module where I need a ...
Ramires asked 3/8, 2016 at 15:29
7
When I run:
rake db:setup
i get:
fe_sendauth: no password supplied
Couldn't create database for {"adapter"=>"postfresql", "encoding"=>"unicode",
"host"=>"localhost", "pool"=>5, "u...
Mute asked 6/8, 2014 at 11:49
16
Solved
When I try to run bundle (bundle install), I all the time get
Installing pg (0.13.2) with native extensions
Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.
/Us...
Demasculinize asked 12/3, 2012 at 14:17
© 2022 - 2024 — McMap. All rights reserved.