Questions tagged [postgresql]

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

Azure Database for PostgreSQL server connection is not working when using a macbook pro.With windows is ok [closed]

I can't connect to my posture database when I'm working with mac. Windows i confect with no problem. Already added to firewall rule, all ip address. Already turn off firewall on mac book, tried with ...
-1
votes
0answers
17 views

Aws rds postgres randomly dies from OOM

I have pretty standard aws rds postgres with unmodified config. It works fine except that once or maybe twice a month it is restarting. At some moment freeable memory goes down, swap goes up and in ...
-1
votes
0answers
15 views

AWS amplify app failing to build during connection to RDS

I am trying to deploy an app on amplify with a RDS database. the app is react frontend and NodeJS, Express, Sequalizer backend. The deployment is failing at build with one of the following errors (see ...
-1
votes
0answers
17 views

escalation.sh return `RTNETLINK answers: Cannot assign requested address` in EC2

I'm creating database cluster with Postgresql-11 and PgPool-II v4.2.2 on CentOS8 on EC2. Both Postgresql and PgPool-II are in the same server, and the cluster consists of 3 servers. I setup it as ...
1
vote
0answers
18 views

Impact on Recovery Time Using A Single Perpetual Base Backup and WAL Archives [migrated]

What would be the impact on recovery time when restoring a Postgres database from a backup where one base backup was taken at the start of the backup strategy and then only applying WAL archives from ...
2
votes
0answers
23 views

Disk is full after a PostgreSQL operation. Now what?

I added a column to a huge table in PostgreSQL. Since the table occupied more than 50% of the free disk space and the operation was running in a transaction, all of the disk space got consumed by the ...
0
votes
1answer
54 views

Amazon Linux 2 - EC2 PostgreSQL

I've the following: Amazon Linux 2 Postgres 12 installed a user created I'm using ssh to connect to my instance. The issue is that it doesn't let me to connect to my postgres database. I've created ...
0
votes
0answers
9 views

Monitor postgres resources “per database” within a single server (Running within RDS)

Scenario: One database server (hosted in RDS) is running multipe databases within it. Within server my-db-server: customer rpt analyze-db Goal: Split the rpt database out of my-db-server and move ...
0
votes
0answers
35 views

Cannot connect to a Postgres SQL instance from inside a pod within a GKE

I am new to Terraform and Google Cloud. I am trying to create a K8 cluster where pods inside the cluster could communicate with a Postgres server I have within the same VPC. However, when I try to ...
1
vote
0answers
34 views

PostgreSQL cannot work when opens SSL on Windows 10

I am not sure this topic will fit here but I don't know ask it where. I am trying to open the SSL of PostgreSQL 10.16 on Windows10. I read a lot of documents about creating an SSL certificate to ...
0
votes
0answers
77 views

RHEL 8. linux OOM killer invoked to kill postgres process

Database is going to recovery mode whenever the OOM killer is invoked on the postgres process. /var/log/messages output with respect to the issue oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),...
0
votes
0answers
96 views

Docker Service Postgres migrate 9.6-alpine data to 13.2-alpine

I upgraded a while back from docker service postgres 9.5 to 9.6-alpine but cannot seem to get 9.6-alpine upgraded to 13.2-alpine. Steps taken so far without success. #!/bin/bash # Upgrade test script ...
1
vote
1answer
81 views

Postgres foreign data wrapper query with now()

I am trying to query a remote database using postgres_fdw and am having really bad performance degradation when I introduce now() into my query. EXPLAIN ANALYZE VERBOSE SELECT * FROM remote_schema....
0
votes
0answers
24 views

Is this a normal number of database connections?

Check out this graph of my database connections. I am running a Postgres database on Lightsail, and I am connecting to it from a single Ubuntu instance running a single instance of Express and ...
0
votes
0answers
6 views

How do I connect RDS PostgresSQL replicas sharing a VPC/subnet via fdw without public IPs?

How should I connect RDS PostgresSQL replicas sharing a VPC/subnet via foreign data wrappers (FDW) without going on the public internet? When the source replica DB resolves the other replica's ...
0
votes
0answers
26 views

Barman backup restart after db server recovery

I'm struggling to work out how to restart barman after recovering the attached database server with a VM snapshot and data reload. When I run barman check db I get Server db: PostgreSQL: OK ...
0
votes
1answer
56 views

pg_dump complains PostgreSQL version 11 is not installed after installing postgres-client-13

We just upgraded our PostgreSQL servers to v13. We heavily use pg_dump on Ubuntu 18 systems to transfer data between databases. After upgrading the servers, pg_dump would complain about a version ...
0
votes
0answers
17 views

Best practices for how store all PostgreSQL databases on another disk/file location?

I have a server with Ubuntu Linux (18.04, 20.04, or current LTS) installed on it's regular SATA hard disk. The machine has a NVMe disk (e.g. mounted under /nvme). I want to run a PostgreSQL server (...
0
votes
1answer
64 views

Do I need 1 RDS Cluster for each DB or a single RDS Cluster for all my DBs?

Let's suppose I have 5 databases I'm going to use in my application. The application will be used by +100k users. I'm planning to use RDS Cluster with Aurora PostgreSQL. What would be best? Create 1 ...
0
votes
0answers
34 views

nfs issue when mounting kube volumes

Dears, I am using using nfs to make data persist on postgresql deployement The deployment file looks like this apiVersion: apps/v1 kind: Deployment metadata: name: postgres-deployment spec: ...
2
votes
1answer
65 views

Postgresql performance seems capped, cannot work out why

I'm setting up a new PG13 cluster, on ubuntu 20.04, virtual machine. The performance I'm seeing, via pgbench, is neither good nor bad. What I'm trying to work out is why it is what it is, and not ...
0
votes
1answer
34 views

Strapi + Postgres: Cannot SELECT from table - syntax error

I am using strapi and postgres. I created two collections in strapi called "solutions" and "references". When I run \dt I get the following output: ...more tables public | ...
0
votes
1answer
100 views

RDS Postgres could not be upgraded because one or more databases do not allow connections

I'm using AWS RDS to run a Postgres server, and I'm trying to do a major upgrade from 9.6.11 to 10.15. I'm using aws-cli to request the upgrade, like this: aws rds modify-db-instance --db-instance-...
0
votes
0answers
25 views

When is it necessary to use PGCrypto when developing a Django App with Postgres and publishing to Heroku?

Is it necessary to use PGCrypto to encrypt fields in our Django app? I ask because on the site it says that the data is encrypted at rest in an S3 bucket? Would we be covered then, in terms of data ...
0
votes
0answers
44 views

Amazon RDS PostgreSQL: Sudden increase in Read IOPS

We are using Amazon RDS to host our PostgreSQL databases. Our production instance (db.t3.xlarge, Single-AZ) was running smoothly until suddenly Read IOPS, Read Latency, Read Throughput and Disk Queue ...
0
votes
0answers
17 views

DETAIL: username “staging” or password does not exist in backend

I've had a Postgresql 11 + Pgpool-II-11 4.0.5 cluster working for over a year now. For a while we've been doing dropdb staging; createdb -O staging staging to reset the staging DB. We just implemented ...
0
votes
0answers
11 views

Azure Database for PostgreSQL (Citus) workers don't take traffic

I've just implemented an Azure Database for PostgreSQL (Citus) with one coordinator and 2 workers. I've imported my tables from a on premise postgresql dump I've launched a stress test on it, but it ...
0
votes
1answer
49 views

Could I create a Postgres user without unix User?

I'm newbie in Postgres and I having trouble creating users. I have created a Unix user and a Postgres user: sudo adduser aubudb sudo -u postgres createuser --interactive # Same name sudo -u postgres ...
0
votes
0answers
24 views

Reducing PostgreSQL memory consumption

PostgreSQL chews up 4 GB on 500 concurrent connections? I need to get it below 2 GB, or i have to get a more expensive server :( Tried: temp_buffers = 800kB work_mem = 1MB max_stack_depth = 1MB
1
vote
1answer
134 views

Azure Backup Vault: UserErrorBackupUserAuthFailed on PostgreSQL database

I created a web application on Azure consisting of a Virtual Machine and a PostgreSQL 10 database. I want to configure the Azure "Backup vault" service to periodically perform a database ...
0
votes
1answer
15 views

How to connect to PostgreSql database in docker (linux) container from windows desktop via vbscript

I face the following error in trying to connect to PostgreSql database in (linux) docker container from windows desktop via vbscript: Microsoft OLE DB Provider for ODBC Drivers (30, 11) : FATAL: ...
0
votes
1answer
23 views

Connecting to postgres RDS instance with restricted network access?

I have an RDS instance that is unreachable from the public internet. After performing a restore from a backup through the console, I would like to be able to connect to the database and get a psql ...
0
votes
0answers
10 views

Postgresql 12.2 - Is there automatic way to syncronize a replica (hot-standby) when restoring a master from base backup?

I am testing now a system of two or more postgresql servers, one of them running as a master and the others configured as hot-standby. OS: debian10 Linux, manually-compiled postgresql server 12.2 The ...
1
vote
1answer
412 views

“timeout expired” when trying to connect to RDS PostgreSQL server with pgAdmin

I am trying to connect to a Postgres RDS instance with pgAdmin, and I get the vague error 'timeout expired' every single time. This situation is especially strange, because my colleagues who are all ...
0
votes
1answer
47 views

Security issue with pg_hba.conf

I have a PHP script on my server that needs access to a database user to work properly . The person who programmed that PHP script has told to add the following to pg_hba.conf : host all all 127.0.0.1/...
0
votes
0answers
15 views

Postgres backup restoration read-only database

I'm using Barman to manage my postgres database backup. Now I would like to restore it. But when I restart postgres server after I did the restoration, I'm facing this error: Add rule to pg_hba: 0.0.0....
0
votes
1answer
62 views

Postgresql update from 9.6 on 11 on debian10

I want to migrate from Potgresql 9.6 to 11 on debian10. But I get this error while wanting to install Postgresql 11: apt-get install postgresql-11 Reading package lists... Done Building dependency ...
1
vote
0answers
14 views

Postgres remote connection timeout works on one machine but not on another

im trying to connect remotely to a postgres database, after opening the connection for my public IP address on the server hosting the database, I was able to connect successfully to the database from ...
1
vote
0answers
34 views

What could cause kswapd to reclaim tens of GBs of file cache on a postgres machine?

Usually the size of the file cache on our managed postgres machine running in GCP is between 110GB and 120GB. Sometimes it drops by ~35GB then oscillates by 10GB for an hour or two before slowly ...
0
votes
0answers
29 views

Monitoring Postgresql DB for replication lag

I have 3 secondary DB servers and I am monitoring replication lag using the below command and executing it every 1 min from the master DB node. ssh $PGHOST1 "sudo -u postgres psql template1 -c '...
0
votes
0answers
13 views

Account locked after postgresql 10.15 Installation in RHEL 7.5

I have installed the postgresql 10.15 in RHEL 7.5 and have also created the account with postgres as user name and password. The installation is completed but I am unable to access the database as the ...
0
votes
0answers
31 views

Equivalent of Firebase with PostGreSQL?

Is there a equivalent/similar product of Google's Firebase but using PostGreSQL instead of no-SQL of Firebase ? Firebase is a really great product where I don't have to think about : distributing ...
0
votes
0answers
165 views

High cpu consuming process on postgres in a container

I have a flask app and a PostgreSQL DB in a docker container on my ubuntu server. I found a high CPU consuming process, which increases CPU usage to 100%! I tried finding the process origin by ...
0
votes
0answers
28 views

Postgresql version mismatch between pgAdmin and console

I had running PostgreSQL version 10 on IOS and then I installed version 13.1. Now, when I run pgAdmin, I can still see the databases I created for version 10, and pgAdmin reports the server as version ...
0
votes
0answers
62 views

Two postgres servers (different versions) running on same mac, how can I add them both to servers list on pgAdmmin?

I had running postgres version 10 on my Mac and, then, I installed and started version 13. Now I have two versions running in my computer (I suppose, because pgAdmin still shows version 10 server ...
0
votes
1answer
39 views

Cannot connect to port 5432 locally even though it is allowed by UFW

I'm trying to setup my server so that port 5432 (Postgres) is accessible only from localhost. So I've denied everything, and added back port 5432, however I cannot connect to it. Here is my UFW config:...
0
votes
0answers
69 views

Installing a version of Postgres (on an EC2 instance) that is not listed in Yum packages

I'm trying to install Postgres on an EC2 instance, but yum list only includes version 9.2.24-1.amzn2.0.1. My assumptive guess as to a possible next step is some kind of manual installation? https://...
0
votes
0answers
46 views

Cache configuration for PostgreSQL/TimescaleDB VM on ZFS with proxmox

I have a proxmox cluster of a single node and I want to start a new VM with a PostgreSQL and TimescaleDB and after a lot of reading about how to tune ZFS volumes for this purpose I still have some ...
0
votes
1answer
125 views

Mediawiki cannot acces database after Debian upgrade

I upgraded a Debian 9 "Stretch" server to Debian 10 "Buster", which also upgrades Mediawiki to version 1.31. Trying to run update.php, it fails with "Cannot access the ...
1
vote
0answers
50 views

Production server much slower then local test server when sending large request

I am running a django app and I am trying to send an API POST-request which is pretty big to my production server. Now the problem is that what takes 4 seconds locally takes 1 minute in production. ...

1
2 3 4 5
37