All Questions
Tagged with postgresql pgadmin
1,533 questions
1
vote
2
answers
110
views
How to find the table name and when it is last used in PostgreSQL?
I am using PostgreSQL (on GCP Cloud SQL) and I want to find out when each table in the database was last used (read or write).
So far, I have checked:
pg_stat_user_tables → this shows row counts, ...
- 31
0
votes
1
answer
82
views
PostgreSQL Force Index Scan
I have a table with below columns in PostgreSQL.
id,
location,
store,
flag1,
flag2
Here id, location, store are contributing to Primary Key. So by default postgreSQL creates an index on it.
I have ...
3
votes
2
answers
120
views
Postgres move partition to archive table
I have a main prod table which I am converting to partitions and am taking a deep dive into Postgres (v14) partitioning on an isolated test system.
On the test system I have two schemas a production ...
- 141
0
votes
1
answer
235
views
Postgres localhost connection timeout (but was working before)
>> psql
psql: error: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D
/10061)
Is the server running on that host and accepting TCP/IP ...
- 2,180
0
votes
1
answer
76
views
How to use Rank Function With Condition in Postgres
For the following sample table I want to set ranks to each group order by start_date desc but I want the admin to be always set to rank 0
name
start_Date
group_no
Admin
2023-01-01
0
A
2021-01-01
0
B
...
- 955
0
votes
0
answers
133
views
AWS RDS PostgreSQL Engine upgrade failure
I recently spun up a test environment to conduct a test of upgrading a database from my production environment. Upgrading attempts for the engine version 14.15 to 15.10, 16.6 and 17.2 have all failed. ...
- 1
0
votes
2
answers
213
views
Why does this multiple "DO" block script work in DBeaver but fail in pgAdmin?
I have created a script to be run on a Postgres DB, and it works perfectly when run in DBeaver as long as Autocommit is turned on, but when the same script is run in pgAdmin with Autocommit turned on, ...
- 991
0
votes
1
answer
72
views
How to get a SQL script log in PostgreSQL
As a team of developers we only have access to the dev database to make changes in tables, views, etc. When it comes to the test, stage, and production environments we send the "SQL script" ...
- 1,047
0
votes
1
answer
46
views
Why does my schema qualifier gets dropped after I create a materialized view?
Curiously I'm running into a situation where if I create a materialized view such as
create materialized view if not exists banana.my_view tablespace pg_default
as
select column_a, column_b, column_c
...
- 1,731
1
vote
2
answers
74
views
postgresql TLE password_check function and pgadmin
We are trying to implement strong password policies to our aws hosted postgresql RDS instances using TLE (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/...
0
votes
1
answer
186
views
AWS RDS Connection with SSM and Bastion - pgAdmin Connection Timeout
I have an AWS RDS that I'm accessing securely via AWS SSM and Bastion. I do the following to start an AWS session:
In my terminal, set AWS session credentials
Run AWS SSM: aws ssm start-session --...
- 170
1
vote
0
answers
19
views
Update field nestjs jsonb[] postgresql
I need update field in my i have something like that from postman
{
"id": "4",
"user": {
"id": "01JC32FBK3DYJMXZPDAVJA3NS0",
&...
0
votes
0
answers
36
views
PgAdmin can't find the binaries path [duplicate]
When trying to validate the path of the bin directory for PostgreSQL 12, PgAdmin cannot find the related files.
I'm using Ubuntu 22 OS.
I have already installed postgresql-client-12 using the ...
- 26
0
votes
2
answers
86
views
Django cloned project does not give tables after migrating
I cloned a project that I want to modify and experiment with, and I have all the necessary credentials. However, I'm encountering issues while following the steps outlined in the ReadMe.md file since ...
- 3
0
votes
1
answer
65
views
Right parameters on pgadmin to connect to a postgresql docker instance
I'm trying to connect pgAdmin to an instance of PostgreSQL inside a Docker container. But I am confused because I could not find any combination that works.
This is my Docker compose file:
services:
...
- 1