PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.

learn more… | top users | synonyms

5
votes
2answers
2k views

How to install PostgreSQL 9.3 in FreeBSD jail?

I configured virtual NICS using pf, and a jail for FreeBSD using qjail create pgsql-jail 192.168.0.3. When I tried to install PostgreSQL 9.3 using port collection, it shows strange message at first. ...
0
votes
2answers
64 views

many missing dependencies , no links (centOS 7 , postgresql 9.3)

I am trying to install postgresql 9.3 on centOS 7 first , I needed to install libxml2 , and then I tried to install libxml2-devel /$ rpm -iUvh ...
1
vote
1answer
2k views

Kali Linux Postgresql Error

I recently installed kali Linux and keep getting an error code starting metasploit this is the code [...] Starting PostgreSQL 9.1 database server: main [...] Error: could not exec ...
1
vote
1answer
161 views

Change default python distribution for postgres from the system's python (to Enthought Canopy)

On an RHEL6 system, I'd like my postGIS implementation (ie my postgres/postgresql databases) to use Enthought's Canopy distribution of python, rather than the built-in GNU's distribution. (This is ...
0
votes
1answer
68 views

Centos & PostgreSQL - cannot create database cluster

I have a server with CentOS 6. I installed on it postgreSQL 9.4, but didn't tell my mate and he installed 8.4 which included in CentOS by default. So we removed (service remove postgresql) both of ...
0
votes
1answer
47 views

DB Synchronization between main and DR site

I hope I am asking this question in the correct section. I have an environment setup for my application which consists of master / slave Postgresql databases. The master and slave are being ...
0
votes
1answer
549 views

cannot start PostgreSQL on OpenBSD 5.4 through rc.d

I've installed the postgresql-server package on OpenBSD 5.4 amd64, and I try starting it through its rc.d script, however, it doesn't look like it's running after that. opti# /etc/rc.d/postgresql ...
1
vote
0answers
141 views

pgbouncer startup problem

I followed the steps from http://www.guguncube.com/1692/pgbouncer-installation-and-configuration-in-ubuntu for pgbouncer setup. When I start pgbouncer, I get the error Cannot open logfile: ...
1
vote
0answers
1k views

ERROR: Failed to build gem native extension on Arch (postgresql)

I can't install gem pg on Arch due to the error: Gem::Ext::BuildError: ERROR: Failed to build gem native extension. /home/alex/.rvm/rubies/ruby-2.1.1/bin/ruby extconf.rb checking for ...
1
vote
0answers
1k views

Postgresql 9.1 - Kali Linux

I start to read this book : http://www.amazon.fr/Metasploit-The-Penetration-Testers-Guide/dp/159327288X And i have some trouble in using postgresql 9.1 (in Kali Linux). When i start msfconsole, i ...
1
vote
0answers
304 views

PostgreSQL installation error in debian

I'm trying to install PgSql in the system with following specs: Distributor ID: Debian Description: Debian GNU/Linux 7.1 Release: 7.1 x86_64 But I am getting an error like this The ...
1
vote
0answers
57 views

Add Solaris utf-8 support for Postgresql

I need to use utf-8, but "locale -a" produces: C POSIX iso_8859_1 the os is: SunOS cteraportal 5.11 NexentaOS_134f i86pc i386 i86pc Solaris Additional info: root@cteraportal:~# dpkg -l locales ...
1
vote
0answers
360 views

Passing escape sequences to shells within ansi-term in Emacs

In a regular terminal (e.g. iTerm2 on OS X) I can connect to a database, e.g. > psql .... and then, as I type my command in psql, e.g. $ select foo from bar I can move around (as I type psql ...
1
vote
0answers
138 views

Postfix, postges courier-imap / relay reject error on gentoo

I followed a guide to put together a server https://wiki.gentoo.org/wiki/Complete_Virtual_Mail_Server it went smooth with no real headaches. First domain works like a champ but adding a second domain, ...
1
vote
0answers
176 views

Firewall config prevents hibernate connecting to postgres in CentOS6.3

I have an operating environment in CentOS 6.3 that has tomcat7 and postgres9.2 installed. There is just one web application deployed in tomcat that tries to establish a connection from localhost to ...
1
vote
0answers
1k views

“No PostgreSQL user name specified” - possible concurrency issues?

For my dissertation I'm running the same cronjob on around 300 machines, which is: 10,25,40,55 * * * * /path/to/db_script.sh 1>/dev/null This script gets some values from the system (whether ...
0
votes
0answers
20 views

can't run pgadmin3 on fedora22

i installed postgresql and pgadmin. when i try running pgadmin this is what i get: Warning: Mismatch between the program and library build versions detected. The library used 2.8 (no ...
0
votes
0answers
83 views

problem installing postgresql (opengeo) on fedora 22

I'm following the directions found at http://suite.opengeo.org/4.1/installation/redhat/install.html i created gedit /etc/yum.repos.d/OpenGeo.repo with the following text: [opengeo] name=opengeo ...
0
votes
0answers
153 views

Why does PostgreSQL 9.4 on CentOS7 not run via the `systemd` service file on boot?

As root, if I change to the postgres user with su -l postgres then run /usr/pgsql-9.4/bin/pg_ctl start -D ${PGDATA} -s -w -t 300, PostgreSQL starts successfully. As root, if I run systemctl start ...
0
votes
0answers
293 views

Centos 7, Postgresql 9.4 Failed to Read Permission Data Directory in mounted Partition

I've a problem with start PostgreSQL 9.4 on Centos 7 Server. Because the partition /var/lib/pgsql/9.4/data/ (which contains PostgreSQL data is full) so I want to change to another partition. ...
0
votes
0answers
170 views

PgBouncer is running, but cannot connect

PgBouncer started using pgbouncer -d -v pgbouncer.ini. pgbouncer.log file: Actually, every line in this file begins with a date/time stamp of 2015-01-19 11:37:46.415 (first 7 lines) or 2015-01-19 ...
0
votes
0answers
49 views

PgPool - Host Based Routing

I'm using pgpool to distribute my connections between my master and slave postgresql databases. What I would like to know is if there is a feature where I can tell pgpooler to route connections ...
0
votes
0answers
252 views

Postgresql 9.3 with posgis extenstions not working after restart

I'm running Mint 16. In pgAdmin it gives me this output. An error has occurred: ERROR: could not load library "/usr/lib/postgresql/9.3/lib/postgis-2.1.so": libjson.so.0: cannot open shared ...