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
1 vote
1 answer
4k views

How to change hot_standby_feedback parameter for an existing database replica in RDS

I have a primary database instance and its read replica, both running on Amazon RDS for PostgreSQL. Recently the replica started to get a lot of canceling statement due to conflict with recovery ...
cansadadeserfeliz's user avatar
0 votes
1 answer
1k views

Postgres authentication type "local" vs "host 127.0.0.1"

I have a Postgres v10 Server to which only local connections will be established. In the documentation I find two methods to configure such an authentication process in pg_hba.conf: local and host ...
TheCooocy's user avatar
  • 141
0 votes
0 answers
1k views

Configuring postgresql12-odbc to use the correct protocol version

I have a Centos 7 box with unixODBC 2.3.1 and postgresql-odbc 12.02 installed, which is connecting to a PostgreSQL server also running v12. Although I believe I have configured ODBC to use the v12.0 ...
davecardwell's user avatar
1 vote
1 answer
2k views

Google cloud VM add pgAdmin geting error Unable to connect to server: timeout expired

I am connecting my pgAdmin with the VM of google cloud. first I create VM instances after that the public IP address of VM instances I use pgAdmin hostname and when I try to save than getting an error ...
Sarthak  tiwari's user avatar
0 votes
0 answers
1k views

FreeRadius 3 + sqlippool

I have a basic configured FreeRadius in conjunction with Postgresql and Mikrotik. The SQL module is configured correctly and PPPoE authorization through the database works. I need to connect and ...
SryForStupidQuestion's user avatar
1 vote
1 answer
2k views

How can I interact with a new Postgres installation if I can't sudo -u postgres?

I have installed Postgres on an Ubuntu 16.04 server, but I'm working in a corporate environment and am not able to sudo -u postgres (I have sudo rights, but can't impersonate another user). Is there ...
Peter's user avatar
  • 111
0 votes
1 answer
157 views

Service account with fine grained permissions for managing PostgreSQL databases

I need to create a service account for managing (create, update, delete) PostgreSQl database instances in Cloud SQL. I was thinking to use "roles/cloudsql.editor" role, but it does not have ...
Jovan Kostovski's user avatar
1 vote
1 answer
384 views

Flush DNS cache in Google App Engine

We recently had a Google App Engine application fail to properly fail over during scheduled maintenance of our database server (hosted in Aiven). During scheduled maintenance, the DB server will fail ...
ChrisJ's user avatar
  • 295
0 votes
1 answer
475 views

How to call pg_dump from app engine

How do I call pg_dump from my .NET app engine instance? I use Google Cloud SQL. I need pg_dump to specify specific flags when exporting my database.
Jasper's user avatar
  • 141
2 votes
2 answers
30k views

GRANT USAGE ON SCHEMA doesn't do anything

For whatever reason, our database is not respecting GRANT commands. Below is an example with a newly created user. pddbtest=> create user test_user login; CREATE ROLE then verify user does not ...
Danny C's user avatar
  • 123
0 votes
1 answer
1k views

connect Crystal Reports with JDBC to PostgreSQL

I want to connect Crystal Reports (2016, Support Pack 8, version 14.2.8.3426) to a PostgreSQL 12 database. Using JDBC. The database is on my local computer, on port 5433. My database name: ogc ...
Maas 's user avatar
2 votes
2 answers
7k views

Postgres mount volume error in k8s

I'm trying to deploy Postgres with a PersistentVolumeClaim in GKE. As per the description here (look at PGDATA), it is recommended to create a subdirectory if mounting an external volume. So, this is ...
Milkncookiez's user avatar
0 votes
1 answer
175 views

When creating a managed database should I have one instance per application?

Let's say I have 10 different applications that all have a postgresql database dependency and these applications must be deployed on Azure using Azure managed postgresql instances. Would it be best ...
doct03's user avatar
  • 111
1 vote
0 answers
106 views

AWS data storage: how much to store with Cognito

I am new here. This is rather a choice-based question rather than purely technical one. Many mobile apps authenticate with Cognito, and I am going to use the same for ease of use + free tier ...
Nirav Bhatt's user avatar
0 votes
1 answer
4k views

How to start PostgreSQL on boot on Debian Buster

I have upgraded PostgreSQL from version 9.6 to 12 in Debian 10 Buster. I'm currently running the 12 cluster, and I'm keeping the 9.6 cluster installed, but not running (down). I can start the 12 main ...
thibautg's user avatar
0 votes
1 answer
793 views

How to remove one of owner from db in postgres?

How can I remove this user from having owner permissions , so i can drop the user? mydb=> \ddp Default access privileges Owner | Schema | Type | Access ...
Swat's user avatar
  • 475
1 vote
0 answers
199 views

Postgres: script updates to pg_hba.conf file

I am in the process of creating deployment scripts for a web application. The script should run on a fresh node (e.g. ec2 from Amazon) and install and configure my dependencies. When it comes to ...
user422005's user avatar
2 votes
1 answer
622 views

Postgres logs out ldap connection settings including password

I'm trying to configure PostgreSQL instance to use LDAP server for authentication. It's working fine. The only thing I don't like are the logs. In case if login does not succeed Postgres logs out all ...
abinet's user avatar
  • 131
0 votes
1 answer
627 views

Configure PostgreSQL for subdomain access (installing Comment.io)

I need to provide a comment section for a website I am currently working on. I found commento.io, a commenting platform that can be self-hosted. They provide a tutorial for self-hosting: https://docs....
bruno's user avatar
  • 101
0 votes
0 answers
385 views

Using PostgreSQL on Windows for production environment

We might need to deploy our new application that uses PostrgreSQL DB to the infrastructure where only Windows VMs are available. I have a question if it is fine to run the RDBMS server there, or we ...
MyUserName's user avatar
1 vote
2 answers
5k views

Are connections to databases http based or tcp based

are connections to Database http based or tcp based. Are jdbc of spring-boot application to postgressql http method connections based or tcp based connections.
charlie's user avatar
  • 29
0 votes
1 answer
480 views

AWS RDS Postgres not accessible via HTTP(S)

I'm trying to deploy an app that queries my postgres db, hosted on aws rds, and needs to be publicly available via HTTP. To achieve that, I changed the connection type in the inbound rules for the db'...
Rony Armon's user avatar
1 vote
0 answers
1k views

PostgreSQL 9.5 not listening; cluster is down; "too many levels of symbolic links"

I'm working on a remote VPS running Ubuntu 16.04 LTS. After a software update (apt upgrade) in which postgresql-common was updated, my PostgreSQL 9.5 server stopped listening on any port. # All ...
Arthur's user avatar
  • 111
0 votes
1 answer
653 views

I try to get mail server to work on PostgreSQL

I try to get mail server to work on PostgreSQL but I get a error below: Apr 16 20:48:57 alm authdaemond: PGSQL_CONNECTION could not be established Apr 16 20:48:57 alm authdaemond: FATAL: database "...
Matti Kiviharju's user avatar
2 votes
1 answer
4k views

PostgreSQL Service status Active(Exited) but I am able to connect

I have installed PostgreSQL (9.5) on a new Ubuntu (16.04) VM on GCD. THe status of service is active(exited). The output of sudo systemctl status postgresql is: ● postgresql.service - PostgreSQL ...
DVD's user avatar
  • 21
1 vote
1 answer
12k views

Invalid command 'php_flag', perhaps misspelled or defined by a module not included in the server configuration

I'm trying to setup PhpPgAdmin. But the service won't start. I get the following output when sudo systemctl status httpd.service: ● httpd.service - Apache Web Server Loaded: loaded (/usr/lib/...
andrdc's user avatar
  • 21
1 vote
1 answer
3k views

flask, gunicorn (gevent), sqlalchemy (postgresql): too many connections

I created Flask WSGI-application which uses gunicorn as WSGI-server, for DB it uses PostgreSQL through Flask SQLAlchemy extension. That's all hosted on Heroku. gunicorn configuration number of ...
Amaimersion's user avatar
0 votes
0 answers
4k views

rsync postgres backup to another directory

I have CentOS 7 (3.10.0-1062.18.1.el7.x86_64) with SELinux enabled. PostgreSQL 12 installed (not sure if it is related). I try to backup database and move backup files to another disk. How I create ...
adontz's user avatar
  • 347
2 votes
1 answer
391 views

Add 3rd server with pglogical replication to a 2 server cluster with stream sync replication and failsafe with patroni

I have 3 servers with Ubuntu 19.10, PostgreSQL 12.2 and Patroni 1.6.4 and I would like to have the following setup: I want to have two servers with synchronised replication and I want to add a 3rd ...
ufk's user avatar
  • 333
2 votes
1 answer
389 views

SQLite works, but PostgreSQL migrated database causes ERROR - Django 3.0

Situation I have built Django 3.0 project with a couple of applications. I have created the accounts app based on following course and it's github Than I have created an application fro ...
sogu's user avatar
  • 223
2 votes
2 answers
46k views

AWS RDS to PgAdmin Error saving properties Unable to connect to server: timeout expired

Short description: AWS RDS connecting server to pgAdmin 4, PostgreSQL 11 Done: I have done similar to this guy or to this AWS guide, but at the end when I click Save, it does not accept it for me. ...
sogu's user avatar
  • 223
-1 votes
1 answer
248 views

ALB writing to 2 postgre sql instances

I have nginx and postgre sql running on the same ec2 instance. It serves a rails app that reads and writes data on that db. I would like to have 2 instances behind an ALB service to distribute load ...
HelloWorld's user avatar
0 votes
0 answers
69 views

First install of PostgreSQL on Windows Server - How to enable / test remote access?

I'm installing PostgreSQL on a Windows 2008r2 Server, with the intention to use with a Delphi 7 application over ODBC. I followed the PostgreSQL 12.2 Documentation Not needing to install from source ...
tim11g's user avatar
  • 425
0 votes
2 answers
595 views

Is there a way to set up postgres to authenticate users based on the user they are logged in as?

I want to run queries on my postgres databases from scripts and whatnot, without having to do what I do currently: sudo su - postgres psql -U USER ...etc This is cumbersome because I have to type 2 ...
Carson McManus's user avatar
0 votes
1 answer
764 views

Is it possible to restore postgres database with a non-DBO user?

I'm struggling with finding an appropriate backup / restore method for my postgres databases. My requirements are these: DB owner is a non-superuser account. it only has "can login" and "inherit ...
velis's user avatar
  • 233
3 votes
1 answer
3k views

PosgreSQL upgrade from 9.6 to 11.6 is failing with source cluster not shutdown properly

While trying to upgrade from 9.6 to 11.6 it is failing with this below error: su - postgres -c '/usr/pgsql-11/bin/pg_upgrade -d /opt/collabnet/teamforge/var/pgsql/9.6/data -D /opt/collabnet/teamforge/...
Ranjith's user avatar
  • 31
1 vote
1 answer
242 views

Cannot stop Postgresql in FreeBsd Jail

I installed postgresql in a jail, it starts automatically after adding postgresql_enable="YES" to /etc/rc.conf), but now I can't stop it. I tried /usr/local/etc/rc.d/postgresql stop, but I've got: ...
leonardorame's user avatar
0 votes
1 answer
350 views

Can system load on a postgresql replica impact the performance of the source database?

I've created a postgresql replica database to mirror the content of my production database and want to be sure that queries against the replica can never impact the production server. How safe am I? ...
Michael Gee's user avatar
1 vote
1 answer
365 views

Migrating OpenProject database from package install to docker container

I've seen a few people migrating OpenProject from a container to a package install, but not the other way around. OpenProjects instructions for migrating assume you are moving from container to ...
rev6's user avatar
  • 11
1 vote
0 answers
1k views

DBeaver/pgadmin connect db thru a jump server

I am using docker swarm to manage my stacks. And I dont want to expose my databases to the public (5432 port on the host machine should not be open), but I still want to use dbeaver or pgadmin. The ...
Greeneco's user avatar
  • 111
2 votes
2 answers
21k views

Postgresql 10 and Ubuntu - Unable to postgresql server UP

One day, My Postgresql server stopped working. Checked log. It was shutdown somehow. root@ip_address:/# tail /var/log/postgresql/postgresql-10-main.log 2020-02-19 06:47:49.215 CET [23497] LOG: ...
Jin Lim's user avatar
  • 123
0 votes
1 answer
223 views

Will the DB dump be consistent if a table is being inserted each second?

I want to create a consistent backup (dump) of a PostgreSQL database using sudo -u postgres pg_dump database_name > db_backup.sql. There some multiple tables that are being inserted a row each ...
tukusejssirs's user avatar
0 votes
1 answer
185 views

How to re-create pg_stats_database in Postgres

We recently upgraded Postgres from v10 to v12. The pg_stats_database listed a "datname" column with a null value. Foolishly I deleted the view hoping to re-create it. When trying to recreate the ...
Gavin Hill's user avatar
0 votes
1 answer
1k views

PostgreSQL - Tuning work_mem and max_connections

I am using PGTune to help tune my web application using PostgreSQL 9.5 Some background - The web app is a real estate search site, with up to 200 active users during the day performing fairly complex ...
Valachio's user avatar
  • 103
2 votes
1 answer
424 views

How to track origin of a ghost process in ubuntu that is causing postgres to take 100% of CPU usage in Amazon EC2 container?

I am running PostgreSQL 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1) on an AWS EC2 micro instance. Previously, I had allowed remote connections to postgres db from anywhere. After some days, I am seeing an ...
Subhankar Mukherjee's user avatar
0 votes
1 answer
2k views

Setting password authentication for default Postgres account

I'm trying to resolve an issue that was found during a Nessus scan involving the default postgres account not having authentication. https://www.tenable.com/plugins/nessus/10483 I've been trying to ...
Darin Beaudreau's user avatar
0 votes
1 answer
87 views

How to migrate postgresql data?

I have a on-premise postgresql database and have to migrate its data to aws aurora postgresql. However the back up is taken using pg_start_backup. Can I use pg_restore to restore it? Has anyone ...
Swat's user avatar
  • 475
0 votes
1 answer
58 views

PostgreSQL in Google Kubernetes Engine reinitialise database

I'm trying to create a PostgreSQL database in Google Kubernetes Engine, backed on a PVC to maintain the stored databases. Currently I have this definition: apiVersion: apps/v1 kind: StatefulSet ...
James Gordon's user avatar
-1 votes
1 answer
2k views

How to create database on restore

I want pg_restore to create database before restore using Postgres 12 on Debian 10 I tried PG_COLOR=auto PGHOST=localhost PGPASSWORD=mypass PGUSER=postgres export PGHOST PGPASSWORD PG_COLOR PGUSER ...
Andrus's user avatar
  • 169
24 votes
2 answers
35k views

PgAdmin: could not send data to server: Socket is not connected could not send SSL negotiation packet: Socket is not connected [closed]

While opening query tool via pgadmin, i am getting this error on popup. could not send data to server: Socket is not connected could not send SSL negotiation packet: Socket is not connected Does ...
Bhavesh Tilvani's user avatar

1
4 5
6
7 8
40