Questions tagged [postgresql]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
37 views

update-alternatives: error: alternative link is not absolute as it should be: usr/bin/psql

I intend to set the psql default version and switch from version 12 to 9.6 I have typed the following line in the terminal: sudo update-alternatives --install usr/bin/psql psql usr/lib/postgresql/9.6/...
0
votes
1answer
28 views

Why does Pasting or typing in my password and hitting enter creates newlines instead of submitting password?

I'm working from a windows computer, and the server that I am renting is from digital ocean using Ubuntu. I am trying to create a postgres db dump, and when I am prompted to enter my password I am ...
0
votes
0answers
39 views

Systemd service stopped suddenly

We have a flask python application that runs normally on terminal without error. We converted it to systemd service(ubuntu), but the problem is that the service runs normally then stopped suddenly ...
0
votes
0answers
6 views

Maas region controllers to postgresql BDR (multi-master) cluster connection

When I try to register my region controllers to Postgresql BDR (multi-master) cluster using the maas init command, the below error appears: psycopg2.NotSupportedError: ALTER TABLE ... ALTER COLUMN ...
0
votes
0answers
7 views

MAAS HA cluster to Postgre HA cluster connection

I deployed a MAAS 2.7 HA cluster, sequentially composed of: 2 load-balancer (haproxy) with keepalive (virtualIP) for dashboard access/region controllers HA (port 80) 3 region controllers 2 load-...
0
votes
0answers
15 views

Ubuntu 18.04, upgrade postgres from 9.6 to 11

On Ubuntu 18.04 I had postgres version 9.6 I also installed postgres 11 like this: echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main 11" | sudo tee /etc/apt/sources....
0
votes
0answers
12 views

Ubuntu keeps installing postgresql 12.2 instead of 9.5

I am trying to set up a local environment with postgresql 9.5 for my Django app but for some reason pg_config --version keeps saying the version running is 12.2. I've purged all existing ...
0
votes
1answer
153 views

On ubuntu 20.04 LTS can not install postgis

When i try to install postgis with sudo apt install postgresql-12-postgis-2.5 I run into an error postgresql-12-postgis-2.5 : Depends: libgdal20 (>= 2.0.1) but it is not going to be installed E:...
0
votes
1answer
12 views

Can't read and change original pg_hba.conf in PostgreSQL 12

I can't to connect to aws remote ubuntu server where installed postgresql. And i want to connect from my pc to postgres on ubuntu i cant do that: Unable to connect to server: FATAL: no pg_hba.conf ...
0
votes
0answers
21 views

Postgres - Can't connect to any database

Yesterday I reinstalled ubuntu so I had to reinstall postgres. The thing is that now I can't connect to any db. If I try to connect from the terminal this error shows up: psql: error: could not ...
0
votes
0answers
20 views

Accessing Ubuntu guest on Windows?

I have installed Ubuntu in WSL version 1, installed pgAdmin4 in Ubuntu, and since there is no browser (it is just a terminal), I want to access pgAdmin through a Windows browser. The subsystem and ...
2
votes
0answers
514 views

pgadmin4 package has no installation candidate

1 - Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository deb [arch=amd64] http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main 2 - Import the repository signing ...
2
votes
1answer
143 views

Skipping acquire of configured file in ubuntu 20.04 LTS

I have recently updated to Ubuntu 20.04 and I am a bit fresh user for ubuntu. after installing postgresql 12 I ran sudo apt-get update it says N: Skipping acquire of configured file 'main/binary-i386/...
4
votes
1answer
60 views

PostgreSQL admin tool behind nginx

I have a VPS with PostgreSQL installed. I've nginx setup with a bunch of reverse proxies to different tools, grafana, Node.js sites and so on. I'm trying to setup PostgreSQL right now, and I just can'...
11
votes
3answers
6k views

Can't install pgAdmin 4 on 20.04 LTS

Basically, follow the steps as outlined here: https://wiki.postgresql.org/wiki/Apt. sudo apt-get install curl ca-certificates gnupg curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-...
-2
votes
0answers
29 views

Encountered a problem while installing Postgresql on the Ubuntu 20.04 LTS version

https://wiki.postgresql.org/wiki/Apt - it listed there all the supported architectures including i386. Why I am still getting this?
1
vote
2answers
81 views

Install Postgresql 9.6 instead of Postgresql 12

I am running Ubuntu 18.04. When I want to install the PostgreSQL database server package I get the default version 12. I have unsuccessfully tried to follow multiple instructions on how to install the ...
0
votes
0answers
30 views

Switched to postgres user after PostgreSQL install, can't switch back to normal user

I installed PostgreSQL using this guide: https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04 It says that the install command created a Linux user ...
1
vote
1answer
57 views

How to Backup a PostgreSQL Database From a Docker Container Using DBeaver?

I have a Postgres database running in a docker container in my machine (running Ubuntu 20.04 Beta) and I need to make a backup of it. I'm using DBeaver 7.0.2 to manage the database, but when I try ...
0
votes
0answers
11 views

How to export postgress all database except one database using shell script

I want to export postgress all database except one database. Is it possible to take backup using shell script?
0
votes
0answers
107 views

Problem in installing Postgresql-11on ubuntu 16.04

I am trying to install postgresql on my ubuntu 16.04 machine, I am following the instructions given on the official site, here. Though when I run the command sudo apt-get install postgresql-11, I get ...
3
votes
1answer
316 views

psql command “Error: PostgreSQL version 12 is not installed”

I have installed PostgreSQL 11 but for some reason when I type psql in the terminal I get PostgreSQL version 12 is not installed error Recently I uninstalled a PostgreSQL server so I think I didn't ...
0
votes
1answer
29 views

Port seems open on Ubuntu Guest, I cannot connect to it from windows host using telnet

I have the following: windows 10 host, ubuntu 18 guest. I want to connect to a postgresql instance on guest. On guest: sudo lsof -i -P -n | grep LISTEN postgres 649 postgres 7u IPv4 ...
0
votes
1answer
27 views

Postgresql, how to import large bak.gz file?

I have 13GB bak.gz database dump. How can I import it to my local pgsql db by ubuntu command line?
0
votes
0answers
161 views

How to connect Datagrip on Ubuntu (WSL) inside Windows

I have installed Ubuntu ecosystem from Microsoft Store (https://www.microsoft.com/en-us/p/ubuntu/9nblggh4msv6?SilentAuth=1&wa=wsignin1.0). After setting up the environment, I installed postgres, ...
0
votes
1answer
37 views

Error: Could not find pg_ctl executable for version 11 (PostgreSQL 11) + let's encrypt

I have a VPS hosting with a domain redirecting to it. I have LAMP stack for my main website using WordPress CMS. Plus I am using Odoo as my back-end with python and PostgreSQL in a sub-domain. ...
1
vote
2answers
45 views

Only root can access to USB even if the user belongs to the right groups

My OWL cm160 power meter came with a Windows native app. I found a C app for Linux but it use sqlite. It's OK for some days' samples but I'm going to have polling every second or two forever, so I'm ...
0
votes
1answer
58 views

Can't install postgres due to texlive error

I try to apt-get install postgresql but it fails with dependency complaints about texlive. The error message suggests apt --fix-broken install but that also fails with complaints about texlive. I do ...
0
votes
0answers
42 views

Reverse ssh | SSH bridge to access Postgres behind NAT

If this is duplicate, please, advise the proper question. I have DataGrip IDE to connect to Postgres, but I can do this only inside a corporate network, cause Postgres host is behind NAT. DataGrip ...
0
votes
1answer
34 views

How to move PostgreSQL Data Directory to external HDD or pendrive on Ubuntu 18.04?

I followed this post:https://www.digitalocean.com/community/tutorials/how-to-move-a-postgresql-data-directory-to-a-new-location-on-ubuntu-18-04 from digitalocean but didn't work. This is the error I ...
0
votes
1answer
46 views

Cannot install libpostgresql-jdbc-java [duplicate]

I have a VM running Ubuntu Server 18.04. I am trying to install libpostgressql-jdbc-java as root: apt-get install -y libpostgresql-jdbc-java This produces the following error: E: Unable to locate ...
1
vote
1answer
29 views

Can I install multiple database management systems on a same machine having ubuntu 18.04?

I currently have Postgresql installed on my system but I also want to install mariadb on my system. So I want to know is that okay or it will show errors after installing mariadb. Thanks
-1
votes
1answer
82 views

How to fix bash errors in /etc/profile?

When i start my Postgresql it takes an while and i get this strange error message and i think like this file is corrupt? [tis jan 28 20:03:56] Jonathan@Whats next?:~$ sudo systemctl start postgresql ...
0
votes
1answer
268 views

How to start PostgreSql

When I am running this command below: sudo -u postgres psq I get this error message below: psql: could not connect to server: No such file or directory Is the server running locally and ...
0
votes
1answer
54 views

Can't connect to Postgres

I made a really stupid thing: I ran sudo chmod -R 777 / for all folders inside the root directory. After that even sudo didn't work because of invalid permissions. I fixed the problem with sudo, but I ...
0
votes
1answer
102 views

unable to find package 'postgresql-12-citus-9.1'

I am following this documentation to install PostgreSQL and Citus extension: # Add Citus repository for package manager curl https://install.citusdata.com/community/deb.sh | sudo bash # install the ...
0
votes
0answers
19 views

pgpool passwordless connection to postgres server

ssh access to PostgreSQL remote server only allows one server to access. I'm using pgpool to access PostgreSQL server for load-balancing
2
votes
1answer
111 views

APT doesn't autoremove an automatic package with 0 dependents

$ apt install postgresql-11 $ apt purge postgresql-11 $ apt autoremove if you execute these commands on a fresh Ubuntu or Debian installation you will find that a dependency named postgresql-client-...
0
votes
0answers
21 views

Why does the apt repo have such an old version of Postgresql? [duplicate]

I have been trying to research why the apt repo has such an old version of postgres. Postgres 12 is out (the website is even talking about version 13), but the apt-get repo installs Postgres 10. Is ...
1
vote
2answers
734 views

Error during installing postgers 12 in Ubuntu 19.10

I'm installing Postgres 12 on my Ubuntu 12 system, I get the error when trying to run many different commands : sudo apt -y install postgresql-12 sudo apt install postgresql-12 Here is my error ...
1
vote
1answer
35 views

How to add man page for postgres?

I just install postgres 9.6 inside my /opt directory. I want to show the man page of the postgres. While I type man postgres, it says, No manual entry for postgres. I think this error may arises ...
0
votes
0answers
43 views

Django, PostgreSQL and Peer Authentication

I am setting up a Django site to run through Apache using Mod WSGI. I have setup PostgeSQL to accept local, Unix socket connections, and limit authentication to peer users only. Necessarily I setup ...
0
votes
1answer
332 views

sudo: psql: command not found: can't fix it

When I run sudo -u postgres psql I get the sudo: psql: command not found error. I can't get it to work. # locate psql /etc/alternatives/psql.1.gz /usr/bin/psql /usr/lib/postgresql/9.5/bin/psql /...
1
vote
2answers
26 views

+ near elements value postgresql

While I was trying to solve an issue (asked on Stack Overflow), I just bump on that type of result when I want to see which data are stored inside an Enum : Schema | Name | Internal name | ...
0
votes
0answers
43 views

apt-cache giving different results for version from installed binary (eg ogr2ogr) on Bionic

I am trying to install gdal-bin with support for PostgreSQL 12 on Ubuntu Bionic. From this post I understand that I need something more recent than July 2019. I have added the UbuntuGIS Stable ...
0
votes
0answers
298 views

postgre sql error: could not connect to server: No such file or directory

So I just installed postgre sql and pgadmin using command : sudo apt-get install postgresql-11 postgresql-client-11 libpq-dev postgresql-server-dev-11 pgadmin4 Upon typing psql in terminal i'm ...
1
vote
1answer
1k views

Re-install of pgAdmin4 on Ubuntu 18.04 does not prompt for user/password and local pgAdmin site not found

I initially followed instructions to install postgres and pgadmin4 from https://tecadmin.net/install-pgadmin4-on-ubuntu/ successfully. I seemed to be able to get to the site at http://localhost/...
0
votes
2answers
299 views

Unable to start Apache2 server on Ubuntu 18.04

So the error says that the address is already in use. I have configured the /etc/hosts with some DNS mapping to a few domains. Not sure if this is causing the problem.
0
votes
1answer
154 views

Postgresql drop role command not working

drop role command not working in my postgresql 11. I can't delete the role named 'ckdev' . Role name | Attributes | Member of -----------+------------...
1
vote
1answer
499 views

pg_dump script for database backup

How I can create an script to backup my postgres databases on linux systems using pg_dump Already use the comand but i want someting execute itself no user interaction so pg_dump -U postgres -W -Fc ...

1
2 3 4 5
12