postgresql-11 Questions
5
Solved
Shared Memory files getting deleted some time (~15 hours) in Postgres 11
2019-07-09 08:46:41 CDT [] [6723]: [1-1] user=,db=,e=58P01 ERROR: could not open shared memory segment "/PostgreSQL.2916916...
Symphonia asked 9/7, 2019 at 14:18
5
According to the documentation (https://www.postgresql.org/docs/current/app-psql.html), even with AUTOCOMMIT set to off, PSQL issues an implicit BEGIN just before any command that is not already in...
Quartis asked 8/11, 2018 at 19:21
2
Solved
I want to use an ICU system-insensitive sorting collation, to avoid sorting differences between postgres11-on-mac vs postgres11-on-Ubuntu. My first test was to dump out my existing Collate=en_US.UT...
Roup asked 5/4, 2020 at 20:8
6
When installing Postgresql 11 I got an error. I did the lesson right. Searched Google but didn’t find. I'm not trying to run different versions of postgresql, I'm just trying to install it.
Ruralize asked 8/1, 2019 at 4:28
3
This is the JSONB array data type in the model and postgres database:
.
.
.
MyField: {
type: DataTypes.ARRAY(DataTypes.JSONB),
allowNull: false
}
.
.
.
The table field contains JSONB values:...
Rijeka asked 21/7, 2019 at 12:10
3
Solved
I am wondering if there is a way to get cosine distance of two vectors in postgres.
For storing vectors I am using CUBE data type.
Below is my table definition:
test=# \d vectors
Table "publi...
Multifarious asked 29/6, 2019 at 10:33
4
I am in CentOS Linux release 7.5.1804 (Core)
When I login as postgres and run:
bash-4.2$ /usr/pgsql-11/bin/initdb -D /var/lib/pgsql/11/data
The files belonging to this database system will be own...
Duodenitis asked 24/10, 2018 at 7:20
5
I downloaded local PosgreSQL 11 on Windows 10.
I try to change directory in psql on command line window to c:\Program Files\PostgreSQL\11\bin>
I get either invalid command or directory does not ...
Emmet asked 8/1, 2019 at 14:10
3
Solved
I have a simple t = Date.now; which goes to Postresql t_time column declared as timestamp with time zone via REST API.
I got the error:date/time field value out of range.
I can't use the answer fr...
Expenditure asked 29/6, 2019 at 19:41
10
Solved
i got a new laptop from Dell(XPS 15), with Windows 10 Pro.
I have always the same issue During installation of postgres "Problem running post-install step. Installation may not complete correctly. ...
Justus asked 11/2, 2019 at 13:14
2
Solved
PostgreSQL supports stored procedure (not function) since version 11. I created a stored procedure like this:
CREATE OR REPLACE PROCEDURE get_user_list ()
LANGUAGE SQL
SECURITY DEFINER
AS $$
S...
Novanovaculite asked 17/6, 2018 at 6:29
3
I am trying to use node-pg-migrate and run migrations to create tables in my node project.
When I run migrations I get function uuid_generate_v4() does not exist.
I did check in my extensions and ...
Impostor asked 1/6, 2019 at 23:7
1
Solved
I have a user with read-only access in my PostgreSQL 11.
How can I give them access to write/edit data in some of the database tables, e.g. Table1 and Table2 only?
I don't want them to change the D...
Rattan asked 5/1, 2023 at 0:12
3
I am trying to write a base type for PostgreSQL in C (using xcode), and I already installed PostgreSQL 11, but it seems that postgres.h cannot be simply included in the file ("'postgres.h' file not...
Davina asked 23/6, 2019 at 14:2
18
Solved
I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's a...
Compelling asked 7/3, 2019 at 8:12
1
Solved
We have setup database postgresql 11 on a system. There are about 8 tables. From few days, we are facing this problem
ERROR: invalid page in block 9698 of relation base/16385/16560 SQL state: XX00...
Strikebound asked 17/6, 2020 at 5:53
1
Solved
I get a table with type _text
create table mt ( id int8,
directions _text null)
Its not my code so I don't know what is type _text and how to work with it.
I look for it in doc https://www.postgr...
Victorinavictorine asked 3/3, 2022 at 6:33
2
Solved
Given the following DDL
CREATE TABLE numbers (
id BIGSERIAL PRIMARY KEY,
number BIGINT
);
CREATE INDEX ON numbers (number);
In PostgreSQL 13 I can use the following query:
SELECT *
FROM numbers
...
Vermeil asked 11/2, 2022 at 1:51
2
Solved
I'm having trouble with a build of a Rails application for a PostgreSQL 11.2 database.
Here's the .travis.yml file:
rvm:
- 2.6.1
dist: xenial
services:
- postgresql
addons:
postgresql: "11.2"
...
Considered asked 14/3, 2019 at 11:50
1
Actually I am new to PostgreSQL. I want to alter existing partition to increase range value. For example I have below partition
PQR_271 FOR VALUES FROM ('260000000') TO ('270000000')
Here I want to...
Humming asked 21/10, 2021 at 5:50
1
Solved
I am using PostgreSQL 11.8
CREATE INDEX ix_products_product_sku_with_json_columns
ON products USING btree((product_sku))
INCLUDE ((data->>'variantCode'));
ERROR: expressions are not support...
Carabineer asked 27/8, 2021 at 16:22
3
Solved
I'm looking for the BLOCKSIZE configuration in postgres. I want to know is there a way to change/set the value?
Shackleton asked 15/5, 2019 at 10:59
1
Solved
I converted a PGsql Function to Procedure (v11) for transaction purpose. But while calling that procedure from Java code, java code is throwing below exception:
2021-01-10 21:52:56,604 WARN [ForkJo...
Mabelmabelle asked 13/1, 2021 at 6:45
3
Solved
I'm pretty new to PostgreSQL so the question may be simple. So.
I have installed PostgreSQL 11 and pgAdmin 4 on Fedora 29. I can connect to the database via terminal or AzureDataStudio, but when I ...
Psychosomatics asked 12/5, 2019 at 19:1
1
Solved
I'm working with some dates in ISO 8601 and when casting to timestamp I get some oddities in the millisecond:
SELECT '2020-05-15T19:01:59.002+00:00'::timestamp
2020-05-15 19:01:59:02 <--- wrong ...
Dichogamy asked 15/7, 2020 at 3:14
1 Next >
© 2022 - 2024 — McMap. All rights reserved.