Questions tagged [postgresql]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
24 views

Can't connect to PostgreSQL server via ODBC

At work, we have a PostgreSQL server running (Ubuntu) which I have to connect to from R. I have to do this via my own local VM (via Virtualbox; RStudio), a server VM (connected via a WSL terminal, R ...
0
votes
0answers
10 views

Transfer file of the root user to postgres user

I have a root user and also a helper user called postgres sudo su - postgres this command logins me as postgres user I have a file test.txt in Desktop How do I make that file visible in the home ...
0
votes
1answer
131 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 ...
-1
votes
1answer
28 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 ...
0
votes
0answers
12 views

OSM Errors: Map wont properly render

For a couple of days I've been trying to create and configure a local map server. I've used this tutorial in an attempt to get the server up but for some reason my tiles never completely render. https:...
0
votes
0answers
33 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 ...
0
votes
0answers
26 views

Unable to install PgAdmin4 on Ubuntu 20.04

I'm a new contributor to AskUbuntu and StackOverflow in general. I'm trying to install pgAdmin4 on Ubuntu 18.04 following this LinuxHint tutorial. I created the virtualenv successfully, checked that ...
0
votes
1answer
78 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 &...
0
votes
1answer
28 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 ...
0
votes
0answers
53 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 ...
0
votes
1answer
21 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 ...
0
votes
1answer
33 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 ...
1
vote
1answer
44 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 ...
1
vote
0answers
36 views

Connect to Postgres via WireGuard

I forwarded the Postgres port for the WireGuard client: iptables -t nat -A PREROUTING -p tcp -d 186.29.26.175 --dport 5432 -j DNAT --to-destination 10.50.0.4:5432 Please tell me is this the correct ...
0
votes
1answer
25 views

Postgresql service stopping on its own in ubuntu server

In the postgresql log file, I found message: startup process (PID 1886772) was terminated by signal 9: Killed Although upon restarting service, postgresql database starts functioning normally. ...
1
vote
1answer
481 views

Postgres 12 on ubuntu 20.04 (replication checkpoint has wrong magic 539122744 instead of 307747550)

In an ubuntu 20.04 with Postgres 12 server, after a problem in HD, Postgres stopped working. Bellow my tests and the tries to solve the problem: ~$ psql psql: error: could not connect to server: No ...
0
votes
0answers
28 views

Trouble wih bundle exec rake install

I am getting this rake aborted message after running bundle exec rake install command for git repository project I am working on.This is the code of trace of operations and error message. /home/...
1
vote
2answers
378 views

Upgrading 18.04.5 to 20.04 LTS also upgrades postgresql?

I'm doing do-release-upgrade now, and it seems it downloaded postgresql-12 package '__') was it automatically done? because I saw there's a tutorial to upgrade manually postgresql-10 to postgresql-12 ...
1
vote
0answers
112 views

PgAdmin 4 in standalone desktop mode-Error

I have followed the steps mentioned here, the 2nd Answer: Install dependencies, create a virtual environment, download, install & configure When I execute the following command: $ python3 lib/...
0
votes
0answers
23 views

How to clone the same environment I have on the local machine to the deployment environment?

Let me first talk about my local env : I work on a Laravel project using the vagrant: (PostgreSQL 12.4 + PHP 7.4.10 ) The problem is I discovered that some results are not not the same between my ...
0
votes
1answer
407 views

database import error using pgadmin 4 v4.28 in ubuntu20.4

I m trying upload database file in local server which name postgresql pgadmin4 v4.28 and facing request timeout issues how can solve this ? I m also increase max upload file limit and have made ...
0
votes
1answer
832 views

Postgreslq service active but stopped

On Ubuntu 20.04 I have a Postgresql service active but not running ~$ sudo systemctl status postgresql [sudo] password di ______: ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/...
0
votes
1answer
1k views

pgAdmin4 doesn't open the correct web browser

Context I've installed pgAdmin4 using the APT installation procedure on Ubuntu 18.04 (default package without this new apt repository ships pgAdmin in version 3, which is deprecated). This is how my ...
0
votes
1answer
120 views

How to remove postgres 12 - Can't open /usr/share/postgresql-common/maintscripts-functions

Having some trouble deleting postgres 12 which has been causing lots of problems, like I can't run sudo apt upgrade at all because of that. This is the error: Setting up postgresql-client-12 (12.5-...
1
vote
0answers
7k views

could not connect to server: Connection refused Is the server running on host “127.0.0.1” and accepting TCP/IP connections on port 5432?

When I want to open pgAdmin 4, this message appears: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? ...
0
votes
0answers
24 views

Unable to install ruby libpq-dev [duplicate]

I am trying to bundle install a Ruby project, the install fails when trying to install a gem and it says: An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that '...
1
vote
1answer
2k views

Cannot use psql “sudo: unknown user” “sudo: unable to initialize policy plugin”

I've been working on a bot for Discord which utilizes a PostgreSQL database and I'm trying to install it on a Vultr server (Ubuntu 20.04). Everything is working fine until I get to the part where I'm ...
0
votes
1answer
383 views

Install postgresql10 on ubuntu20.04?

I upgraded ubuntu from 18.04 to 20.04 While I upgrade, I had to remove postgis library. (it wouldn't upgrade unless I delete it) Now I have postgres10 without postgis, and I need postgis back on this ...
0
votes
1answer
582 views

How to run and configure postgres when installed from snap?

Having installed postgres how do I now use it? postgres@mordor:~$ postgres@mordor:~$ whoami postgres postgres@mordor:~$ postgres@mordor:~$ pwd /home/postgres postgres@mordor:~$ postgres@mordor:~$ ...
0
votes
1answer
132 views

Perl Module Location Issue

I'm on Ubuntu 20.04 LTS. I ran the following commands to try to connect to my PostgreSQL database: sudo -i -u postgres postgres@{username}:~$ psql This raised the following error: Can't locate ...
0
votes
0answers
78 views

Apt error when updating after adding apt.postgresql.org PPA to pgdg.list

I am currently encountering an error while simply updating my Ubuntu 18.04 OS using apt. Here are the steps to reproduce. I assume postgresql is already installed from the official Ubuntu repositories....
1
vote
1answer
110 views

add path permenantly on ubuntu for postgresql user [duplicate]

I am having trouble adding current PATH permanently on my ubuntu server for a postgresql user. Every time I ssh or restart the server I have to run export PATH="${PATH}:${HOME}/.local/bin", ...
0
votes
0answers
63 views

Faulty Postgresql Reinstall on Ubuntu Server 20.04

I have tried to install postgresql 12.04 on Ubuntu 20.04 LTS after uninstalling because it had the wrong time local. However when I reinstall using: apt install postgresql-12 postgresql-client-12 It ...
0
votes
1answer
68 views

Migrating python application to higher version

As per Wikipedia python 3.5 support ended on 2017 aug. Python 3.8 and python 3.9 are new versions. My application deployed on ubuntu 16.04 with python 3.5 version and postgres 9.6 However application ...
0
votes
0answers
79 views

Reinstalled PostgresQL and need to move the dbs from the old cluster to the new one

Trying to get the latest libpq-dev package for a Ruby gem, I ended up having to uninstall PostgreQL 12 and when I tried to reinstall it all to get a clean install, it installed version 13. No problem, ...
1
vote
0answers
99 views

pgAdmin4 will open as if it was a book after switching desktop environments

I use KDE Plasma on Ubuntu. I started a session on regular Ubuntu desktop then switched back. Now, pgAdmin will open on Calibre (ebook management sofware). I tried running pgadmin4 directly on the ...
0
votes
0answers
104 views

After upgrading to Ubuntu 20.04, unable to copy/move files to NFS: Input/output error

After upgrading to Ubuntu 20.04, I can not copy/move files to NFS. Here is an example: $ cp test.log /shrProd/pg_wal/ cp: cannot create regular file '/shrProd/pg_wal/test.log': Input/output error
0
votes
0answers
43 views

unable restart postgresql after ALL pg_terminate_backend()

Trying to stop Postgresql queries, I followed the answers from this question where at some point say: SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'YOUR_NAME'; Executed, ...
0
votes
0answers
28 views

Why my insertions in PostgreSQL are slower using Raid 1 in Ubuntu 20.04.1?

I would like to know if anyone can help me. My main goal is to set up a PostgreSQL server to store sensitive data. I installed Ubuntu 20.04.1 in a SSD (134 GB of RAM) and I decided to use Raid 1 ...
0
votes
1answer
104 views

apt - install old versions of databases, e.g. mysql

I am working on ubuntu 20.04 and I need mysql in version 5.6 or postgresql version 9.6. I Know that I can specify a version using: apt-get install mysql-server=<version> And I can see the ...
0
votes
0answers
178 views

Adding APT deb source for pgAdmin4 makes a lot of non-related packages obsolete

Context My Ubuntu 18.04 (5.4.0-42-generic x86_64 GNU/Linux) system is freshly updated and upgraded; $ sudo apt upgrade Reading package lists... Done Building dependency tree Reading state ...
0
votes
0answers
28 views

Import a postgresql cluster created with mac

I'm trying to start a server with data created with Mac and when i try something like: pg_ctlcluster 12 existingcluster start -D /path/to/existingcluster -l logOfCluster.txt my terminal answers: ...
0
votes
0answers
106 views

Terminate from psql mode after executing a sql script in linux

I have to execute a sql script to clear db entries after the test execution from command line. sudo -u postgres psql -U postgres -d notification_test -c "TRUNCATE TABLE system_notification"; ...
0
votes
0answers
24 views

How to clean up multiple postgresql versions

I have gotten my hands on a Ubuntu (20.04) system where they run postgresql 10, 11 and 12. All seems to be installed by apt. How can I get rid of 10 and 11 and move everything into 12 ?
0
votes
1answer
109 views

Dovecot returns a hash mismatch after setup

So I had a working setup with postfix and dovecot with virtual users stored in a postgresql db on an Ubuntu 18.04 VPS. I've decided to make a new setup on a VPS based on the same settings (that I ...
0
votes
1answer
702 views

Postgresql: can't start service database system was shut down

I install Postgresql using sudo apt install postgresql postgresql-contrib then I run sudo systemctl restart postgresql then I run sudo systemctl status postgresql It says Active: active (exited) ...
1
vote
0answers
396 views

PostgreSQL - Peer authentication failed for user “postgres”

I have a bot that runs on my Windows machine and I recently bought an Ubuntu virtual server. After a series of like infinite errors, I just reset the server completely and retrying from scratch. You ...
0
votes
0answers
843 views

Cannot install postgresql packages with apt-get — “no Release file”?

I am currently attempting to install TimescaleDB on my Ubuntu 18.04 I followed TimescaleDB's instructions to get the Postgresql key to it's third party repos in order to install the newest packages ...
0
votes
0answers
5k views

Unable to connect to server: timeout expired pgAdmin

I am using Google Cloud computing engine with SSH, which works on Ubuntu. I have installed Postgres and edited pg_hba.conf and postgresql.conf, but after that I am getting this error when I use to ...
0
votes
3answers
287 views

[ Directory '../../etc/postgresql/9.3/main' does not exist ]

I am trying to change pg_hba.conf but when I inter sudo nano ../../etc/postgresql/9.3/main/pg_hba.conf i got on the screen [ Directory '../../etc/postgresql/9.3/main' does not exist ] i have fallow ...

1
2 3 4 5
13