PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX ...

learn more… | top users | synonyms (1)

0
votes
0answers
7 views

pgpool2 stucks in “idle in transaction”

We have a setup with two postgresql servers configured as master-slave (streaming replication). The application servers (Odoo) should connect through pgpool2. All is fine if I connect the application ...
-3
votes
0answers
12 views

Unattended solution for installing postrate? [on hold]

i need unattended solution for installing postrate I want to install postgre through bat file on single click in window system. I don't want to put and login cridetial on command prompt that should ...
0
votes
1answer
10 views

How to export a Heroku-friendly Postgres dump from Ninefold?

I am trying to migrate my postgres database from ninefold to heroku. The command I'm using to export is: PGPASSWORD=password pg_dump -h ipaddress -p port -U user -d database -Fc --no-acl --no-owner ...
0
votes
1answer
7 views

Downsides to indefinite replicate streaming delays?

I have a db server that's sole purpose is for analytics querying. It's running as a hot standby, but long running queries are failing due to max_standby_archive_delay and max_standby_streaming_delay ...
0
votes
0answers
12 views

apache2 mod_dbd and postgresql

I'm trying to rewrite url using dbd. Everything looks ok, except few things: It doesn't work It doesn't show any error (LogLevel Trace8) It doesn't show any connection to database (postgresql.log ...
1
vote
0answers
8 views

Does a PostgreSQL hot standby cache streamed WAL segments?

If pg_xlog_replay_pause() is used or max_standby_streaming_delay is set, are unapplied WAL segments stored on the hot standby? I'd like to be clear if a long-running query is keeping WAL segments ...
1
vote
1answer
45 views

Why would updating postgresql-client uninstall postgresql?

On a Debian 7 server, apt-get was offering me to upgrate the following 2 packages: postgresql-9.1 and postgresql-client-9.1. Since I didn't want to restart the database server, I decided only to ...
0
votes
0answers
36 views

After upgrading to PostgreSQL 9.4, unable to connect from localhost

I have recently upgraded from Debian 7 to Debian 8 and from PostgreSQL 9.1 to 9.4. I am not able to connect to my database server even from pgAdmin III on localhost. I have in my postgresql.conf the ...
1
vote
0answers
34 views

Postgres streaming replication over Internet

all: I want to set up two PostgreSQL servers, one as master server and the other one as a hot standy, using streaming replication. I have done this before in LAN environments, but I would like to ...
0
votes
1answer
20 views

Can't access remote PostreSQL

I just moved my office and now I can't get to PostgreSQL on my Windows web server. I changed the pg_hba.conf file to the new IP address. I made no other changes to the server or my computer. One ...
8
votes
1answer
235 views

su: /bin/bash: Resource temporarily unavailable

Unable to switch user to postgres. Ulimit settings for postgres user is set with reasonable limits. We are not hitting max. No errors in /var/log/messages. Error: BETA -bash-4.2# sudo su - ...
4
votes
1answer
44 views

PostgreSQL limiting connections to fewer than max_connections?

I have a PostgreSQL 9.4 server that seems to be limiting connections to fewer than what I have defined in max_connections. I have max_connections set to 300. SHOW max_connections; max_connections ...
0
votes
0answers
3 views

PostgreSQL 9.0 live migration/replication with native/bucardo between multiple architectures [migrated]

I'm writing here because I'm in desperate need of a stable and good solution for resolving a issue we are facing. We have an old PostgreSQL server running on RHEL 4 i386 with PostgreSQL 9.0 ...
0
votes
0answers
38 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
1
vote
1answer
22 views

Changing tablespace on table with streaming replication

I've been searching for answers for a while know but can't find any reliable source. We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a ...
0
votes
0answers
14 views

openshift gear borks and restarts

I have a Django application on Redhat OpenShift that uses a postgresql database. I use the free plan with 1 small gear using: Python 2.7 PostgreSQL 9.2 For a certain command I get thrown out from ...
0
votes
0answers
27 views

How to configure PostgreSQL password? on a new VM

I installed my postgresql like this. sudo apt-get update sudo apt-get install postgresql postgresql-contrib and accessed it like this sudo -i -u postgres and my a gist of my pga_hba.conf # DO ...
0
votes
1answer
73 views

start postgres 9.4 server from Windows commandline [closed]

I am trying to start the postgres erver from the Windows command line but it keeps failing with the same error: 2015-04-14 10:25:19 GST LOG: could not bind IPv6 socket: No error 2015-04-14 10:25:19 ...
0
votes
1answer
20 views

Postgres protected access

I am trying to configure my Postgres instance so that only the local machine and my machine (over internet) should be able to access the database. The postgresql.conf file has parameter ...
0
votes
1answer
44 views

PostgreSQL - SQLSTATE[22007]

I have a box running Debian Wheezy, It is only used to operate Airtime (Icecast, LiquidSoap) It was working fine, after loading some more data into folders and editing WATCHED FOLDERS, I am getting an ...
-1
votes
1answer
111 views

Migrate OTRS database from PostgreSQL to MySQL

OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
0
votes
1answer
75 views

Migrate data from postgresql 8.4 to postgresql 9.4 in 2 different servers

I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in ...
0
votes
0answers
12 views

Postgres 9.3 maximal cluster size with streaming replication [duplicate]

First, I quote from https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial: In Streaming Replication, the master and the standby have special processes called the walsender and walreceiver ...
0
votes
1answer
59 views

Syslog-ng and Logrotate creating sparse files

We've been using syslog-ng to log our postgres logs. On top of it we run logrotate every 5 minutes which also gzips the files. Recently, we've noted that these postgres logs contain a lot of null ...
0
votes
0answers
72 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
1
vote
1answer
61 views

The more threads the less IOPS?

I've just started trying out AWS. I have a Postgres micro instance on RDS and I'm running a crawler on a c4.large. When I have just one spider (one thread), I get about 10 write IOPS. but if two ...
1
vote
0answers
41 views

Monitoring maximum number of locks in PostgreSQL with Nagios

I'm wondering if the limit for the number of locks in PostgreSQL is fixed, or if it depends on the number of open connections. The docs say the limit is max_locks_per_transaction * (max_connections + ...
0
votes
1answer
68 views

Does PostgreSQL perform on Windows as well as on Linux

This topic was brought up in 2011, and the consensus was that there were design considerations that would give PostgreSQL a leg up on Linux. It is now 2015, has that changed? If there are things that ...
0
votes
1answer
113 views

Support for Postgres broken in HHVM 3.6.0

I keep getting Uncaught exception: Could not open extension /etc/hhvm/extensions/pgsql.so: /etc/hhvm/extensions/pgsql.so: undefined symbol: _ZN4HPHP13PDOConnection5sweepEv When I try to start up ...
0
votes
1answer
44 views

Reduce the size of main/base mysterious buildup

Using PostgreSQL 9.3. I had a long-running query updating around 8M rows. Something obviously went wrong. 2 days later I got a low disk space alert. I stopped the query and this is what I saw. ...
0
votes
1answer
21 views

Postgres replication via different interfaces

I have one PG master server that replicates itself to one slave server. Also I would like to replicate this master to slave that is in another network. Master has 2 interfaces, and there are ...
0
votes
0answers
43 views

PHPPGAdmin on Windows - authenticate users against Active Directory

I installed PHP, Apache 2.4, and PostgreSQL 9.4.1 on Windows machine which belongs to Windows domain. My pg_hba.conf: hostnossl all postgres 127.0.0.1/32 md5 hostnossl all all ...
18
votes
3answers
270 views

Risk of starting NTP on database server?

I've heard rumors of bad things happening to database and mail servers if you change the system time while they are running. However, I'm having a hard time finding any concrete information on actual ...
0
votes
0answers
182 views

HAProxy tcp load balancing with an https check fails

I'm trying to load balance a posgres tcp connection, with a node check done via a python script residing on an https connection. conf file looks like so: global log 127.0.0.1 local2 ...
0
votes
0answers
26 views

Connect to posgresql, WAN, settings

I´m working and reading on how to build up a postgresql-server. So far I´ve set it up and works smooth on my LAN. Now I want to access it from others computers on the internet. I´ve been reading here ...
0
votes
0answers
74 views

PostgreSQL 9.2/9.3 Streaming Replication Failback

I'm setting up a postgresql 9.2 streaming replication pair and writing up some documentation for failback after the secondary has been promoted. The official line seems to be that a full data dump of ...
0
votes
1answer
76 views

VPS policy states CPU usage limitations

I have found a cheap vps solution to cover my needs. Reading through the policies of the vps service, I found that they state "CPU usage should not exceed 70%". Is there a way to prevent this? I plan ...
2
votes
2answers
138 views

Debugging a Postfix Saslauthd PAM-PGsql authentication failure

I've set up pam-pgsql to lookup passwords in my database for Postfix via Saslauthd. I can test credentials using the command line: $ sudo testsaslauthd -u user@email.com -p password 0: NO ...
3
votes
1answer
113 views

Best way to RAID 4 x Intel SSD 910 for PostgreSQL

I have a Linux (debian/ubuntu) server with 4 x Intel SSD 910 800GB pcie that I need to RAID together. The biggest problem with these card is that they give you 4x200GB drives that you cant ...
1
vote
1answer
306 views

Zabbix cannot connect to a PostgreSQL database

First off I am running CentOS 6.5 and attempting to use Zabbix 2.2.4. Any hostnames have been replaced with examples. I have installed the following RPMs onto my Zabbix machine ( hostname will be ...
1
vote
1answer
35 views

How do I know if Postfix has MySQL/PostgreSQL support?

I'm not sure if my Postfix installation has MySQL or PostgreSQL support. How do I find out?
0
votes
0answers
91 views

Gitlab update from 7.2.0 centos(mysql) to 7.7.2 ubuntu(postgres), can't create ssh key, or new project

I had a CentOS server running gitlab 7.2.0, which uses mysql server. I updated to the omnibus version of 7.7.2 successfully porting the database from mysql to postgres using instructions found here ...
1
vote
1answer
79 views

Install i686 postgres libraries on 64 bits CentOS7

I am trying to get a i686 compiled binary to run on my x86_64 CentOS7 install. When starting it complains it cannot find (dynammically load) the libpq library. I tried installing the i686 Postgres ...
1
vote
1answer
55 views

How to specify a client certificate to psql?

I have a Postgres server with a user dev which requires a client certificate to log in. I'm using the command psql "sslmode=require user=dev host=db.prod", which gives me psql: FATAL: connection ...
0
votes
1answer
36 views

Where should the DB server be and its updates scripts should run from where?

I currently have a web application and database on the same server. I am moving the database to a new server that is spec'd for being a database. Now i have nightly scripts that run on the web ...
0
votes
1answer
66 views

How can I select one of multiple PostgreSQL in my CentOS server? [closed]

I had postgresql 8.4 in centos system. Aadditionally I needed postgresql 9.3. I want new version, But excute 8.4 version instead 9.3 version. How can I change default version?
1
vote
1answer
423 views

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm ...
0
votes
0answers
125 views

Installing PostgreSQL on Centos 5

I'm following the instructions from here. I try and run yum localinstall http://yum.postgresql.org/9.4/redhat/rhel-5-i386/pgdg-centos94-9.4-1.noarch.rpm which returns the fault cannot open file... ...
0
votes
1answer
437 views

What could cause “idle in transaction” in a pentaho pdi process?

I am running an ETL process using cron on a daily basis on my server every 2 hourly. The ETL process populates a reporting database which runs Greenplum. I have noticed that the ETL process normally ...
0
votes
1answer
811 views

ERROR: could not open extension control file “file_path”: No such file or directory

Using mac OSX Yosemite 10.10.1. I uninstalled and re-installed both postgres and postgis with homebrew. I understand that postgres is looking in the wrong place for the postgis control file. Also ...