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

learn more… | top users | synonyms

0
votes
1answer
18 views

Command pg_dump not found?

I was going to make a backup in a server and I got the error: pg_dump command not found I thought that if you had postgres installed, it worked. What I have to do to "install" it? Because I do not ...
0
votes
0answers
23 views

read/write permissions secondary driver on Ubuntu 14.04

I have installed a second driver on Ubuntu 14.04. It is formated as "ext4" and labeled DATA sudo blkid > /dev/sdb1: LABEL="DATA" UUID="df065398-cb68-47df-b1ab-abf81916159f" TYPE="ext4" and all ...
0
votes
0answers
13 views

packet-o-matic on Trusty 14.04

I'm trying to install pom on Trusty and have installed the pre-reqs listed at http://wiki.packet-o-matic.org/pom/installation but pom ./configure fails to recognize postgresql root# ./configure . ...
-1
votes
0answers
28 views

I'm stuck PGBarman configuration on Ubuntu 11.10 help please! [on hold]

I'm trying to backup my server with pgbarman on ubuntu 11.10. Probably i'm missing something about making configurations. When i typed "barman backup all", it says "2014-07-18 08:25:45,686 ...
0
votes
1answer
32 views

PostgreSQL importing from folder

I lost my ubuntu partition (12.04) and I've installed the ubuntu 14.04, I could save my database files from postgreSQL v9.1, but now I'm with a problem how can I import this data base and my settings ...
0
votes
2answers
26 views

postgresql vs postgresql-server-dev package

What is the difference between postgresql and postgresql-server-dev packages. What are the purposes served by installing different packages and what are the use-cases of these?
1
vote
1answer
97 views

PostGIS dependency conflicts (ubuntu 14)

I asked this over on SO, but now I'm thinking the problem is mainly package management and belongs here. Subsequent to all the detail that can be found in the original post, I have tried (sudo ...
0
votes
1answer
27 views

how to hiding Ubuntu and postgreSQL versions?

I'm seeking to closing some vulnerabilities of my postgreSQL server that is running over ubuntu 12.04 server, some of these vulnerabilities is an ability of scanners to checking versions of my OS and ...
0
votes
1answer
14 views

Where are the log files for psql connection attempts?

I want to troubleshoot a failed attempt to connect to a remote Pg server using psql. I'd expected to find some log files for psql, but I didn't. Is there any other place where such information would ...
1
vote
1answer
65 views

What are the IP addresses in my iptables chain FORWARD settings in a Dokku/docker setup?

I've been playing around with Dokku on DigitalOcean (following this guide) and I'm trying to understand current firewall settings. So here's my setup: Ubuntu 14.04 Dokku Docker (as part of Dokku) ...
0
votes
0answers
23 views

installing plperl in postgresql

I am trying to use the perl language in postgresql, thus I need to install plperl. I am running all of my queries in pgadmin III. When I first tried create extension plperl; I get the following ...
0
votes
0answers
207 views

Postfix PostgreSQL Dovecot SASL Authentication Fails Ubuntu 14.04LTS Server

I previously setup my mail server using Ubuntu 12.04LTS and all worked fine (see Postfix Dovecot SASL Authentication not enabled/working ubuntu 12.04 server), but I recently moved everything to new ...
0
votes
1answer
39 views

PostgreSQL data diff

Note: this question is not about syncing database schema/structure Problem In my web application I have a PostgreSQL database server (PGS) and a (separate machine) business logic server (BLS) which ...
0
votes
0answers
21 views

Postgresql ubuntu 12.04 not starting

I installed PostgreSQL on ubuntu 12.04, using apt-get install postgresql Everything worked fine. I made database, inserted data etc. Then I rebooted my computer, and postgres did not start. There is ...
0
votes
1answer
44 views

install and load uuid-ossp on PostgreSQL

How can I install uuid-ossp extension on PostgreSQL 9.3? Is it using apt-get install? I did select * from pg_available_extensions; but I found no extensions that relates to uuid-ossp.
3
votes
1answer
130 views

How to run postbooks server in Ubuntu?

I installed post-book accounting software from Ubuntu software center in 14.04 LTS. Also installed post-book demo database and PostgreSQL. But I cannot able to run the post-book server. How can I ...
0
votes
1answer
41 views

postgresql has different version in ubuntu minimal (server)

I bought an vps (virtual private server) and have installed ubuntu minimal (server) 12.04 32 bit on it for openerp use, and one of the openerp requirement is installing the postgresql I installed ...
0
votes
1answer
18 views

What order are config files loaded under linux when there are multiple sources?

I understand the main principle that local configuration files precede global /etc/ configuration files. What I really need though is some more detail on this because sometimes it's not obvious. The ...
0
votes
0answers
126 views

Problems in installation of Postgresql

I got following error while installing postgresql client The following packages have unmet dependencies: postgresql-9.3 : Depends: postgresql-client-9.3 but it is not going to be installed Depends: ...
0
votes
2answers
69 views

user postgres cannot access drive even after permissions and group membership are provided

I have been working on this for the better part of the morning. So I upgraded to ubuntu 14.04 last night, and that went smoothly. But there is an issue with the postgres user and access to my ...
1
vote
1answer
524 views

Starting PostgreSQL server, postgres user unknown

I am trying to start a PostgreSQL server (9.3) on Ubuntu 14.04. I am following this standard tutorial: https://help.ubuntu.com/community/PostgreSQL After updating to from 13.10 to 14.04 I purged the ...
1
vote
0answers
329 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
50 views

Compiling the mysql_fdw for postgresql?

I'm attempting to compile the MySQL Foreign Data Wrapper for Postgresql 9.1+, on Ubuntu 12.04 LTS and having a fair bit of trouble getting it to work. So far I've managed to use git to download the ...
0
votes
0answers
59 views

Problem installing postgresql on ubuntu 12.04 LTS error "cannot find proc/version

I'm trying to install PostgreSQL on my VPS running Ubuntu 12.04. A month ago I success installed Postgresql 9.3 but I forgot the Postgis extension, after I installed the Postgis there come a problem ...
0
votes
0answers
124 views

Failure to install postgresql-plperl-8.4 on Ubuntu 14.04

I have recently had a problem installing postgresql-plperl-8.4 on the new Ubuntu 14.04 distribution. The reason why I am installing older version of plperl is that the server getting upgraded needs to ...
1
vote
1answer
362 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 ...
3
votes
2answers
1k views

postgresql broken after 14.04 despite succesful pg_upgrade [SOLVED]

I'm running an Ubuntu VPS where i'm am upgrading to 14.04. everything has gone smoothly so far. Except the PostgreSQL migration from 9.1 to 9.3. The server hosts a Django 1.6 site and the traceback ...
0
votes
4answers
2k views

PHPPgAdmin not working in Ubuntu 14.04

After a fresh install of Ubuntu 14.04, I've installed postgresql and phppgadmin from the Ubuntu repos. I am using the Apache2 webserver. PHP is working fine in the webserver, as is PHPMyAdmin, but ...
0
votes
2answers
133 views

When will PostgreSQL 9.3 be supported on any version of Ubuntu LTS?

according to http://packages.ubuntu.com/saucy-updates/database/ the latest version of PostgreSQL that's supported in Ubuntu 12.04 LTS is 9.1, specifically the package name is postgresql-9.1 ...
0
votes
1answer
159 views

How to remove a package after incorrect installation attempt

I was trying to install PostgreSQL 9.3 from the downloaded installer: postgresql-9.3.4-3-linux-x64.run Still learning the ropes with Linux, I believe I originally installed it using an incorrect ...
1
vote
1answer
151 views

Postgresql server installation keeps failing due to postgresql-common error

The installation of postgresql server in Ubuntu 12.04 fails. Its seem to be due to incomplete configuration of postgresql-common package. I purged all packages related to postgresql, tried to ...
-1
votes
1answer
41 views

libq-dev fails to install [closed]

When I try to install libpq-dev It fails to install and gives me the folowing error: The following packages have unmet dependencies: libpq-dev: Depends: libpq5 (= 8.4.8-0ubuntu0.10.04) but ...
0
votes
0answers
32 views

Automate backups of multiple Postgresql _CLUSTERS_

I'm looking for a way to automate backing up multiple PostgreSQL clusters. Any thoughts/hints before I do the following? I've already found the autopostgresqlbackup package. Which is a functional ...
1
vote
1answer
39 views

Deploying a specific version of a software from a juju charm?

Suppose I'm using the postgresql charm to deploy my databases. How can I control the version of the PostgreSQL (9.1, 9.2, 9.3, etc) that is deployed? Thank you
0
votes
2answers
812 views

Could not open connection to host (ubuntu server) on port 23, 5432, 3306

I have recently installed few packages for telnet, mysql and postgreSQL. I can access all these service locally on the ubuntu server but somehow I am not able to access these services from other ...
0
votes
2answers
155 views

Trouble with rake db:setup

everyone! 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: ...
1
vote
1answer
54 views

How can I determine the available amount of disk space when using a charm?

When using juju to deploy a DB, how can I determine the available amount of disk space when using the DB charm? Suppose that I'm using EC2 (or anywhere else) to deploy a PostgreSQL/MySQL/WhateverDB ...
2
votes
1answer
450 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?
1
vote
1answer
44 views

Unable to boot ubuntu 12.04 Blank Screen

I install likewise open and connect to sama on some other server when i restart the computer, curser blinks but nothing happens. when I press the power button on the CPU then only screen displayed, ...
0
votes
3answers
3k views

Postgres password authentication fails

I've installed PostgreSQL 9.1 and pgadmin3 on Ubuntu Server 13.10. I configured postgresql.conf with: listen_addresses = '*' also I configured ph_hba.conf by changed peer connections to md5 Plus I ...
1
vote
1answer
82 views

postgresql, how do I connect to it using pgadmin?

I did the following: sudo juju bootstrap juju deploy postgresql juju expose postgresql juju status environment: local machines: "0": agent-state: started agent-version: 1.16.5.1 dns-name: ...
1
vote
1answer
1k 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 ...
1
vote
0answers
46 views

Connecting sublime_text3 editor with postgresql

I am new in sublime_text3. I want to connect my sublime_text editor with my system PostgreSQL in ubuntu12.10. I have tried few plugins but its not working. Any one have any idea how to do that?
1
vote
1answer
277 views

Can't use RStudio any more after trying to set up an ODBC connection to a postgreSQL database

I tried to Setup an odbc connection from R to my PostgreSQL database located on a server (package RODBC). When trying to connect the connection failed because I entered a wrong Username in the DSN ...
0
votes
1answer
725 views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
0
votes
1answer
408 views

“ERROR: role ”$user“ does not exist” when setting up postgresql server

When I tried to follow the "alternative server setup" as detailed here: PostgresSQL, I got the error ERROR: role "$user" does not exist when I ran postgres=# \password $USER and entered my new ...
1
vote
1answer
84 views

Can't select postgresql in libre base

After freshly installing Ubuntu 13.10 (64 bit) and Libre Base 4.1 (using the software center) the selector for PostgreSQL databases is missing. Can't figure out what might be missing. I installed all ...
0
votes
1answer
282 views

Interacting with PostgreSQL on remote server through SSH tunnel?

I have User A setup on my webserver with it's public SSH key copied over to User B's ~/.ssh/authorized_keys over on my database server. The idea is to use an SSH tunnel to facilitate the communication ...
0
votes
2answers
849 views

Postgresql installation on Ubuntu 12.04

I have trouble installing postgresql with apt. postgresql-9.1 (or postgresql-9.3) installation fails with: * Starting PostgreSQL 9.1 database server * Error: could not exec ...
0
votes
1answer
127 views

Cannot connect to PostgreSQL server

I'm trying to set up a PostgreSQL server using the instructions found on here. I installed the package via apt-get install postgresql and now I'm on the step: sudo -u postgres psql postgres which ...