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
3k 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. ...
1
vote
2answers
149 views

Simulate PostgreSQL query timeout

I would like to test the behaviour of a program which executes queries to a PostgreSQL server in case of a query timeout. How could I simulate that?
1
vote
2answers
380 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
2answers
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 ...
0
votes
2answers
174 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
95 views

SSH access asking for password in local network but public

I have a problem when ssh to another server. I created ssh-key and copied it to other server. -bash-4.2$ whoami postgres -bash-4.2$ ssh-keygen Generating public/private rsa key pair. Enter file in ...
1
vote
1answer
91 views

how to update postgres.conf path after relocating it from data directory

I'm installing a Postgresql-9.4 HA environment in RHEL 7, when I initialize postgres db - it creates a data directory and within the data directory goes postgresql.conf & pg_hba.conf files. Here, ...
1
vote
1answer
257 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
16 views

Postgresql error after upgrading database

We recently upgraded POSTGRESQL to 9.4.4 and now when my application tries to run a query I am getting this error. LOGS: 2016-03-15 16:34:51 ERROR http-nio-8282-exec-2:FeedRestController:224 - ...
0
votes
1answer
50 views

Issue with dropping table which contains special char in tablename. (Linux&Postgres)

I am facing issue with DROP table command in Linux (backend : Postgres). I have a table named "prabhu2016-02-08--2016-02-15". when I drop this table using below commend i am receiving error.... ...
0
votes
1answer
174 views

PostgreSQL Remote Connection debugging

I'm having issues connecting to my PostgreSQL database from an online source. PostgreSQL seems to be setup up fine it is running on it's default port 5432 and the postgresql.conf has the following ...
0
votes
1answer
55 views

.sh script error issues

I have a sh script with which I connect to postgres DB and execute a psql command. The script is as shown below: /opt/postgres/9.2/bin/psql pcwh -U pcwhuser << EOF \i ...
0
votes
1answer
155 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
85 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 ...
1
vote
0answers
1k views

Postgresql 9.1 - Kali Linux

I started to read this book : http://www.amazon.fr/Metasploit-The-Penetration-Testers-Guide/dp/159327288X And I have some trouble with postgresql 9.1 (in Kali Linux). When I start msfconsole, I ...
1
vote
0answers
479 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
131 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
163 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
198 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
17 views

Upgrading postgresql to 9.3 on a CentOS 7 machine

I've recently rented a machine, with CentOS 7, to use for a Nominatim server. I've managed to correctly install Nominatim on the machine, with the instructions from the site, it works correctly, but ...
0
votes
0answers
21 views

How to move a postgresql backup dump to an other server with a script?

I have on a ubuntu 14.04 Server some Backup Files from a PostgreSQL Database. How Can I move this with a daily backup script to an other server? I need a script that moves my files in path ...
0
votes
0answers
13 views

How to configure sympa with plesk root access using mysql usename admin@localhost?

I'm trying to use MySql, but username is admin@localhost. It was root but plesk changes it to admin. I also tried PostgreSQL but after it asks for the root password there is another request to access ...
0
votes
0answers
33 views

failure at starting on postgresql

I installed a postgresql database on Redhat 7.1 and I decided to move the database on a ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting ...
0
votes
0answers
29 views

What is the equivalent to this apt-get when installing PostgreSQL extension for acoustid?

On bitbucket, it says to install the extension using sudo apt-get install postgresql-9.X-acoustid. but I'm running on CentOS... when I replace apt-get with yum: $ sudo apt-get install ...
0
votes
0answers
250 views

Pg_dump does not work in Cron

I have the command below and run it succesfully: /usr/lib/postgresql/9.1/bin/pg_dump -U dspace --format=c --file=/dspacebkp/dspace_db_$(/bin/date +\%m\%d\%Y)_uncompressed dspace I can see my new ...
0
votes
0answers
34 views

Installing Ubuntu and PostgreSQL database on different drives

I just received a new root server with the following drives: Disk /dev/sda: 480 Gb Disk /dev/sdb: 480 Gb Disk /dev/sdc: 240 Gb This one: ...
0
votes
0answers
44 views

AWS linux - How could I install postgreSQL on amazon linux?

I'm really beginner. I want to install postgreSQL on Amazon linux. Please let me know what I should type in regular sequence. I saw some of questions about installing postgreSQL on linux, but there ...
0
votes
0answers
23 views

pgbouncer: connections not reused in session pooling

My pgbouncer.ini pool_mode = session server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20 min_pool_size=10 server_round_robin = 1 server_lifetime = 300 When i ...
0
votes
0answers
50 views

Cannot telnet to Postgresql Forwarded Port

I'm trying to portforward a PostgreSQL port using my DLINK ADSL Router. I have the following IP addresses. Public Internet IP 197.321.321.32 PostgreSQL 192.123.123.12:5432 (Port To ...
0
votes
0answers
25 views

Apache PostreSQL database server only

I was wondering if it's possible to use apache to make a postgresql database available for connections from the web without using a website to interface with the database. Instead of having a webpage ...
0
votes
0answers
32 views

I have error in postgresql service

Today I would like to test my metasploit. So, first I run service postgresql start, so here problems: root@localhost:/# service postgresql start [....] Starting PostgreSQL 9.1 database server: main ...
0
votes
0answers
23 views

How to make roundcube work with pgsql?

roundcube & pgsql are running on different containers docker run --name to-postgres --expose 5342 -e POSTGRES_USER=roundcube -e POSTGRES_PASSWORD=roundcube -d postgres Now how shall I install ...
0
votes
0answers
152 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
232 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
278 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 ...