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

learn more… | top users | synonyms

0
votes
0answers
8 views

Error on Starting PostgreSQL 9.3 database server on UBUNTU 14.04

When I do this command to start PostgreSQL 9.3 Server : sudo service postgresql start I got this error : * Starting PostgreSQL 9.3 database server * Error: Could not create log file ...
0
votes
0answers
12 views

Are there any benefits of running PostgreSQL vacuumdb nightly with autovacuum enabled? [on hold]

I've noticed the vacuumdb in the crontab of a server I maintain that was configured not by me and wonder if adding it makes any sense. All options related to autovacuuming are commented out in ...
1
vote
1answer
23 views

Unable to connect to PostgreSQL

I had PostgreSQL 9.3 working fine but when I tried to upgrade to 9.5 I began encountering errors. So I purged Postgres from my system following the first answer of this question. Then I installed ...
0
votes
0answers
50 views

Error installing postgres [closed]

I'm running Zorin 9.0 Light. I've run the following: sudo apt-get install postgresql-9.3 pgadmin3 I get a long return message. The end of the message is as follows: Setting up ...
1
vote
1answer
40 views

Upgrading from 15.10 to 16.04 Configuring Postgresql-Common Issue

I am currently at a loss right now while upgrading from 15.10 to 16.04 in Ubuntu. I currently can't take screen shots because I am right in the middle of the upgrading the distribution and my ...
0
votes
0answers
19 views

permission denied at /usr/share/perl5/vendor_perl/local/lib.pm in 269 line BEGIN failed — compilation aborted

permission denied at /usr/share/perl5/vendor_perl/local/lib.pm in 269 line BEGIN failed -- compilation aborted I got this error while starting the postgres database server.
0
votes
1answer
22 views

Unable to import PostgreSQL database in Ubuntu

I need one help i need to import my database file to ubuntu using PostgreSQL.When i am checking my database its looking like below. When i am trying to import my database file using the following ...
3
votes
1answer
34 views

Landscape - Postgresql database fill up storage

Is there a way to limit database size or to erase landscape events? If not, I suppose that I will have to extend the filesystem ? root@prod-lds-db:~# du -shc /var/lib/postgresql/9.1/main/* 12G ...
-1
votes
2answers
20 views

How to create superuser and importing sql?

i had problem to creating super user with this command sudo -u postgres createuser --superuser wahyu (wahyu is my user name) i've already using root access to do that but i found this ...
0
votes
1answer
281 views

How to install postgresql-9.4 on Ubuntu 16.04?

Tried sudo apt-get install postgresql-9.4 but it doesn't find it. How can I install this version?
0
votes
1answer
103 views

After upgrade to 16.04, Postgresql 9.4 is broken

After upgrading, postgresql 9.4 is broken. Any help would be greatly appreciated. The command: # /etc/init.d/postgresql start (04-29 14:52:01) [ ok ] Starting postgresql (via ...
0
votes
0answers
9 views

I have installed Quasar and can't get it to open

After downloading Quasar, and installing PostSql (I have both 8.4 and 9.5 installed...), I can't get Quasar to open. There is a icon in the main menu for Quasar Admin and Quasar Accounting, but when ...
0
votes
0answers
94 views

msfconsole not running Ignoring bcrypt-3.1.11

I have problems when running metasploit on Ubuntu LTS 14:04. I've created a database msfconsole and run postgresql but still does not work. root@evan:/home/evan# msfconsole Ignoring bcrypt-3.1.11 ...
0
votes
1answer
43 views

Postgis installation on Ubuntu 15.10 server gives dependencies error

I am trying to install Postgis on Ubuntu server 15.10 using the following command: sudo apt-get install postgresql-9.5-postgis-2.2 but I am getting following error: The following packages have ...
0
votes
1answer
17 views

Failed to fetch postgresql problem on Ubuntu 14.04

I am having a problem fetching data from postgresql repository. I have already uninstalled this one. But it keeps showing when I issued a "sudo apt-get update" command.
0
votes
0answers
11 views

When upgrading PostgreSQL servers, do I have to upgrade the client software on the client machines?

So I have an architecture that looks familiar to anyone who has used AWS before: RDS(PostgreSQL 9.4) PHP clients(laravel 4.2) Nods.js clients The question I have is when I upgrade the RDS do I ...
0
votes
1answer
71 views

How to configure setting of phppgadmin with xampp and postgresql 9.5?

I'm using Ubuntu 14.04, Xampp 5.6 and PostgreSQL-9.5 I have already uncommented these lines: extension=php_pdo_pgsql.dll extension=php_pdo_sqlite.dll extension=php_pgsql.dll but still I this ...
0
votes
2answers
61 views

Landscape for personal use

I am trying to install Landscape Dedicated Server for personal use on a clean Ubuntu 14.04 server from scratch. After adding the ppa-repository and updating apt, I install the thing with apt install ...
0
votes
0answers
46 views

UBUNTU trusty/14.04 - postgres/postgis installation problem

I installed postgresql and postgis using the following command: sudo apt-get install postgresql-9.3-postgis-2.1 but now when I try to create a postgis extension, I get this error: CREATE EXTENSION ...
0
votes
0answers
119 views

sudo apt-get update fails on postgresql

I am trying to install nodejs but it keeps on failing. So I have uninstalled nodejs and found out that sudo apt-get update still fails. It's been so long that I have used postgresql. but here is my ...
0
votes
0answers
42 views

Unable to load pgAdmin3

I am receiving the following error reporting some type of a conflict when I try to load pgAdmin3. What steps do I need to take to resolve this update conflict? ...
1
vote
1answer
142 views

Pgadmin3 not working on ubuntu 15.10

I installed postgres than pgadmin3 on ubuntu 15.10. install was successful but when I type pgadmin3 in terminal and hit enter I get this following error : Fatal Error: Mismatch between the program ...
0
votes
0answers
39 views

permission issue with commands start with sudo

whenever i run command with sudo it shows following error. how can i fix this ? like i want to clear cache by writing command sudo php bin/console cache:clear it first prompt sudo: /var/lib/sudo ...
0
votes
1answer
57 views

Database not starting in init.d

I am attempting to setup a small postgresql database on a beaglebone black. The application is slow so I am storing the database on a 64GB microsd card. I formatted the drive, mounted it all ...
0
votes
1answer
52 views

postgresql install on lubuntu 14.04 -i386

Got a version of Ubuntu (lubuntu-14.04.4-desktop-i386) to install and behave on this HP Pavilion dv5 and was able to install Libre Office via Lubuntu Software Center. Progress. My next task is to ...
0
votes
1answer
74 views

Is port 5432 open for postgres?

Here is the output of the netstat command on ubuntu 14.04 server: admin@ibm-testbox:~$ netstat -tulnp | grep 5432 (No info could be read for "-p": geteuid()=1000 but you should be root.) tcp 0 ...
-1
votes
1answer
29 views

Installing mysql server with postgresql

I'm using backbox 4.4 which it was built-in with postgresql. Yesterday i think about "can i installing mysql database along side postgresql database ? ", i want to learn database connection but i so ...
0
votes
0answers
15 views

Is there some method to request newest postgresql postgis package rather than specific version?

There is postgresql-9.3-postgis-2.1 and there is postgresql-9.4-postgis-2.1. Unfortunately 9.3 is available only on trusty and 9.4 is not available on trusty (see ...
4
votes
0answers
170 views

How to uninstall specific versions of Postgres?

On Ubuntu 14.04 I have done this to get the latest postgres: sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' wget ...
0
votes
0answers
58 views

Cannot connect remotely to either MySQL or Postgres

I am trying to connect remotely to the MySQL database on my cloud server which is configured with Ubuntu 14.04.03. However I cannot do so (details below). I can neither connect from a Windows client ...
0
votes
0answers
76 views

Sudo service <argument> stop not working

While looking through the output of service --status-all to find some programs to kill and increase my battery life I ran into a problem. I run sudo service postgresql stop and I get the stopping ...
0
votes
1answer
68 views

Postgres pg_hba.conf Configuration

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a db.session.commit() I get this as an error: OperationalError: (OperationalError) fe_sendauth: no password ...
0
votes
0answers
17 views

Proper Install instruction for installing PostgreSQL on Ubuntu 14.04 LTS [duplicate]

I have followed the instructions on several site to install PostgreSQL on 14.04 however none have been successful. There has been different failures from unmet dependencies to simply not installing at ...
0
votes
0answers
99 views

two postgres have been installed, remove both

I have previously installed postgres 9.1 by How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 14.04 It was installed correctly and my app was working fine, but today its not working ...
0
votes
1answer
204 views

Postgres changes file permissions to its detriment

Someone, please, please, please explain to me what the hell is going on here, and how I can fix this? I'll let my console do the talking: root@worker2:/var/run# service postgresql start * Starting ...
0
votes
1answer
57 views

PostgreSQL 9.3 not uninstalling Ubuntu 14.04

I have PostgreSQL 9.3 and 9.4 installed, now I want to uninstall 9.3 to remove conflicts I removed it using: $ sudo apt-get purge postgresql-9.3 But when I run $ ps aux|grep postgres I get this: ...
0
votes
1answer
48 views

Reinstalling Broken PostgreSQL 9.1 on Ubuntu 14.04

After upgrading Ubuntu from Precise to Trusty, I was attempting to upgrade PostgreSQL from 9.1 to 9.3 and have hit a bit of a snag. When I ran pg_upgrade in "check" mode, it complained about being ...
0
votes
1answer
536 views

postgres: unrecognized service

After reading this question I did: gsamaras@gsamaras:~$ sudo apt-get install postgresql Reading package lists... Done Building dependency tree Reading state information... Done postgresql is ...
0
votes
0answers
39 views

How to use PgAdmin?

I have installed PgAdmin III in my Ubuntu Gnome OS. How can I start using it in order to create a database? What should I give as service while connecting to a server?
0
votes
0answers
51 views

Why is Postgres running even after uninstall? How do I stop it?

I have uninstalled postgres using sudo apt-get --purge remove postgresql a few days back. I have restarted my computer quite a few times since then. But the postgres server seems to be running even ...
0
votes
1answer
256 views

Unable to remove pgadmin3 version 1.18 from Ubuntu 14.04

I am running Ubuntu 14.04 and have pgadmin3 version 1.18.1, PostgreSQL 9.4 installed. I am new to pgadmin3. I want to upgrade to pgadmin3 1.20.0. So I used sudo apt-get update sudo apt-get install ...
0
votes
1answer
61 views

Double Quotes inside Double Quotes problem for postgres sensitive database name priviliges

Having a database with case sensitive name like MyDb, if I want to use psql to grant all privileges on this database to the user 'user' I can just write: GRANT ALL PRIVILEGES ON DATABASE "MyDb" TO ...
0
votes
1answer
248 views

Can't to log in postgres account by pgAdmin

Before I changed my forgotten postgres pass using 'su - root' in command line. Then I try to connect server using pgAdmin and I get error: Error connecting to the server: FATAL: password ...
0
votes
1answer
93 views

Database / systemctl issues after switch to 15.04

I recently updated Ubuntu to 15.04. Since then, I've been having issues starting and stopping postgres and mongodb, which also affects apt-get when it tries to install or uninstall them. Here's the ...
0
votes
0answers
204 views

Installing Foreman Fails

For some reason I can't setup Foreman, after being so simple it keeps failing. It happens after I run the $ foreman-installer Everything looks great and then these two errors show up: Execution ...
0
votes
1answer
53 views

Is it possible to 'export' an installed package

I need to install a software that runs only on Ubuntu 10.04. This software uses Postgres 9.0 client, which depends on libpq5 version 9.2.4-0ppa1~lucid Version 9.2.4 is no more available on PPAs. ...
1
vote
0answers
510 views

ERROR: could not access file “$libdir/plpython2”: No such file or directory

I am running postgresql 9.4 ("PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14), 64-bit" ) when I am trying to create language in postgres SQL : ...
1
vote
1answer
183 views

Can't run PSQL scripts from terminal

I can't seem to run PSQL script files from my Ubuntu terminal. Specifically, when I run ./populate_ppima_db.sh melon melon I get the following output: Insert Basic Data psql: FATAL: Peer ...
0
votes
1answer
399 views

how to fix Error: Port conflict: another instance is already running

I fired two command sudo apt-get update sudo apt-get upgrade It will give me error after upgrade(after press "Y") Setting up postgresql-9.1 (9.1.19-0ubuntu0.12.04) ... * Starting ...
0
votes
0answers
221 views

PostgreSQL move data directory to home folder

i have a problem with the moving of my data directory of postgresql. I found many different ways, but none worked. The most sensible way for me was: stop postgresql copy data from old folder to new ...