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.
1,969
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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.
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'...
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 ...
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 "...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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. ...
-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 ...
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 ...
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 ...
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 ...
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/...
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:
...
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?
...
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 ...
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
-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
...
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 ...