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.

0
votes
0answers
42 views

Connect to postgresql using php pdo - not working

I have Ubuntu 18.04, apache2, PHP 7.2.10-0ubuntu0.18.04.1, and PostgreSQL 10.5 (Ubuntu 10.5-0ubuntu0.18.04) running on localhost:5432. I am trying to make a PDO connection to a database. But it's not ...
0
votes
2answers
30 views

How to remove first X lines from file up to the first occurrence of particular string?

I have many PostgreSQL dump files such this and because I import these files automatically into another database server (H2) and SET command is not compatible with this database, I need to remove all ...
0
votes
0answers
14 views

pg_dump: role missing, how to add a “backup” role?

I am writing a backup script for my confluence database and data. I followed the advice in 1079213 and created the user backup-user. Access to my filesystem is ok. But I can't do the database dump. ...
0
votes
0answers
13 views

Ubuntu PostgreSQL on a raspberry pi

I am trying to setup a postgres database on my raspberry pi running Ubuntu. Everything works like connecting via PgAdmin to it. How can I access the database from outside my network?
0
votes
0answers
10 views

PhpPGAdmin stopped working after upgrade to 18.04

I've recently upgrade my development PC from Ubuntu16.04 to 18.04 and although Postgres continues to run, I get the following in my browser when trying to access phppgadmin printHeader('', null, true)...
0
votes
0answers
14 views

Error in Dockerfile while building postgresql10, What base image should I use?

ENV PG_MAJOR 10 ENV PG_VERSION 10.1-1.pgdg80+1 RUN echo 'deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main' $PG_MAJOR > /etc/apt/sources.list.d/pgdg.list RUN apt-get update \ &...
0
votes
0answers
156 views

Unable to Install PostgreSQL Unmet Dependencies [duplicate]

I'm trying to install PostgreSQL. First I successfully installed it using apt install postgresql, which currently installs version 9.5 by default. But I want to use a newer version. Here's what I've ...
0
votes
1answer
109 views

Bash Script that check if a database exist

I'm trying to create a bash script that check if a database(PostgreSQL) exists: function is_database() return $(sudo -u postgres psql -c "SELECT exists(SELECT datname FROM pg_catalog.pg_database ...
0
votes
0answers
120 views

pgAdmin4 not working - How to solve not listening 5432 on postgresql after set config file correctly

I am a novice ubuntu user. I am working on an ubuntu 18.04 VM on Windows10 machine through Putty. I installed postgreql & I am trying to install pgadmin4 but it's not working. When I run the ...
0
votes
0answers
17 views

Unable to install postgresql in ubuntu 16.04 [duplicate]

I tried to install postgresql using this instruction: sudo apt-get install postgresql-9.5 postgresql-contrib-9.5 In the stdout I got this: Reading package lists... Done Building dependency tree ...
0
votes
0answers
31 views

Groups,User and PostgreSQL access rights

I have a web app that uses a PosgreSQL database. To use the database I use the following command: sudo -u postgres psql I think, this is very basic, so I'm looking for something like: not all ...
1
vote
0answers
31 views

Postgresql command line utility dosen't start on WSL

I'm using Windows subsystem for Linux with Ubuntu 18.04; I'm trying to use postgresql on my machine, I've taken care of the relevant installations. But when I enter the command: sudo -u postgres ...
1
vote
1answer
30 views

Trouble to run commands after changing user password with home directory encryption

I needed to change a server password, done that by passwd. Thing is, this Ubuntu Server installation uses the home encryption aparently. Once I changed the password, after some package update, the ...
1
vote
0answers
533 views

Installing postgresql-10 libgssapi-krb5-2 (>= 1.14+dfsg) but 1.13.2+dfsg-5ub [duplicate]

i'm trying to install postgresql-10 via the instructions listed here: https://www.postgresql.org/download/linux/ubuntu/ I'm trying to run this step and I keep getting the following unmet dependency ...
0
votes
0answers
25 views

Cannot sudo apt-get update and install postgresql? [duplicate]

I got an error when I tried to update sudo apt-get update as below: Err:1 http://apt.postgresql.org/pub/repos/apt xenial-pgdg InRelease Temporary failure resolving 'apt.postgresql.org' Err:2 http://...
2
votes
1answer
70 views

Using bash in combination with psql, passing variable between them

I'm writing a bash script where I use psql (Postgresql). DATABASE='scifi' sudo -u postgres psql count=SELECT COUNT(*) FROM (SELECT datname FROM pg_catalog.pg_database WHERE lower(datname)=lower($...
0
votes
0answers
18 views

Lampp Apache cant connect wih PostgreSql server

Basicly i want to Lampp's Apache web server as main webserver for 3 Databases type that i have mysql (bundling with Lampp default),PostgreSql-10 (fully installed and tested),MongoDb (not yet started ...
2
votes
1answer
137 views

issue with pgadmin installing in ubuntu18 server

I have ubuntu 18 server installed & i want to make it postgres sql server for my own practice, Installed postgres but unable to get pgadmin tool. Any suggestion guys?????? Tried many times using "...
3
votes
1answer
489 views

Error: could not determine PostgreSQL version from '10.4'

getting error while installing uniq Error message: Downloading https://engci-maven-master.cisco.com/artifactory/api/pypi/apic-em-pypi-group/packages/86/fd/...
2
votes
2answers
1k views

How to execute SQL statement from command line?

I'm a longtime GUI user trying to switch to command line, and I'm not sure how to execute an SQL statement from the Ubuntu command line. I'm using postgres. I can use \c to connect to the database ...
0
votes
1answer
207 views

Problems with Ubuntu 18.04, Python 3.6.5, psql 10.4 and pgAdmin 1.22.2

Code did run with: Lubuntu 16.10, Python 3.5.2 (python3), psql 9.5.7 and pgAdmin 1.22.1. .... Also installed: Python 2.7.12 (python) Code does not run with: Ubuntu 18.04, Python 3.6.5 (python and ...
2
votes
1answer
2k views

How to install PostgreSQL 9.5 in Ubuntu 18.04?

I want to install PostgreSQL 9.5. But the available version is 9.6. I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
1
vote
1answer
101 views

Unable to uninstall PostgreSQL 9.3 from Ubuntu 14.04 without installing PostgreSQL 10

I just upgraded my Postgres instance from 9.3 to 9.6, and everything worked perfectly until I tried to uninstall 9.3. Apt is trying to install Postgres 10 during the removal of 9.3. 9.6 needs to stay ...
0
votes
1answer
652 views

Postgresql server is not listening

I know this question has asked many times, but non of those answers worked for me. The problem is, when I run "psql", I get the message psql: could not connect to server: No such file or directory ...
0
votes
0answers
19 views

Connection problem with postgresql

Have a problem connecting postgresql with local server 01:45:01: Ошибка: Error connecting to the server: FATAL: password authentication failed for user "postgres" FATAL: password authentication ...
0
votes
1answer
83 views

What's the difference between psql -V and apt-cache policy postgresql?

I have installed postgres 9.6, If you type in terminal psql -V or psql --version, you know which postgresql version you have installed, however, if you type sudo apt-cache policy postgresql, it ...
2
votes
1answer
2k views

Unable to install postgreSQL 9.6 in Ubuntu 18.04

I'm trying to install postgreSQL 9.6 in Ubuntu 18.04 via Ubuntu Software Centre and type from terminal sudo apt-get install postgresql-9.6 according to official documentation https://www....
0
votes
0answers
28 views

How to install postgresSQL-10 from binaries on ubuntu 18

I downloaded tar file from postgres site here, and followed next step from this document here and facing this issue ./configure :command not found
0
votes
0answers
36 views

how to create a postgres on NFS? [duplicate]

I have mounted NFS on the local server, want to build a database on NFS, other servers can access through an account, the problem is that the database is created, can only be accessed on the local ...
0
votes
0answers
24 views

Postgres installation in ubuntu 14

Setting up postgresql-10 (10.4-2.pgdg14.04+1) ... * Starting PostgreSQL 10 database server * Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/...
3
votes
1answer
223 views

How to install psql without Postgres?

I need the psql command line tools, but I don't need the actual Postgres RDBMS. This is to work with a package which supports a psql interface. Is it possible to install just psql? (Ubuntu 16.04)
1
vote
0answers
22 views

AWS Instance with 30 GB RAM, still running out of Memory and High CPU usage with small app?

We are on 30 GB AWS instance running a Ruby on Rails app using Passenger + Apache. Though the App Postgres DB has millions of records, The DB size is few GB only. Now I am finding the server to ...
0
votes
1answer
99 views

Set PostgreSQL pager to less?

I'm trying to get my psql pager output to look nicer. I've added the following to my ~/.bashrc export PAGER='less -S' And I've added these line to my ~/.psqlrc \x auto \pset pager on \setenv ...
4
votes
0answers
4k views

Pgadmin 4 Not working in ubuntu 18.04 [closed]

I have installed postgres 10 and pgadmin4 in my Ubuntu 18.04 version. everything went fine. I cannot open the pgadmin gui. what might be the reason. it simply wont open. Does it require Qt? how do i ...
1
vote
0answers
531 views

password authentication failed for user “manager”

I have created a user manager in Ubuntu server 17. Then create a node js application behalf of this user. Then try to connect to the postgresql 10 through the following config using postgres user. ...
1
vote
0answers
639 views

How to stop postgresql to free the port 5432

I am trying to run this command to install wsgi for python Flask: sudo apt-get install libapache2-mod-wsgi-py3 I am getting this error: Reading package lists... Done Building dependency tree ...
0
votes
0answers
23 views

Should I remove files in /etc/rc*.d that correspond to software I no longer have installed and if I should then how to do so?

In the /etc/rc*.d directories I have files such as *01mongodb, *01postgresqland *01mysql, but I have neither of these DB softwares installed anymore. As I know these files tell the system what to do ...
1
vote
1answer
47 views

I was following a blog post to install postgresql and start getting this error while updating my OS

N: Ignoring file 'pgdg.listsudo' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
1
vote
0answers
186 views

dpkg: unrecoverable fatal error, aborting

I'm trying to install Postgresql on this Droplet, and the installation can't go through. This is the error I'm getting. root@testplatform:/usr/bin# sudo apt-get install postgresql postgresql-contrib ...
0
votes
1answer
122 views

Can't remove postgresql in ubuntu 16.04

Im trying to remove entire postgresql on ubuntu $ sudo apt-get --purge remove postgresql* Now it is not working anymore and i got this message. Reading package lists... Done Building dependency ...
0
votes
1answer
789 views

How to install postgresl 9.6.8 or 10.3 to Ubuntu 17.10 Artful Aardvark?

There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps ...
0
votes
0answers
389 views

enable shared libraries for python

I'm trying to install PostgreSQL with PL/Python server programming language on Ubuntu 16.04 LTS. When I run ./configure --with-python, I receive an error/warning asking for a shared python library. ...
1
vote
1answer
2k views

What is a masked service?

I would like to understand what a masked service is and how to unmask it if need be. I have been trying to start PostgreSQL on Ubuntu 16.04-LTS using the command systemctl start postgresql.service. ...
0
votes
0answers
50 views

PAM-PGSQL authentication succeeds but user cannot access the file system

Synopsis: I would like to use PostgreSQL as the authentication server for my Linux users via PAM. For this purpose, I use the libnss-pgsql2 library. The Linux distro is Ubuntu 14.04. So far, I have ...
2
votes
1answer
2k views

How do I install a point release of Postgres 10, like Postgres 10.2?

It appears to be easy to install the latest point release of Postgres 10, which, at the time of writing appears to be Postgres 10.3. However, I want to install Postgres 10.2, which I cannot seem to ...
0
votes
1answer
44 views

Copying the Postgres directory via Samba?

I have Samba and Postgres installed on two machines. I can successfully copy files from one machine to another when fhe files' user and group are my sign-in user and group for both machines. (The ...
0
votes
1answer
2k views

How to uninstall the postgresql

I did try different ways of installing postgresql like version 9.5, version 9.6. I forgot how to install them, by doing this sudo apt-get --purge remove postgresql I can't uninstall them. Is there ...
-1
votes
1answer
62 views

How to define a permission to save a file on Ubuntu [duplicate]

I am trying to install postgreSQL I open terminal and type the gedit /etc/apt/sources.list.d/pgdg.list then in Gedit I enter this line deb http://apt.postgresql.org/pub/repos/apt/ zesty-pgdg ...
0
votes
2answers
3k views

Unable to install Postgresql-10 on Ubuntu 16.04?

E: Unable to locate package postgresql-10
1
vote
1answer
331 views

PSQL cannot login with -h option

I can login with psql if I don't use -h option and failed with -h (neither localhost or 127.0.0.1 works). Don't know what's wrong :( Info: postgresql 10, ubuntu 16.04 on Windows 10. This is my ...