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)

1
vote
1answer
158 views

Website performance sluggish - High CPU and Disk Usage

Over the past couple of days my website's performance has been very sluggish, with queries taking a lot of time to execute. My CPU usage hit around 100% 4 times this week. Here is the output of top at ...
1
vote
1answer
253 views

backup postgresql via docker exec

How would you go about taking automatic rotated backups of a postgresql database running inside a docker 1.3 container? I'm mostly interested in the overall approach vs. the details of actual the ...
1
vote
1answer
451 views

CentOS 6.5 on Vmware can't ping Host machine

I have installed a CentOS 6.5 on VMware WorkStation 10 all running on Windows 7 64bit, internet is working fine but I can't ping host machine from CentOS vice vers, it tells me Destination Host ...
1
vote
1answer
801 views

PostgreSQL master constantly demoted by pacemaker with repmgr

I'm in the process of setting up a PostgreSQL 9.2.8 cluster made of 2 nodes, one master, and one slave. I use streaming replication and repmgr 2.0. My platform is RHEL 6.3. Master and slave can be ...
1
vote
1answer
343 views

How do I change the config_file location of a postgresql database for “service postgresql start”?

I had a PostgreSQL 9.1 db that I just upgraded to 9.3 using /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /var/lib/postgresql/9.1/main/ -D ...
1
vote
1answer
115 views

Best PostgreSQL HA strategy for 99% read scenario?

I'm in the process of building out a new PostgreSQL (9.3) environment in which traffic hovers around 99% read. We'll have 2 very powerful machines, connected via 1Gb ethernet. With the multitude of ...
1
vote
1answer
6k views

How do I fix issue causing “incomplete startup packet” log message trying to implement replication in Postgresql?

I've got two cloud servers running Ubuntu 13.04 and PostgreSQL 9.2. I've primarily used this blog post to aid me in setting things up. However, to do the initial database dump to the slave I'm using ...
1
vote
1answer
842 views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
1
vote
1answer
969 views

Postgres's pg_basebackup never finishes creating backup

I'm attempting to move files to another server to setup a slave. I have a database on one Postgres Server and am attempting to create a file-based backup using pg_backup. However, it never finishes ...
1
vote
1answer
1k views

Can't get postgres and kerberos (gss) working together

I am trying to get postgres and kerberos, via GSSAPI, working together. Having trouble at this point. It does not help that I am really a newbie for both technologies. I have both postgres and ...
1
vote
1answer
556 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
1
vote
1answer
173 views

Postgres 9.1 replication - force select operations to specific slave

I've configured postgres stand by replication using 1 master and 2 slaves. Master and slave1 are located in USA datacenter while slave2 is located in a datacenter in London. Is there any way of ...
1
vote
1answer
719 views

Update server version for postgres 9.1.2

I'm trying to run a postgis sql script and I'm running into the following error. Am I correct to say that updating my server version will fix it? If so, how can I go about updating it? I'm on Mac ...
1
vote
1answer
789 views

unable to install postgresql on SLES 10

i am trying to install postgresql-server on a Suse 10 (SLES10 SP2) 64 bit machine with no luck. I followed the link on the postgres website to the place where they maintain the build for SUSE: ...
1
vote
1answer
111 views

Is it possible to load new PostgreSQL libraries without restarting the server?

I need support for the uuid library in my Postgres server (a 64-bit Amazon Linux AMI). I've installed the uuid and uuid-pgsql packages. Is it possible to load the library without restarting the ...
1
vote
1answer
493 views

postgres server works on LAN but not WAN (connection refused)

I'm trying to set up a postgres server, but I cannot access it through the Internet. It works fine on my LAN. Server is just a desktop computer using Ubuntu 12.04 desktop. disclaimer: I am not ...
1
vote
1answer
929 views

Error in osm data data import while nominatim installation

I am doing nominatim installation on my server. I run the following command ./utils/setup.php --osm-file /usr/share/osm2pgsql/planetfile/planet-latest.osm.pbf --all to import the pbf file and Few ...
1
vote
1answer
238 views

Windows server 2008/glassfish/postgres proxy timeout HTTP idle after 120 seconds

Environment: Windows 2008 Server Edition Netbeans 6.7.1 Glassfish 2.1 Apache 2.2.15 for win32 Original problem (almost fixed): The HTTP/1.1 GET method to send data fails if I wait for more than ...
1
vote
1answer
293 views

how to access my lan based postgresql db from my website

We have lan based .Net application with Postgresql 8.1 , now i have task to provide interface on website to read and write two tables on LAN based database I don't know where to start Please help me ...
1
vote
1answer
236 views

pgpool shm_exit(0)

I'm trying to set up pgpool-II on centos-5.4 For whatever reason pgpool-II fails silently when I try to start it up. I can't seem to find a log file in the default /tmp dir or in /var/log. Can anyone ...
1
vote
1answer
268 views

Postgresql with ldaps:/// url on port 636

Is it possible to connect postgres' LDAP authentication to the SSL (ldaps://) port 636 of an LDAP server (eg, openldap)? It appears that it can use StartTLS on the regular 389 port, but is it ...
1
vote
1answer
328 views

PSQL error with restarting postgres in SSL

I set up server.crt, root.crt and servery.key in postgresql (using http://howtoforge.com/postgresql-ssl-certificates for instructions), set ssl = on and restarted the service successfully. However, ...
1
vote
1answer
335 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...
1
vote
1answer
551 views

Load balancing issue with pgpool2 and postgresql-8.3

I'm using the latest release of pgpool2 on Ubuntu 8.04 with postgres 8.3.11. Replication is working great, but none of my SELECT queries are being load balanced to my secondary server. These are ...
0
votes
1answer
7 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
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 ...
0
votes
1answer
69 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
1answer
57 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
1answer
41 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
416 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
781 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 ...
0
votes
1answer
209 views

What this error means in PostgreSQL?

ExecStart=/usr/pgsql-9.4/bin/pg_ctl start -D ${PGDATA} -s -w -t 300 (code=exited, status=1/FAILURE) This error appears after changes in /var/lib/pgsql/9.4/data/postgresql.conf or pg_hba.conf And ...
0
votes
1answer
59 views

Wal-E cron job not executing

I have a cron job setup that is suppose to be running the wal-e backup-push command. The command works fine if manually ran through the command line. As the postgres user of course. So I setup a cron ...
0
votes
1answer
211 views

Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication

I'm trying to setup a 2 Node Cluster with Postresql 9.3 and Streaming Replication. Streaming Replication is successfully configured. Master is listen up and is sending to slave. I can do failover ...
0
votes
1answer
106 views

PostgreSQL queries slower than before?

I am using PostgreSQL 9.3 server on my production server. Everything had been working fine for the past couple of months. But since the past week or so, PostgreSQL seems to have becomes very slow with ...
0
votes
1answer
252 views

Postgres Remote Connection Timeout

I've been reading tutorials extensively to help figure out my problem, but to no avail. I have a Redhat VM that I've installed Postgres on that I'm trying to make available for remote connections. ...
0
votes
1answer
39 views

autocomplete is not working in postgreesql 8.4

I have installed postgresql 8.4.21 in my CentOS 5. But when I fire Select Query is it not showing me any completion if I press TAB key.. database=# select count is it any configuration in ...
0
votes
1answer
291 views

pgpool run and only log one line

I am using pgpool and when I run: sudo pgpool -f pgpool.conf -F pcp.conf -n It just log one line and keep waitting.... : 2014-10-09 13:27:42 LOG: pid 28626: wd_chk_setuid: ifup[/sbin/ifconfig] ...
0
votes
1answer
72 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
62 views

pg_createcluster ssl cert behaviour different for 9.1 and 9.3 on Debian Squeeze

I think i found a bug in pg_createcluster when creating a 9.3 cluster. At first, my configuration: Debian Squeeze with PostgreSQL 9.1 from squeeze-backports and PostgreSQL 9.3 from apt.postgresql.org ...
0
votes
1answer
34 views

A more complex PostgreSQL query log

There are some laws in my country that require me (as a service provider) to have a log which explains which person did what action. Now I know that PostgreSQL has a query log, but I was wondering if ...
0
votes
1answer
123 views

Lots of connections to loopback, could be slowing us down

I'm trying to debug a sudden increase in our load average. I looked at this page to see if we were being DDoS'ed but the standout IP address was the loopback address: $ netstat -ntu | awk '{print ...
0
votes
1answer
465 views

Joomla Extension Uninstall Causes 502 Bad Gateway

We have a VPS with some PHP websites hosted on our Ubuntu 12.04 LTS servers using NGINX. In a Joomla 3 site, when uninstalling an extension that errors out, the page shows an NGINX error page with a ...
0
votes
1answer
242 views

trying to install postgresql-contrib for pg 8.4 in Ubuntu 12.10

I had to do some strange voodoo last year sometime to get postgresql 8.4 installed on a relatively modern ubuntu OS. I had to use 8.4 because the production site is 8.4 and we needed to ensure ...
0
votes
1answer
134 views

Securing the Django web site which is run with Apache mod_wsgi

I have made a website in Django 1.6 with PostgreSQL database which is hosted on Ubuntu 12.04.3 with Apache 2.2.22 and I have recently noticed lots of hacking (probing) attempts from various IPs ...
0
votes
1answer
214 views

High CPU usage in RHEL machine

I have RHEL machine that runs postgres-9.1 database. In a particular time, sar output shows as follows: Refer link for snapshot: http://imgur.com/gKcOhOX,vNwTpwC#0 where as %user is high between ...
0
votes
1answer
879 views

HAProxy pgsql-check error

I use HAProxy 1.5-dev21 to load balance PostgreSQL connections over some read-only Postgresql 9.2 servers. Version 1.5 of HAProxy implements a pgsql-check option, similar to mysql-check. Here is my ...
0
votes
1answer
102 views

removing special characters from pg_hba.conf on windows?

I just installed Postgres on Windows 8 as an experiment. I was trying to edit pg_hba.conf, but somewhere along the line, an editor put a couple of "special" characters at the front of the file. Now ...
0
votes
1answer
278 views

Rails application keeps timing out when attempting to connect to Postgresql DB

I'm hosting a postgresql database on a small windows azure Ubuntu 13.04 VM with a default postgresql.conf. I have a Rails application running on a medium windows azure Ubuntu 13.04 VM. When accessing ...