Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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 (...

1
vote
1answer
15 views

`systemctl disable --now postgresql` doesn't stop the daemon

I'm running Debian Stretch and PostgreSQL 10 from apt.postgresql.org. When I do: postgresql disable --now postgresql the database server doesn't stop. It says: Synchronizing state of postgresql....
0
votes
0answers
6 views

How can I filter postgres log entries?

Our developers recently implemented postgresql's ON CONFLICT operator to provide upsert capabilities. I'm now seeing thousands of lines of duplicate key errors like so: 2018-12-14 15:02:09 UTC:10....
0
votes
0answers
32 views

gae std environment postgres python37 queries fail [on hold]

My app gives "500 Server Error" for all accesses. Logs show queries going to the postgres database, but then the connection gets dropped or times out. There is a slow query during app initialization (...
1
vote
1answer
36 views

Why do SSH keys work for users `root` & `freebsd` but not `postgres` (database owner)?

I have been using FreeBSD running an a virtual machine at DigitalOcean.com. I use Secure Shell (SSH) from my Mac to remote into a console session on the VM. I used ssh-keygen to create the pair of ...
0
votes
0answers
28 views

How to restore multiple databases on a single Google Cloud SQL for PostgreSQL instance to the same point in time?

I have 2 separate PostgreSQL databases in Google Cloud SQL for PostgreSQL. The databases should be separate due to security concerns, but they can reside in the same database instance. When restoring ...
0
votes
0answers
12 views

Where to find logs from Postgres 11.1 on FreeBSD 11.2?

Having built Postgres 11.1 on my FreeBSD 11.2 machine, where might I find the logs output from Postgres. Specifically, when attempting to start Postgres for the first time, I get an error message ...
0
votes
1answer
17 views

Access Azure PostgreSQL with S2S VPN

I'm setting up an Azure PostgreSQL database, for security purposes i want the access to to the PostgreSQL database to be restrict to my on-premises LAN. So I setup an S2S VPN from azure to my pfsense ...
0
votes
1answer
35 views

Postgres crash loop caused by a tuple concurrently updated error

Sometimes when starting Postgres POD in OpenShift following error code is being shown pg_ctl: another server might be running; trying to start server anyway waiting for server to start....LOG: ...
2
votes
2answers
89 views

Is swap file required for a Postgres database running on AWS EC2 instance with 122 GB memory?

What is the downside for running a Postgres database without a swap file? This database resides on an AWS EC2 machine with 122 GB memory.
0
votes
0answers
22 views

postgres large query fails on local machine only with sslv3 error

Server: Heroku postgres hobby On my old laptop that I have right now and is currently working I can do pg_dump command: "C:\Program Files\PostgreSQL\10\bin\pg_dump.exe" -n public --verbose --host=...
0
votes
0answers
23 views

CPU/Node HT Link sync error SuperMicro H8QG6

We have couple of SuperMicro H8QG6 (with 512 GB RAM and AMD Opteron (48 cors)Processor) servers which they are all running Centos 7.5.1804 ( kernel 3.10.0-862.14.4.el7.x86_64) and we have only ...
0
votes
0answers
19 views

MySQL and Postgres replication to the same slave

I need to set up multi-source replication from several different servers to one slave so that I can mine data from the slave without increasing load on the masters. This is my first time setting up ...
0
votes
0answers
23 views

How to remove unused temp files from Google Cloud SQL managed Postgres?

We've moved to Google Cloud SQL, created couple of databases and imported lots of data. Alongside it was a pretty large amount of queries which were interrupted here and there which have left some ...
-1
votes
0answers
32 views

Create Postgres 11 Cluster on Production Server without downtime

I have a production server running Postgres 11. The database is > 10 GB. We are using pgBouncer. Is it possible to create a slave (and a cluster of course) without downtime? Right now we have single ...
2
votes
0answers
16 views

Run initdb with user having write rights, but not owner of pgdata directory

I'm running initdb in docker image (official Postgres image) in Openshift environment, with sets the strict security policy, that user that will run the container will have random UID, but GID will be ...
0
votes
0answers
18 views

Postgres data_directory change permissioning

I have postgresql-9.5 on ubuntu. I have an external USB drive plugged in I would like to use for storing its data. After changing data_directory in postgresql.conf to point to a directory on the ...
0
votes
0answers
43 views

Haproxy postgresql with patroni

I try to connect to my postgresql cluster using patroni and haproxy, in haproxy stats always i have two servers "DOWN" and when i connect from my pgadmin i have this message: server closed the ...
0
votes
2answers
63 views

Primary key insertions start at zero when failing over logical replication in PostgreSQL10

I have two PostgreSQL servers running, one publishing all tables and the other subscribing to all via logical replication. I'm currently testing a failover solution, and it seems if I remove the ...
0
votes
1answer
39 views

postgres log workflow : filter the log events with specific working hours

To analyze postgres logs, our workflow is: postgres logs via syslog rsyslog writes to one text file at midnight we stop postgres pgbadger reads and parses the daily logfile (about 2 Gbyte) We want ...
0
votes
0answers
27 views

Postfix header_checks in psql

In Postfix is it at all possible to perform header checks based on a PSQL lookup? I haven't found anything explicitly saying you can...but also haven't found anything supporting it. Ideally, I want ...
0
votes
1answer
39 views

Postgres randomly spiked to 100% CPU, and went back to normal

I'm using postgreSQL 9.5 on Ubuntu 16.04 About an hour ago, I realized my site was super slow and unusable. I checked my DigitalOcean console, and realized CPU usage jumped to 100%. When I ran top ...
0
votes
1answer
46 views

Consul, vault and postgres containers don't communicate

I'm trying to set up Consul with Vault for secrets management for Postgres with Docker. Here is my configuration Dokcerfile: FROM python:3.6-slim ENV VAULT_VERSION 0.11.1 ENV CONSUL_VERSION 1.2.3 ...
1
vote
1answer
18 views

PostgreSQL - Clear space on Linux machine

How can I delete all stored records of my PostgreSQL data in CentOS 7 machine? Previously I inserted 10 million rows of data with 12 columns, and I ran into storage issues, so I dropped the tables ...
0
votes
1answer
391 views

PostgreSQL - Could not extend file No space left on device. HINT: Check free disk space

I've been inserting data into PostgreSQL DB, and got the error message: psycopg2.OperationalError: could not extend file "base/16384/61892": No space left on device HINT: Check free disk space I am ...
0
votes
1answer
49 views

Postgres behave abnormally

I have production application running on PostgreSQL database on a on premise Ubuntu System. Recently I have been facing one strange issue, that Postgres service is getting killed itself and then it is ...
1
vote
0answers
53 views

Sync Local Postgres Database with Remote Database

My company is looking at creating a consolidated server that will serve as a backup for many remote servers who have separate data from one another, and provide an application where the aggregate data ...
2
votes
2answers
65 views

How can I access Production DB securely without static ip

I am running a small scale app on AWS EC2 and it has PostgreSQL installed on it. I want to access this production DB remotely but also want to keep it secure and I'm not sure if what I am doing is ...
1
vote
0answers
28 views

Is it possible to relink an Inode in EXT4 with it's original filename

Ok, so foolish idiot here, trashes his postgresql data directory, right at the very moment when his backup routine is currently in the "delete old files" and "create new files" phase. As a result, Iv'...
0
votes
0answers
77 views

AWS Elastic Beanstalk - can't db:reset / db:seed Rails app after SSH

I'm stuck deploying my (second) Rails 5.2 app to AWS using Elastic Beanstalk. The code is deployed fine, but the PostgreSQL 9.4.18 database is causing problems. EB correctly created the RDS instance. ...
-1
votes
2answers
24 views

Replication of Postgresql vice cersa

I have two Linux servers having Postgresql-10 on each of them. On both of them, there is a database, say dbexample, having same schema, table, everything. Both of them are capturing data from an ...
0
votes
1answer
15 views

Postgres on Ubuntu Server 16.04 - automatically backups

I have Ubuntu Server 16.04 and PostgreSql database. How to organize automatically backups? Is this better idea to move my database to AWS RDS instead having database on my server?
0
votes
1answer
30 views

pdns (powerdns) not returning records anymore after switching db backends

I switched db backends from gmysql to gpgsql and copied the records from the mysql database to the postgresql db. dig +short www.example.com @my_dns_server_ip used to return the desired result but it ...
0
votes
0answers
81 views

Is there RDS support for remote storage for Prometheus?

I don't see PostgreSQL supported here: https://github.com/prometheus/prometheus/tree/master/documentation/examples/remote_storage/remote_storage_adapter and I don't see RDS supported here: https://...
0
votes
1answer
397 views

Postgres Docker- How to enable postgres docker to allow remote connections?

I hope to connect my Postgres docker service from remote client. This is how I create the container: sudo docker run --name pg -p 5432:5432 -v pg_data:/var/lib/postgres/data -e POSTGRES_DB=mydb -e ...
1
vote
2answers
82 views

Postgresql installation, avoid creating “postgres” user

I have a constraint, that I can use only one user on a SUSE Linux Enterprise Server 11. Now, I need to install PostgreSQL. Is it possible to somehow avoid the automatic creation of "postgres" linux ...
0
votes
0answers
18 views

Upgrade postgresql from 9.4.8 to 9.5 in Ubuntu 16.04

I have a Ubuntu 16.04 server that requires PostgreSQL 9.5. The server has Postgresql 9.4.8. When I performed: apt-get update and apt-get upgrade I see that the following packages will be upgraded:...
-6
votes
1answer
161 views

Failed to start postgres database [closed]

I tried to restart Postgres database. Then it shows an error. * Starting PostgreSQL 9.5 database server ...
0
votes
2answers
101 views

AWS RDS with Postgres : Is OOM killer configured

We are running load test against an application that hits a Postgres database. During the test, we suddenly get an increase in error rate. After analysing the platform and application behaviour, we ...
0
votes
1answer
22 views

selinux context for multiple databases

I have a directory /media/databases under which I want to hold 3 different databases : mariadb, postgresql and neo4j. My issue is that I already have configured postgresql selinux context and the ...
0
votes
1answer
303 views

pgadmin4 : server won't start

I have this error message trying to start pgadmin4 web interface from the desktop helper on fedora 28/postgresql 10 : Failed to launch the application server, server thread exiting. Though, it ...
0
votes
0answers
18 views

Apache mod_dbd: DBDParams with encrypted password

I'm trying to configure Apache 2.4 with mod_dbd to connect to PostgreSQL for user authentication. (Ref: https://httpd.apache.org/docs/2.4/mod/mod_dbd.html) Is there a possibility to store the ...
0
votes
1answer
16 views

Postgres initial replication taking long time

My Master postgres db is currently < 100 mb. I am doing the initial replication on another machine, using command pg_basebackup -h 'masters_ip' -D /1TBdisk/postgres/ -U replica -v -P But its ...
0
votes
0answers
53 views

pg_dump permissions: what are the permissions Django uses to create table?

I've made a Django project called interro. I've made a PostgreSQL database called interro as well, with a PostgreSQL user called interro. Everything works, my Django project works, and connects. I've ...
1
vote
1answer
60 views

why does postgres complain about “ca md too weak” when connecting with ssl

I'm trying to setup a postgres server (version 10.4) with openssl access only. I created a self signed ca and the necessary private and public keys for the user and the server with easyrsa version 3 ...
0
votes
1answer
52 views

Error in creating a database dump on PostgreSQL

When trying to make a PostgreSQL database dump we got the following error and the process stops immediately. Command used: openbravo@master.akluck.com:~ 07/26 11:48:11> pg_dump -U tad -h ...
0
votes
1answer
29 views

pgpool watchdog and too many masters

I am trying to deploy pgpool in native replication mode with watchdog to manage 2 nodes for Active-Standby. When I start pgpool2 on both servers, they each claim to be the only node alive and become ...
0
votes
0answers
169 views

Does a Galera equivalent for Postgres exist?

I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera ...
0
votes
1answer
78 views

PostgreSQL trust connection with QGIS

I've setup a local postgresql database, and as it's a local database, I'm not worried about security or authentication. I'm currently using this database with QGis and PostGIS to store geometry data. ...
1
vote
0answers
35 views

AWS PostgreSQL RDS much slower than Heroku PostgreSQL

We're in the process of migrating some apps out of Heroku to AWS, and we've encountered a problem with the performance of the database in RDS. We initially tried using an Aurora PostgreSQL cluster, ...
1
vote
1answer
40 views

Installing postgres via puppet doesn't refresh package list, install fails

I'm on OSX 10.13.6 host running VirtualBox 5.2.16 and vagrant 2.1.2 I'm trying to set up a VM with bento/ubuntu-18.04 using two provisioners: 1) inline shell, to get puppet and the required modules ...