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
0answers
15 views

Control startup with docker-compose-wait postgres

Hello I'm trying to use a script to start my container node after my pg with this: #building code FROM node:lts-alpine ADD https://github.com/ufoscout/docker-compose-wait/releases/download/2.7.3/...
-1
votes
0answers
43 views

Unable to log Windows Server 2008r2 Perfmon Data Collector to Postgres 12

On Windows Server 2008r2 (non-Domain environment) I want to log server performance metrics to the Postgres 12 database running on the same server. I'm following the general guideline of this article ...
0
votes
1answer
36 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 ...
0
votes
2answers
40 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
1answer
20 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
0answers
15 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
1answer
20 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
0answers
17 views

Do I need to reindex after a PostgreSQL upgrade?

I recently upgraded a PostgreSQL server from 11 to 12, and now I'm finding many queries are running considerably slower. The database is about 1TB and I have many conventional indexes and GIN indexes. ...
0
votes
0answers
9 views

Running analyze on replica/slave (Postgresql)

We have a insert only table for which we often get bad results due to query plan using nested loops instead of hash joins. To solve this we have to run ANALYZE manually (vacuum sometimes don't run on ...
0
votes
0answers
14 views

Remove postgresql-10.service on Linux CentOS 7

I'm updating the version of postgreSQL 10 to 12 on Linux CentOS, I removed the PG10 installation and packages, PG12 was installed but, the service for the old DB was not removed. What I can do to ...
0
votes
1answer
27 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
0answers
12 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 ...
0
votes
0answers
8 views

Load on PostgreSQL, separate between schemas

I'm running PostgreSQL 9.6. I have 2 different schemas: cars.* and logs.*. Whenever I run big queries on log.* it stalls queries in cars.*. Shouldn't this be separated, if there is enough memory in ...
2
votes
1answer
13 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
1answer
43 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
0answers
23 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 ...
0
votes
0answers
15 views

Why cannot I successfully call this postgresql function? [closed]

My calling routine is: DO $$ DECLARE lbRes BOOLEAN; BEGIN SELECT lbRes = FUNC_GET_CHECK_DATE( CURRENT_DATE, 1 ); END $$; Function definition is: create or replace function ...
0
votes
2answers
30 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
0answers
18 views

It is recommended to install two databases to same VPS? MySQL and PostgreSQL together?

It is recommended to install two databases to same VPS? MySQL and PostgreSQL together? How about the performance of my server?
0
votes
1answer
31 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
0answers
32 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
1answer
164 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 "...
0
votes
0answers
121 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 ...
0
votes
1answer
122 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/...
0
votes
0answers
101 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
0answers
28 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
1answer
66 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
1answer
43 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 ...
0
votes
2answers
234 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
1answer
144 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
0answers
23 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
2answers
27 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
0answers
15 views

Using .pgpass when starting a PostgreSQL standby

I have a PostgreSQL 12.2 hot standby I'm trying to bring up. I have a .pgpass located in the home directory chmod-ed to 0600. I'm able to clone the primary server to the standby no problem. No issues ...
0
votes
1answer
28 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 ...
0
votes
0answers
39 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
1answer
22 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
1answer
22 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? ...
0
votes
0answers
18 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 ...
0
votes
0answers
12 views

PostgreSQL version of Percona XtraDB Cluster (master-master cluter)

Is there a "feature compatible" version of Percona XtraDB Cluster, but for PostgreSQL? I looked high and low but wasn't able to find comparable edition of PostgreSQL cluster. Is Percona really the ...
0
votes
0answers
73 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 ...
0
votes
1answer
500 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
1answer
32 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
0answers
15 views

How do you update services to talk to new IP in a master/slave database setup

I'm using postgresql. I have done a lot of reading into setting up redundant SQL setup and most of them boil to having a simple master-slave setup where the slave can become master at any point. Now ...
0
votes
0answers
22 views

PostgreSQL Function unknown issue

I develop application using VB6 and ODBC that fetch data from PostgreSQL function. i used function "F0006" to get information about item code , name , etc. So far my application run smoothly on ...
0
votes
0answers
36 views

Postgresql high cpu usage after hours when insert progress

I have a Application server with Postgresql database on Windows 2016, 8 virtual threads CPU and 32GB memory I try to stress with 10 client to concurrent insert to database, each insert operation ...
0
votes
1answer
20 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
1answer
45 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
1answer
65 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
0answers
17 views

Is it possible that the old primary follow the new secondary?

I need to change the roles between two nodes. Circumstance: 2servers: primary: psql01 and standby: psql02 After psql01 stops, psql02 becomes the new primary. After a while, start psql01 On ...
0
votes
1answer
116 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 ...

1
2 3 4 5
36