First of all, do you need to use them for text search indexing? GIN and GiST are index specialized for some data types. If you need to index simple char or integer values then the normal B-Tree index is the best. Anyway, PostgreSQL documentation has a chapter on GIST and one on GIN, where you … Read more
The error means that the Postgres server is not running. Try starting it: sudo systemctl start postgresql I believe the service name is postgresql, but if that doesn’t work, try typing sudo systemctl start postgres and pressing tab to auto-complete. Make sure that the server starts on boot: sudo systemctl enable postgresql
node-orm2 looks good: supports association, validators, and mysql, postgres, and mongo (in beta) UPDATE: The node-orm2 package is no longer maintained. Possible alternatives include bookshelf or sequelize.
Compression is enabled by default for all string types, you don’t have to tell the database to do it. Check the manual about TOAST PLAIN prevents either compression or out-of-line storage; furthermore it disables use of single-byte headers for varlena types. This is the only possible strategy for columns of non-TOAST-able data types. EXTENDED allows … Read more
If you need to also be notified on DELETEs and delete the respective record in Elasticsearch, it is true that the Logstash jdbc input will not help. You’d have to use a solution working around the binlog as suggested here However, if you still want to use the Logstash jdbc input, what you could do … Read more
Option 1: Add pg to your Gemfile but skip trying to install it locally. $ cat Gemfile … group :production do # gems specifically for Heroku go here gem “pg” end # Skip attempting to install the pg gem $ bundle install –without production Option 2 (Debian/Ubuntu): Add pg to your Gemfile but first install … Read more
In PostgreSQL the rows will be locked as they are updated — in fact, the way this actually works is that each tuple (version of a row) has a system field called xmin to indicate which transaction made that tuple current (by insert or update) and a system field called xmax to indicate which transaction … Read more
You can actually just straight up change the column order, but I’d hardly recommend it, and you should be very careful if you decide to do it. eg. # CREATE TABLE test (a int, b int, c int); # INSERT INTO test VALUES (1,2,3); # SELECT * FROM test; a | b | c —+—+— … Read more
Use .psqlrc to set defaults. For the specific case of \x, newer psql versions (9.3, I think, but it might just be the 9.4 pre-release) can automatically switch to expanded output mode when the rows are too wide to fit on a line. From \?: \x [on|off|auto] toggle expanded output (currently off) So I suggest … Read more