permission denied to create extension “uuid-ossp”
Figured it out, I need to postegresql and change the root role to superuser: $psql ALTER USER root WITH SUPERUSER;
postgresql
Django: permission denied when trying to access database after restore (migration)
It turns out that you should grant explicit ownership of all objects in the database to the owner after restore. The owner is not a superuser. It’s not enough to only set the owner at database creation time. The final solution for migration goes like this: on the client: pg_dump -f dump.sql -Ox database on … Read more
Adding months to a date in PostgreSQL shows syntax error
Try something like: update salereg1 set expdate = current_date + interval ‘1 month’ * numberofmonths;
PG::InvalidParameterValue: ERROR: invalid value for parameter “client_min_messages”: “panic”
To make it work with PostgreSQL version 12, I monkey patched PostgreSQLAdapter class to replace ‘panic’ with ‘warning’ message. Note, if you can upgrade activerecord gem to 4.2.6 or higher versions you don’t need to have this monkey patch. I had to do this because my project depends on gem activerecord-3.2.22.5 require ‘active_record/connection_adapters/postgresql_adapter’ class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter … Read more
How to recreate a deleted table with Django Migrations?
In django 1.7 you can try: 1. Delete your migrations folder 2. In the database: DELETE FROM django_migrations WHERE app = ‘app_name’. You could alternatively just truncate this table. 3. python manage.py makemigrations 4. python manage.py migrate –fake If you are working in django 1.9.5 this is the 100 % solution for this problem: 1. … Read more
Cannot install psycopg2 Ubuntu
You’ve installed the python-dev libraries for Python 3. Your psycopg2 install is using python 2.7 If on Ubuntu 20.04 or above sudo apt-get install build-essential Then run the other steps for either Python 2 or 3: If you want to use Python 3: Make sure you’ve installed python3-pip sudo apt-get install python3-pip Then: pip3 install … Read more
PostgreSQL: GIN or GiST indexes?
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
PostgreSQL error: could not connect to database template1: could not connect to server: No such file or directory
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
Any Postgres compatible ORM for Node.js? [closed]
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.