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

learn more… | top users | synonyms

6
votes
3answers
9k views

How install postgresql 9.4

After trying apt-get install postgresql-9.4, updating, trying again etc etc. It seems I can't install it: Couldn't find any package by regex 'postgresql-9.4' I know there is a similar question in ...
8
votes
2answers
20k views

Remotely access postgresql database

I need to access a postgresql database from a remote machine on a VPS at DigitalOcean running 12.10 and postgresql 9.1. How do I do this? I noticed port 5432 is closed, how do I open this?
0
votes
0answers
45 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
0answers
24 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
1answer
12 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
1answer
31 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 ...
1
vote
0answers
51 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
0answers
11 views

Proper Install instruction for installing PostgreSQL on Ubuntu 14.04 LTS

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
1answer
36 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 ...
1
vote
1answer
33 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: ...
3
votes
2answers
5k views

Run a PostgreSQL instance locally

I'm trying to follow this tutorial, but at the beginning it says to run a postgresql instance "locally" instead of as a daemon using the following commands. $ initdb pg $ postgres -D pg & $ ...
0
votes
2answers
186 views

Postgres 9.4 running but “service status” reports it down

Ubuntu 14.04.3 LTS and a new installation of Postgres 9.4 (with apt-get install postgresql-9.4, nothing fancy). Postgres was started with pg_ctl start by the postgres user. The status command reports ...
28
votes
6answers
24k views

What is the difference between “service restart” and “service reload”

I'm trying to understand the difference between service restart [someservice] and service reload [someservice]. I understand that "restart" restarts the service whereas "reload" reloads the ...
5
votes
2answers
4k views

Postgis + could not access file “$libdir/postgis-2.1”: No such file or directory

I am running postgresql9.3 and postgis2.1 , it works fine. When i installed QGIS by using the following commands: sudo apt-get update sudo apt-get install qgis After installing QGIS the postGis is ...
0
votes
1answer
79 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 ...
3
votes
2answers
2k views

How to make Postgres start automatically on boot

I am new to Ubuntu and I would like to know how to make postgresql start automatically on boot and how to configure my setup so that I can start the postgres server if need be. I am working on a ...
0
votes
0answers
19 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?
1
vote
2answers
2k views

How to specify a different locale for postgreSQL installation?

My system's locale is en_US.UTF-8. Because of that, the postgreSQL installation uses this locale by default for the cluster during installation. Creating new cluster 9.3/main ... config ...
0
votes
2answers
1k views

Trouble with rake db:setup

I am trying to pull a GitHub file using rake db:setup, but I get an error every time, no matter how many times I reinstall postgresql or check Rails. Here's the error I'm getting: ...
0
votes
0answers
32 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
82 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
36 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
60 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
1answer
72 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 ...
8
votes
3answers
7k views

install postgres 9.4 on ubuntu 14.04-2

I need to install postgresql 9.4 server but I only can find version 9.3. wit apt. How can I install or upgrade it?
1
vote
2answers
4k views

How do I install Postgres Graphical Installer?

I am a newbie in using Ubuntu (more precisely never used linux except the production deployment ). Now I choose to hold a grip on the system and intalled a latest 11.10 Ubuntu in my 32 bit Intel** ...
2
votes
3answers
3k views

Does postgresql (server) setup a main cluster after installation? (14.04)

I'm surprised that installing postgresql on ubuntu doesn't give me a working postgres server setup immediately: it requires additional steps: Setting up postgresql-common (154) ... * No PostgreSQL ...
0
votes
0answers
131 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
26 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
258 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 : ...
0
votes
0answers
239 views

Permission denied trying to setup postgres sql

I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on. So, When I try to ...
2
votes
2answers
797 views

Is there syntax highlighting for psql?

Is there some setting or package that I could use to give syntax highlighting to psql (the PostgreSQL shell)?
1
vote
1answer
83 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
198 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
147 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 ...
4
votes
1answer
207 views

Using Expect in Bash to set the inital “postgres” user password?

Following the tutorial here: http://www.unixmen.com/install-postgresql-9-4-phppgadmin-ubuntu-14-10/ I am scripting the installation of PostgreSQL in bash but having a problem when it comes to setting ...
0
votes
0answers
37 views

Lost PostgreSQL connections after database package reinstall

I upgraded my home server from 12.04 to 14.04 which came with PostgreSQL 9.3. Unexperienced, I forgot to verify which clusters I was running. I uninstalled 8.4 and 9.1 (Aptitude classified them as ...
0
votes
1answer
1k views

Got “Package operation failed” error while installing postgresql using ubuntu software center

I am trying to install JDownloader. But, while installing it using sudo apt-get install jdownloader, I got some error. Like this: j@ubuntu:~$ sudo apt-get install jdownloader Reading package lists... ...
1
vote
1answer
99 views

Don't create default cluster in postgresql

How do I prevent postgresql-9.4 from creating default cluster (main)? I have Ubuntu 14.04, use aptitude and postresql official repository. I'm using ansible to control multiple servers and want to ...
1
vote
1answer
696 views

can not install libpq-dev in ubuntu 14.04

I can not install libpq-dev for postgresql, i tried sudo apt-get install libpq-dev and output Building dependency tree Reading state information... Done Some packages could not be ...
2
votes
1answer
586 views

Enable PostGIS extension on Ubuntu 14.04.2

I have troubles enabling PostGIS extension on Ubuntu 14.04.2 and PostgreSQL 9.3. I have installed the packages with this step by step procedure. PostgreSQL and pgAdminIII seem to be installed ...
2
votes
1answer
2k views

Armitage won't start: parse error

I installed Armitage along with Metasploit and Postgresql but Armitage is not connecting. Starting Postgresql works fine sudo service postgresql start * Starting PostgreSQL 9.3 database server ...
1
vote
2answers
5k views

upgrade pgadmin3 1.16 to 1.18

I'm running Ubuntu 13.04 and have pgadmin3 1.16 installed. I downloaded pgadmin3-1.18.1.tar.gz from http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/src/ I followed all the instructions found ...
0
votes
0answers
42 views

How to access PostgresSQL by Windows ODBC

I just installed odoo by standart GIT (incl. postgresSQL).It's only command-line OS. Now I need to connect with MS-Access by ODBC to the database. How do I need to configure Ubuntu 14.04 and ...
5
votes
4answers
31k views

Uninstall an specific version of PostgreSQL

I have Postgresql 9.1.1 in my Ubuntu 12.04 which got installed due to automatic upgrades and whenever I uninstall it using the command: sudo apt-get --purge remove postgresql-9.1.1 I get an error ...
0
votes
1answer
179 views

Couldn't Excute command line PostGIS pgsql2shp

I am using postgres 9.3 with postgis 2.1 on Ubuntu 14. When I tried to dump pgsql table using pgsql2shp, I get the following error. Error: pg_wrapper: pgsql2shp was not found in ...
12
votes
3answers
54k views

How do I install pgAdmin III for postgreSQL 9.2?

I have a Windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu 12.10 workstation box. I installed pgAdmin III from synaptic and also tried direct download from ...
0
votes
2answers
992 views

Installing PostGIS on Ubuntu 15.04

When executing this command sudo apt-get install postgresql-9.4-postgis2.1 pgadmin3 to install PostgreSQL with PostGIS I get the following error: postgresql-9.4-postgis-2.1 : Depends: libgdal1 ...
0
votes
1answer
297 views

postgresql installation damaged

I installed postgresql using following command on 25th following instruction on (help.ubuntu.com/community/PostgreSQL) sudo apt-get install postgres postgresql-contrib It was working fine. Then on ...
2
votes
1answer
117 views

not able to uninstall postsql-xc

Postgressql installation was broken once I installed postgres-xc and postgres-xc-client. I tried uninstalling but not able to do it. The log of activities follows: postgres@ashUbuntu:~$ sudo apt-get ...