Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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
1 answer
31 views

Docker: error could not translate host name to address: Name or service not known in psql

We have the following Dockerfile: FROM debian:stable-slim ARG DEBIAN_FRONTEND=noninteractive RUN apt-get update && apt-get full-upgrade -y && apt-get install -y --no-install-...
user avatar
  • 111
0 votes
1 answer
29 views

Not able to backup of postgres DB from DBeaver

Hope you are doing great. We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine. Whenever we try to take backup of Database it is giving error as "Native ...
user avatar
2 votes
1 answer
24 views

ZFS disk with Postgresql fragmenting quickly with write-heavy application

I am running a write-heavy application where I am storing my Postgresql on ZFS. Generally, it works well, but I am finding that my ZFS pool is fragmenting heavily. I even created a new ZFS pool and ...
user avatar
  • 131
0 votes
1 answer
18 views

AWS Postgres database IP in security group, how to enter info to survive IP address changes?

I have an existing prod Postgres database and I would like to replicate a table to a new Postgres database. In order to get the two to be able to talk to each other, I had to edit an AWS security ...
user avatar
  • 121
0 votes
1 answer
238 views

Getting could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432

I have Postgres 13 and pgAdmin installed on my Windows machine. It worked for like ~six month, until I hat do restart my machine. After restarting the computer (which I had not done because there was ...
user avatar
  • 101
0 votes
0 answers
10 views

What happens if choose disable OID on tables?

When migration db from postgres 9 to 13 i have problem, latest releases not support OID, so, what is happen if choose disable OID on table properties?
user avatar
0 votes
0 answers
27 views

How to switch standby to master on postgresql 13?

For High Availability on DB was build Active-Standby(replica) cluster on Postgresql-13. Inserting data correctly transfer to 'replica' server, it is ok. Now, I want check case, how i can make change ...
user avatar
1 vote
0 answers
42 views

RDS does not support creating a DB instance with the following combination

AWS recently notified me I need to upgrade an RDS instance that's using an instance type that's being removed. So I logged in, and bumped up my instance size from m1.small to m5.large (the smallest ...
user avatar
  • 3,432
0 votes
1 answer
41 views

How to disable postgresql port for out-server connection?

I installed on my dedicated server ubuntu 20.04, docker, and container with postgressql. I have problem beacouse I want that ubuntu blocked all connection with postgressql, out-server from domain, ip ...
user avatar
  • 3
0 votes
0 answers
59 views

How setup wireguard + nixos to access servers (PostgreSQL, nginx) from workstation?

I wanna give access to operators using wireguard to services like PostgreSQL, nginx, ssh, etc without giving the public IP of the host. I use nixos, but a plain setup with wireguard + iptables can ...
user avatar
  • 105
0 votes
0 answers
34 views

Are MySQL/MariaDB and Postgresql compatible?

I want to install multiple applications on my web server. For most of them, using PostgreSQL is possible or the only option. But in one of them's installation guide, only MariaDB is mentioned. If I ...
user avatar
  • 1
0 votes
1 answer
39 views

I can't receive emails with Foxmail, but the email has been received locally

Maillog doesn't show any errors. I see a new email in my /home/mail/domain/www3/new. I just can't read the email by using the client or telnet 110/143. Dovecot info The log doesn't seem to show any ...
user avatar
1 vote
1 answer
82 views

Pgadmin4 cannot start in Kubernetes

I have set up Postgres in Kubernetes (k3s administered with Rancher) which seems to be working fine but in order to take a look at the databases I tried to add a pgadmin4 pod. I first tried adding the ...
user avatar
  • 111
0 votes
1 answer
36 views

pgcrypto and password hashing

I'm thinking about my choices regarding how to store passwords in Postgres. One such option is to use pgcrypto. Reading their docs, I see that their crypt and gen_salt functions do not use sha256 but ...
user avatar
0 votes
0 answers
5 views

Service in manual startup. What is starting it?

I have Postgresql installed on a windows PC. On Windows 10. Nothing depends from it: It is in manual startup. But often I find it started. How can I find what is starting it?
user avatar
  • 151
0 votes
1 answer
33 views

Bareos: Bscan doesn't recover database entries (Tapes from MySQL new server Postgres Database)

I had an ubuntu server 18.04 running with bareos and mysql database. Monthly I saved data on tapedrive and everything was working fine. Unfortunately I had a servercrash without a backup of the dump ...
user avatar
0 votes
0 answers
17 views

Express not fetching data from postgres database. No errors displayed

This is a difficult question for me to ask because I'm not truly sure what the issue is. I have an Express JS server for routing and Node Postgres (PG) for the pool. When I either go directly to ...
user avatar
0 votes
1 answer
85 views

Postgres SSL server certificate upgrade / renew with openssl

I have inherited a Company Postgres Server with SSL clients. Its around 100 users so far. Two Problems: My Ca Cert (root.crt) expires next year and it seems to be still TlsV1.0. So an upgrade(renew) ...
user avatar
0 votes
0 answers
28 views

How to connect azure postgres with bastion?

In this page also, it was shown to create a separate vm in the same vnet to connect to postgres setup in a private vnet option selected. Is there anyway to connect using azure bastion.please show the ...
user avatar
1 vote
0 answers
25 views

Which directories to provide for pg_upgrade?

I have docker container with postgres 12 and I want to upgrade it to 13. This image stores data and configs in /var/lib/postgresql/data dir: show data_directory; returns that directory postgresql....
user avatar
0 votes
0 answers
23 views

Packet loss in PGSQL query leads to very long recovery time

We have a seemingly complex network issue that I have been struggling with for a while and wondered if anyone had any thoughts We have a number of servers sitting in AWS London and another set of ...
user avatar
0 votes
0 answers
27 views

What is a real OTRS 6.0 community edition hardware requirements?

We have deployed OTRS 6.0 community edition on the VMware cloud. The configuration is as follows: 2 servers, an application server and a database server. Both on Ubuntu 20.4, Apache 2.4 Web server, ...
user avatar
0 votes
0 answers
76 views

How do I use the pgpass.conf file to allow promptless connection to a database

for testing purposes I have a postgres service/database running on my local computer. Right now I am using a batch file to change default userlogin, but I cannot use SET PGPASSWORD to pass along a ...
user avatar
1 vote
0 answers
20 views

Is it possible to open a file within a batch file as another user?

im trying to run psql.exe (postgreSQL) with an active code page set to 1252. I want to have a batch file that opens up a command prompt with that code page, then navigates to the psql directory to run ...
user avatar
0 votes
0 answers
69 views

OpenStack: Too many Database idle Connections

I use PostgreSQL as a DB backend for all OpenStack Services on 3 Controllers. When all 3 controllers are started with no load, the number of connections are up to 700. And all of this conns are in ...
user avatar
0 votes
0 answers
19 views

How can I make postgres startup on connection - and shutdown after a period of being out of use?

In the day time I do software development where I use Postgres via Django on Ubuntu. In the evening the computer is my personal laptop (still running Ubuntu). How can I make Postgres startup when it ...
user avatar
0 votes
0 answers
122 views

How to create azure postgres using terraform?

Created VNet and two subnets first and pass the values as variables to terraform. az group create -n TestingTFCLI -l CentralUS az network vnet create -g TestingTFCLI -n myVNET --address-prefixes 10.0....
user avatar
  • 339
0 votes
1 answer
75 views

Can't get postgresql 12 to start as service

Found this error: /var/run/postgresql/12-main.pg_stat_tmp/global.tmp": No such file or directory Manually creating I can start Postgresql, but has to be recreated every reboot. This is after a ...
user avatar
0 votes
1 answer
100 views

how to fix ProvisioningDisabled for postgres flexible server

I am trying to create a flexible server of postgres and when I tried, the quota exhausted for eastus2. So I tried centralindia and got below error. Error: waiting for creation of the Postgresql ...
user avatar
  • 339
1 vote
2 answers
64 views

How do i get PostgreSQL on Open BSD 7.0 to run

Trying to start postgresql on openbsd 7.0 but can't seem to get it to work. so far I tried this tutorial and looking around a bit on google. I'm new to OpenBSD. # rcctl -df start postgresql doing ...
user avatar
  • 11
0 votes
1 answer
185 views

How to set service_endpoints and delegation in subnet part of vnet in azure using terraform?

I have a working block of terraform vnet,subnet and NSG of it. provider "azurerm" { features {} } resource "azurerm_resource_group" "example" { name = "...
user avatar
  • 339
0 votes
1 answer
25 views

Disk read metrics not showing for postgres activity

I've long noticed that ESXI wasn't showing disk READ activity for my Ubuntu Postgres database server. I figured maybe it was just a weird bug with ESXI, as it would show disk WRITE activity. I decided ...
user avatar
  • 69
0 votes
1 answer
80 views

Allow access to remote VM with Postgres only from VPN access

I'm missing knowledge about VPNs. Given is a remote VM with Postgresql. The Server has a public IP. Is (and if how) is it possible to: Database Level: allow connections to postgres (pg_hba.conf) only ...
user avatar
  • 139
0 votes
4 answers
418 views

How to install a specific version of PostgreSQL in Red Hat 8?

I'd like to install a specific version of PostgreSQL in RHEL 8 with dnf. To achieve this I followed the PostgreSQL guide : https://www.postgresql.org/download/linux/redhat/ But actually I can only ...
user avatar
  • 142
1 vote
0 answers
50 views

How to keep postgres flexible server and aks on the same vnet?

I have created aks cluster with azure network type selected. Terraform files for reference My VNet used with aks. But this vnet is not available in the dropdown of azure postgres flexible server ...
user avatar
  • 339
0 votes
1 answer
217 views

How to access postgres in private vnet from another VM in azure?

I have created postgres flexible server with private vnet option. So, no direct access to posgres from internet. But, when I try to create a new windows 10 VM, I can't select the subnet of database ...
user avatar
  • 339
1 vote
1 answer
322 views

How to connect AKS with postgres in private vnet?

I have created postgres with private vnet option. So, no direct access to posgres from internet. But, I can't access it from "CloudShell" also. Also, while creating database,when I want to ...
user avatar
  • 339
0 votes
1 answer
45 views

AWS RDS PostgreSQL Upgrade from 9.6.22 to 10.17

I just finished upgrading my AWS RDS database engine from 9.6.22 to 10.17. I used these steps to make the upgrade using the AWS Console: Create snapshot of target database to upgrade Restore snapshot ...
user avatar
0 votes
1 answer
203 views

Google cloud Postgresql connection timeout

I just created a postgreSQL instance on GCP, I have allowed public IP connections, and added both 0.0.0.0 and 0.0.0.0/32 to the IP allow lists, I don't require SSL connection and even added a new user,...
user avatar
0 votes
1 answer
888 views

pg_dump is not the same version as psql

I updated postgres to version 14 by simply running sudo apt upgrade. psql --version psql (PostgreSQL) 14.1 (Ubuntu 14.1-2.pgdg20.04+1) But pg_dump did not upgrade with everything else: pg_dump --...
user avatar
0 votes
2 answers
833 views

Why can't I grant select privileges to all table in schema with PostgreSQL?

I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user ...
user avatar
  • 145
1 vote
0 answers
340 views

"self signed certificate in certificate chain", Server or Client?

I'm creating a SSL communication between a pg DB Server and a node client. After following some docs and implemented with openssl, node complaints "self signed certificate in certificate chain&...
user avatar
  • 111
0 votes
0 answers
30 views

My postgresql db dump is 500mb, even though I've nuked every single table

I was at some point storing files in my database (Spring JPA Lob, Byte[]), and then I moved them to the file system, however the size of the database never decreased after dropping thee old columns. I'...
user avatar
0 votes
0 answers
266 views

Questions about running postgres as Docker Container. 1. TimeZone, 2. global.stat

I'm been running postgres as a Docker Container for quite awhile. Initially, the TZ and PGTZ were not set, so I think it was defaulting to UTC. On my dev system I tried the following in docker-...
user avatar
  • 139
0 votes
1 answer
101 views

Howto build docker postgres image with pgcrypto sha3-512 support?

I need to create a postgresql 11 docker image that has support for sha3-512 hash function. By default, the official postgres docker images do not support this. I already have some systems that use the ...
user avatar
  • 657
1 vote
0 answers
377 views

PostgresSQL upgrade from 9.6 to 10 on Windows fails when using pg_upgrade (fe_sendauth: no password supplied)

Part of the work moving from Windows 2012 to 2019 involves upgrading the current install of Postgres from 9.6 to 10. I'm trying to use pg_upgrade and after some struggle with file permissions I have ...
user avatar
  • 213
0 votes
1 answer
119 views

Should replica DB be in 'recovery' - PostgreSQL

I have two databases that are using streaming replication and appear to be in this state postgres 16319 0.0 0.5 137949952 3077260 ? Ss Aug22 0:11 /usr/pgsql-12/bin/postmaster -D /var/lib/pgsql/...
user avatar
0 votes
0 answers
33 views

occasionally momentary loss of name resolution or connectivity between Azure app. instance and AWS DB

We have a PHP application running in an Azure app. instance and it communicates with a Postgres database hosted in AWS. Very occasionally it is unable to communicate with the database: [11-Nov-2021 ...
user avatar
1 vote
2 answers
131 views

Google Cloud - Hipaa Compliance - PgAudit vs IAM Audit Logs

Our infrastructure is hosted on Google Cloud and uses postgresql instances via Cloud SQL I need to configure logging for HIPAA compliance. I have read 2 articles from Google's documentation: https://...
user avatar
1 vote
1 answer
443 views

pg_hba.conf - psql local login without password

I have these settings in my pg_hba.conf for a PostgreSQL-12.6 installation # "local" is for Unix domain socket connections only local all all ...
user avatar
  • 217

1
2 3 4 5
38