I am using SQLite3 for development and PostgreSQL for deployment. However, I am facing the following problem: My simple search using SQLite3: def self.search(
I need to specify sslmode=allow when using psql to connect to my PostgreSQL DB, like: psql sslmode=allow -h localhost -p 5432 otherwise I get server does not su
I am having an issue running migrations with TypeORM (with the intent of establishing my database for use in local development). In running a migration on the i
I wonder if there is an alternative to the psql command to test the connection to a postgresql database using bash. I'm setting up a Core OS cluster and have a
I wanted to create a replicate of my production database for staging and created the staging DB instance from a production snapshot. However, this new instance
Trying to connect to an Azure PostgreSQL server from my local Strapi project (eventually deployed in a docker container). I have the connection configured accor
I have installed PostgreSQL. However everytime I try to connect through PGAdmin or through psql it gives me the below error. could not connect to server: Conne
Background Users can type in a name and the system should match the text, even if the either the user input or the database field contains accented (UTF-8) cha
Hello i get this error after i run docker-compose build up But i get this error postgres_1 | Error: Database is uninitialized and superuser password is not spec
I've got a problem with Criteria from Doctrine2. Iusing Criteria to check a SMALLINT type in PostreSQL like this : $criteria = Criteria::create()->where(Crit
Using Postgres, I'm trying to use AUTO_INCREMENT to number my primary key automatically in SQL. However, it gives me an error. CREATE TABLE Staff ( ID
I have a simple query in PostgreSQL which is ok when I run it without any query parameters : select date_trunc('week', action_time),count(*) from event
Rails 3.2 app running on Heroku with Postgres. I added an index add_index :lines, :event_id Events have_many Lines. There are about about 2 million Lines and
While trying to execute this command: (venv) sreekarsiddula@Sreekars-MacBook-Air bidgala % /Users/sreekarsiddula/piapps/venv/bin/python3 manage.py createsuperus
I want a random selection of rows in PostgreSQL, I tried this: select * from table where random() < 0.01; But some other recommend this: select * from table
Currently I need to move my database from postgreSql to google cloud sql. I use pg_cron to remove stale records like this: SELECT cron.schedule('30 3 * * 6',
How do I write an SQL script to create a ROLE in PostgreSQL 9.1, but without raising an error if it already exists? The current script simply has: CREATE ROLE
I want to know if it is possible to store multiple values in a field in PostgreSQL. I have a table called Token with the columns id, text and category. categor
I want to fetch the last n rows from a table in a Postgres database. I don't want to use an ORDER BY clause as I want to have a generic query. Anyone has any su
I have a table in PostgreSQL with many columns, and I want to add an auto increment primary key. I tried to create a column called id of type BIGSERIAL but pgad