Questions tagged [postgresql]

PostgreSQL is a powerful, open source object-relational database system.

Filter by
Sorted by
Tagged with
1 vote
0 answers
17 views

Why does writing to a PostgreSQL database (docker) shows some activity in the Network panel of the system monitor

A quick, yet simple question that came to my mind while observing my system monitor (I was curious on the RAM and CPU usage) while writing a massive data set to a PostgreSQL database hosted on my ...
user avatar
  • 670
0 votes
0 answers
17 views

running make with 22.04 LTS on Postgis , errror message flex is missing, although flex is installed

Underneath some feedback from the make process, in the last line the feedback from the flex (re)install suggests flex is already installed ( could see it also in the /usr/bin folder ). I pulled the ...
user avatar
  • 1
0 votes
0 answers
14 views

How to disable postgresql port for out-server connection?

I installed Ubuntu 20.04 as a dedicated server. On it I installed Docker and a container with postgressql. I have s problem because I want Ubuntu to block all connections with postgressql out from ...
user avatar
  • 1
0 votes
0 answers
50 views

Trying to install a specific version of postgres, how do I know what version of libpq5 to install?

Viewing the answer in this thread - How to install libpq-dev (14.0-1) on ubuntu 21.10? - Just install the required version of libpq5 and reinstall libpq-dev: sudo apt-get install libpq5=13.4-1 sudo ...
user avatar
  • 243
0 votes
0 answers
48 views

Assertion failed on job for postgresql@14.service in ubuntu

Unable to restart postgresql@14 service getting "assertion failed on job for postgresql@14.service"
user avatar
0 votes
0 answers
13 views

Upgrade cpp faild in UBUNTU 20.4

I've been trying to install Postgresql in ubuntu 20.4 but the below error is rising: "The following packages have unmet dependencies: cpp-9 : Depends: gcc-9-base (= 9.3.0-17ubuntu1~20.04) but 9.4....
user avatar
  • 21
0 votes
1 answer
48 views

How to create offline installer for postgresql14?

I need to create offline installer for postgresql14 which can run without internet connection at all. As I see we can download .deb package via: sudo apt-get install --download-only pkg_name in such ...
user avatar
  • 101
0 votes
1 answer
28 views

postgresql is active with pgadmin4 but not showing anything in my php code

I'm new to ubuntu community or linux sounds better. so I don't have much knowledge of repositoies and packages. So, I've installed xampp, postgresql and pgadmin4 in my ubuntu 20.04 LTS. nothing showed ...
user avatar
-1 votes
1 answer
125 views

Error while installing PostgreSQL 14.2 onto kUbuntu 20.04

i tried to install and get in run PostgreSQL 14.2 onto kUbuntu Version 20.04. using instructions from several pages and it ends always with the same error. i tried as described here: https://www....
user avatar
  • 373
0 votes
0 answers
27 views

Failed to build the PostgreSQL remote connection

I have tried the method mentioned on the other answers, but only to find they all failed. What I did to the configuration are below. Modified the "pg_hba.conf" file # IPv4 local ...
user avatar
  • 1
1 vote
2 answers
117 views

Is there a way to install PostgreSQL using apt-get without it running initdb automatically?

I am trying to set up replication for PostgreSQL on Ubuntu 20.04 and for the stand-by node I just need to install the PostgreSQL-server and not run initdb. Cluster creation on the stand-by will be ...
user avatar
0 votes
0 answers
27 views

Postgres asks for password without having a password? [duplicate]

I installed Postgresql on Ubuntu today. After going through the installation steps without problems, psql asks for the database password. But I never got asked for a password or had the option to ...
user avatar
  • 1
0 votes
0 answers
511 views

Uncaught Error: Call to undefined function pg_connect()

I have following server cofiguration: Ubuntu 20.04.3 LTS PHP 7.4.13 (cli) psql (PostgreSQL) 12.9 (Ubuntu 12.9-0ubuntu0.20.04.1) I have moved my web service based on WordPress from Windows to Linux ...
user avatar
  • 1
2 votes
1 answer
82 views

How does a apt repository work to find the available packages?

For example i have this apt ubuntu (21.10) repository for postgres in my sources.list.d: deb http://apt.postgresql.org/pub/repos/apt/ impish-pgdg main 13 Which results in apt-get update to fetch: Hit:...
user avatar
0 votes
0 answers
251 views

Setting Up PostgreSQL DB with bash script using variables from .env file

I'm trying to set up PostgreSQL with a bash script which takes the variables from an .env file. My code - #!/bin/bash DB_NAME=$(grep DB_NAME .env | cut -d '=' -f 2-) DB_USER=$(grep DB_USER .env | cut ...
user avatar
0 votes
1 answer
272 views

Postgresql 12 shuts down randomly

I'm using ubuntu 18.04 and postgresql 12, See journalctl below: Dec 16 09:39:19 server sudo[55084]: postgres : TTY=unknown ; PWD=/var/lib/postgresql/12/main ; USER=root ; COMMAND=/usr/sbin/sysctl ...
user avatar
0 votes
1 answer
542 views

postgres connect as different user

New to postgres. Till now I used mysql and whenever I needed to login I did this: mysql -u root -p which then prompted me to provide password for user root But postgres feels a lot different than ...
user avatar
0 votes
0 answers
49 views

Postgres apt upgrade on Ubuntu 18.04 hangs every time

On Ubuntu 18.04: any time apt lists postgres as available for upgrade, it hangs forever like this: Setting up postgresql-server-dev-12 (12.9-1.pgdg18.04+1) ... Setting up postgresql-12 (12.9-1.pgdg18....
user avatar
0 votes
1 answer
352 views

Can I stop postgres running in the background?

On Kubuntu 20.04 Before I can successfully start a docker container on my computer I need to kill a Postgres process. I do this by: sudo ss -lptn 'sport = :5432' ,which outputs: State Recv-Q Send-...
user avatar
0 votes
1 answer
2k views

How to install libpq-dev (14.0-1) on ubuntu 21.10?

I already have the postgresql of latest version(14.0-1.pgdg21.04+1). I want to setup dev environment for psycopg2(https://github.com/psycopg/psycopg2/) library locally and it requires libpq-dev for ...
user avatar
  • 286
1 vote
1 answer
306 views

How do I install PostgreSQL version 14 on Ubuntu 21.04?

Ubuntu 20.04 only gave me the obsolete PostgreSQL 12. After upgrading to "21.04 (Hirsute Hippo)" I got version 13. How do I install the latest version (14)?
user avatar
  • 386
1 vote
0 answers
106 views

Enabling password authentication for new postgres user

How do I make ubuntu prompt me for a password after creating a new postgres user. It doesn't ask for a password with the postgres user but I want to change this under an added user
user avatar
0 votes
2 answers
574 views

Cannot change PostgresSQL default user password

Recently I have faced with issue that I cannot change password that is used in pgAdmin for connection to remote database ... In pg_hba.conf (PostgresSQL 12) I have the following login capabilities: # ...
user avatar
1 vote
1 answer
101 views

Skipping acquire of configured file 'https://apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'

I have recently installed Ubuntu 20.04 LTS and I am a bit fresh user for ubuntu. after installing postgresql 14, and I ran sudo apt update. Then it says N: Skipping acquire of configured file 'main/...
user avatar
  • 21
0 votes
0 answers
89 views

Set up Postgres

I recently istalled PostgresSQL , but when I enter psql to the terminal, if gives me the error: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or ...
user avatar
0 votes
0 answers
38 views

Zabbix installation with packages

I have been worked with Zabbix in the past and now I want to create a new installation on my Ubuntu 18.04 My choice will be PostgreSQL as database and NGINX as web server My question is I have already ...
user avatar
  • 1
0 votes
0 answers
60 views

Unable to install postgreSQL 9.6 in Ubuntu 20.04 [duplicate]

It worked hundred times in my ci/cd pipeline, but suddenly stopped to work and idk what could I broke. According to this and/or this, I do: lsb_release -cs # just for debug focal echo "deb https:...
user avatar
  • 166
1 vote
1 answer
79 views

How to drop superuser of PostgreSQL

I want to delete the user Mark but every time when I use the drop user Mark; command i get this message: or if i try to drop the role i get the same error. What am I doing wrong? How do I fix this?
user avatar
0 votes
0 answers
57 views

PostgresSQL dump version recognition Bash script

I often recreate variuos customer databases on local dockers to test new ERP functionalities in the development environment So, PostgreSQL dump file usually starts with: -- -- PostgreSQL database dump ...
user avatar
1 vote
0 answers
121 views

Could not set permission for new database on postgresql?

I'm the beginner in PostgreSQL, today I cannot create new TABLESPACE on my HDD disk. Specifically: I'm running the Ubuntu 20.04 on the SSD. Install and using Postgres 13 normally on this disk. I want ...
user avatar
  • 121
0 votes
1 answer
419 views

`chown postgres` of a subdirectory not working for a new disk

To give postgres more space, I mounted a ssd at: /mnt/fast_data/ What I'd like to accomplish is to give the postgres user ownership to the postgresql directory, so it doesn't say permission denied. $ ...
user avatar
  • 5
0 votes
0 answers
623 views

How to install PHP pdo_pgsql driver version 13.3 on Ubuntu 18.04

I have successfully installed some time ago a default installation of PHP 7.4 and of Postgresql v10 on my Ubuntu 18.04 LTS server. Today I need to update my Postgresql version to 13.3 - but can't ...
user avatar
  • 151
1 vote
1 answer
240 views

How can I see only the database I have access to in pgAdmin 4?

I created a free postgres database on Heroku, when connecting it to my pgAdmin4 the connection is done normally, however, thousands of databases appear along with mine. All the databases that appear I ...
user avatar
0 votes
0 answers
100 views

Unmet dependencies when trying to install PostgreSQL with apt [duplicate]

I am trying to install postgresql in ubuntu 20.04, but facing unment dependicies issue. You might want to run 'apt --fix-broken install' to correct these. The following packages have unmet ...
user avatar
0 votes
0 answers
62 views

Errors were encountered while processing: postgresql-client-11

Someone installed postgresql in our server and causing an update issue. I am trying to remove this package but failed after many attempts. For examples: $ sudo apt autoremove Reading package lists... ...
user avatar
  • 2,333
0 votes
2 answers
90 views

Ubuntu shell script for starting multiple Postgres servers

I'm fairly new to Ubuntu and I'm tying to write a .sh script that starts up 2 postgres servers. I disabled pw requirement for sudo in /etc/sudoers here is my script so far and it's probably incorrect. ...
user avatar
1 vote
0 answers
36 views

I can't install libpq-dev on Ubuntu 20.04.2 [duplicate]

Problem I can't install libpq-dev in ubuntu 20.04.2 I ran this command: $ sudo apt-get update $ sudo apt-get install libpq-dev then I got errors bellow. Reading package lists... Done Building ...
user avatar
  • 111
1 vote
1 answer
307 views

Why Ubuntu Server ask me to restart services?

I've installed latest Ubuntu Server on Linode. When I install some packages with apt-get, like node.js or postgres it stops and the window with question pops up. How to disable this question window? ...
user avatar
0 votes
1 answer
36 views

On two different servers, different services will not start, but if they are restarted, start successfully

On two different servers I have redis and postgresdb installed. Neither will start successfully on boot, but will start if they are manually started/restarted. The error for both are the same (failure ...
user avatar
  • 285
2 votes
0 answers
756 views

ubuntu 20.04 sudenly using port 5432?

I was using a postgres docker just fine with ubuntu 18.04. Now I updated to ubuntu 20.04 and I suddenly can no longer start the docker, since the following error pops up - notice this error keeps ...
user avatar
  • 323
0 votes
0 answers
47 views

Trying to install libgcc but getting error from postgres

I was trying to execute this command on my ubuntu machine: yum install libgcc.i686 But getting this error which seems meaningless here: https://download.postgresql.org/pub/repos/yum/common/redhat/...
user avatar
  • 111
1 vote
1 answer
574 views

Installing PostGIS with GDAL 3.0.4

I have installed PostgreSQL on Ubuntu 18.04 using these instructions: https://computingforgeeks.com/install-postgresql-12-on-ubuntu/ Now I'm trying to install PostGIS extension: sudo apt install ...
user avatar
-1 votes
1 answer
38 views

SQL performance worsens on adding an INNER JOIN clause in Postgres [closed]

I have the following query SELECT pri.* FROM patientreceiptitem pri JOIN patientfinancialtransaction_patientreceiptitem pp ON pri.id = pp.receiptitems_id JOIN patientfinancialtransaction pft ON ...
user avatar
0 votes
0 answers
230 views

Could not make connection from local machine to Ubuntu even after opening Firewall

I am trying to setup remote postgresql for my app on cloud, however the connection is refused from my local machine. Please note i am able to make SSH connection from my local machine using putty. But ...
user avatar
0 votes
1 answer
6k views

No module named 'psycopg2' + error during installation

I developed a python script which imports data to my Postgres DB and it works fine on my local machine but when I transferred it to the server it fails with: Traceback (most recent call last): File &...
user avatar
  • 142
0 votes
1 answer
2k views

Pgadmin4 installation fails on Ubuntu 18.04 Bionic Beaver

I am trying to install pgadmin4 on Ubuntu 18.04 Bionic Beaver but every time I try to run the sudo apt install pgadmin4 pgadmin4-apache2 it returns the following error: Building dependency tree ...
user avatar
4 votes
2 answers
415 views

Installing Postgis in Ubuntu 18.04 with libgdal26-incompatibility with libgdal20?

I have been looking at this for a couple days now but I have not found a solution yet. I am trying to install Postgresql-13-postgis-3 in my ubuntu 18.04 machine. Currently I have Postgresql 13 and ...
user avatar
1 vote
1 answer
57 views

Restore mysql db from AWS AMI?

We have one EC2 instance running our mysql database server. due to a security incident we had to delete the current EC2 instance as database was completely messed up with some sort of encryption. So ...
user avatar
  • 2,233
0 votes
1 answer
134 views

unattended-upgrades and postgresql version

Can the apt dist-upgrade command On Ubuntu/Debian distros update the version of PostgreSQL? I've some Ubuntu 18.04 LTS servers using PostgreSQL 9.6 and I don't want that unattended-upgrades execution ...
user avatar
  • 103
1 vote
1 answer
120 views

Major changes in sorting method of glibc on Ubuntu 18.04 after upgrading to Ubuntu 18.04.5

I had an Ubuntu 18.04.0 with Postgres 9.6. Before Ubuntu upgrade following command result was: vodka@ubuntu140:~$ ( echo "1-1"; echo "11" ) | LC_COLLATE=en_US.UTF-8 sort 1-1 11 ...
user avatar

1
2 3 4 5
13