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 (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

-1
votes
0answers
12 views

Migrating postgres data from PC to DB

I've dumped my data to a file using: pg_dump database > file When I try to import it on my debian server, using: psql database < file it works for the most part but then crashes saying: ... ...
0
votes
0answers
5 views

brew remove doesn't remove all files on OSX? [on hold]

I am working on OSX 10.14.2. I have installed Postgres 11.1 and PostGIS 2.5.1, using Homebrew and uninstalled all previous versions with brew remove. According to Homebrew, I don't have any other ...
0
votes
0answers
14 views

AWS RDS instance 100% CPU utilisation for PostgreSQL for normal usage

am using aws rds Postgres 9.4. I am facing an issue of very high CPU utilization. Instance type is t2.xlarge (16 gb ram). All the time I can see very low ram usage i.e. 14 gb free, 15 gb free. But ...
0
votes
0answers
29 views

postgres restart error - cluster is owned by group id xxxx which does not exist

I am trying to restart a postgresql cluster on a debian jessie box using pg_ctlcluster 10 main start , but this hits Error: The cluster is owned by group id 5001 which does not exist which I am a bit ...
0
votes
0answers
11 views

Getting GEOSFrechetDistanceDensify while importing data to OSM

I am trying to import data to the OSM server. I am new to this OSM servers. Everything is installed on CentOS and I am able to get the data from the server the only error which I am facing is while ...
0
votes
0answers
28 views

Postgres is friggled on new Gitlab install [closed]

So I've been having issues getting Gitlab CE installed on a new Ubuntu 18.04 server. It seems to happen whenever it gets to Postgres. I dont know what to tell you about it, but if you ask questions, I ...
1
vote
1answer
14 views

Location of conf files for PostgreSQL 11 on Ubuntu 16?

Where are the configuration files located for PostgreSQL 11 on Ubuntu, specifically 16.04? Postgres Ubuntu packages normally store their configs in /etc/postgresql/<version>/main. However, I ...
13
votes
2answers
2k views

How to big scale backup Gitlab?

When asking Gitlab support on how to do a 3TB backup on ones on-premise Gitlab they reply use our tool that produces a tarball. This just seams wrong to me on all levels. This tarball contains the ...
0
votes
1answer
26 views

Is persisting data in Fargate containers recommended?

My application - a Postgres/Nginx/Django application powered by docker-compose. 3 separate containers. My production setup - Nginx/Django containers hosted on Amazon ECR. Deployment to a single ...
-1
votes
0answers
30 views

PostgreSQL Cluster with Synchronous Replication on RAM Disks

Has anybody tried it? I would like to know what is the expected overhead of the synchronous replication in a 3 node cluster where all the nodes are running entirely on RAM disk. My concern is that ...
1
vote
1answer
37 views

Lack of TRIM support — will benchmarks get progressively slower on ZFS + SSD?

Context: I'm on a Toshiba 512 GB NVMe (Model: KXG50ZNV512G) I'm seeing this weird behaviour while benchmarking Postgres on ZFS-on-Linux (via pgbench), where the second and third runs of a benchmark ...
0
votes
0answers
44 views

error: password authentication failed for user // ubuntu 18 // postgresql

Working with a source code for "bustabit" if anyone has heard of that. Basically when launching the gameserver I get this error error: password authentication failed for user "root" at connection....
0
votes
1answer
204 views

Not possible to drop table, not possible to check open connections

I am connected to the postgres database, as postgres user: docker exec -it mycontainer psql -h localhost -U postgres I see the databases: postgres=# \l List of ...
0
votes
1answer
20 views

How to I redirect read requests to replica in Postgres Cluster?

I have a Postgres Cluster of 2 servers currently. They are managed by Patroni with ETCD as my DCS. I want to be able to redirect Read requests to the replica and Write requests to the master. I read ...
1
vote
1answer
61 views

Why does my PostgresQL 11 database cluster instantly shutdown after being started via systemctl?

I have installed PostgresQL 11 via apt-get on Debian 9. After installation I deleted the default database cluster and removed all services auto-starting that cluster. I've now ran initdb to initialize ...
0
votes
0answers
28 views

psql: FATAL: no pg_hba.conf entry for host “172.31.37.251”, user “postgres”, database “postgres”, SSL off

command "psql -U postgres -h postgresql" ends with error: psql: FATAL: no pg_hba.conf entry for host "172.31.37.251", user "postgres", database "postgres", SSL off while same command, but local ("...
0
votes
1answer
24 views

Migrating data from a RDS Read Replica to Redshift

I am trying to create a AWS DMS (Data Migration Service) task to migrate the data from a RDS Read Replica running Postgres to a Redshift cluster, however my task is always failing when it is time to ...
0
votes
0answers
447 views

Postgres disc io quota without host access?

Is there a way to configure Postgres to limit either it's IOPS or throughput without access to the VM that's hosting it? I'm trying a postgresql hosting situation (AWS aurora) where disk io costs ...
1
vote
1answer
67 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
14 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....
1
vote
1answer
62 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
38 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
44 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
66 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
95 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
49 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
61 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
47 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 ...
2
votes
0answers
35 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
1answer
101 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
66 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
50 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
1answer
88 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
88 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
21 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
1k 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
53 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 ...
2
votes
0answers
226 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
35 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
136 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
25 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
16 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
43 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
117 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
741 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
87 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
27 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
288 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
149 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 ...