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)

3
votes
1answer
2k views

Postgresql Provided user name and authenticated user name do not match

I am trying to get tinyRSS running on my own server using PostgreSql. However I keep getting this error: LOG: provided user name (tinyrss) and authenticated user name (apache) do not match FATAL: ...
3
votes
1answer
354 views

Virtual users in sshd from a postgres database

I have a Postgresql database full of user accounts, and i would like to allow these user to access a server through ssh, using only public keys authentification. So far, i have setup these parts on ...
2
votes
1answer
367 views

Postgres Restore Not Restoring Binary Data

This is a very urgent situation. We have a postgres 9.4 database installed on a CentOs machine. We are trying to take a backup from a Heroku Postgres database and restore it to the database on ...
2
votes
1answer
304 views

nodejs postgresql database connection string

Is there a way where I can specify(include) both the master and slave server in nodejs db (postgresql) connecetion string in a replicated envirnment? My aim is 'if master is down then the read/write ...
2
votes
1answer
471 views

Postgresql WAL-E - Replication falling behind + can't catch up

Does anyone know how I can have my replications process the WAL segments faster while using WAL-E? https://github.com/wal-e/wal-e I have one master that leverages WAL-E to upload to S3, and I have 6 ...
2
votes
1answer
159 views

High shmmax value in Redhat 6.3

We are using Redhat 6.3 with 30G RAM to host our Postgres server. The (default) shmmax value is 68,719,476,736 In some forums I have read that having an shmmax value larger than the RAM causes ...
2
votes
1answer
1k 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 ...
2
votes
1answer
782 views

Administer postgres from PGAdmin on remote mac using ssh tunnel

I've got PostgreSQL installed on a Ubuntu server and I'm trying to connect to that server using PGAdmin on a remote macbook. I've created an ssh tunnel - macbook:~postgres$ ssh -L ...
2
votes
1answer
334 views

Postgres 9.0 locking up, 100% CPU

We are having a problem where our Postgres 9.0 server occasionally locks up and kills our webapp. Restarting Postgres fixes the problem. Here's what I've been able to observe: First, usage of one ...
2
votes
1answer
134 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 ...
2
votes
1answer
99 views

Any particular vacuum policy to increase performance using Drupal with PostgreSQL?

I'm running Drupal 7 with PostgreSQL as a Q&A (with a lot of nodes inserts/updates and several contrib modules). Do you, dba admins, recommand any particular pgsql vacuum policy on particular ...
2
votes
1answer
138 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
1
vote
1answer
18 views

Running postgres_database.present a second time causes error “has wrong parameters which couldn't be changed on fly”

Running a salt state that looks like the following to create a postgres database for django... django-db: postgres_database.present: - encoding: 'UTF-8' - owner: djangouser - db_user: ...
1
vote
1answer
27 views

Postgresql calculate kernel share memory?

We are running PGSQL 9.2 and following are hardware specs OS: CentOS7 64bit CPU: 24 Memory: 32GB Disk: SSD I want to calculate shmmax/shmall values then what would be the good way? I google it and ...
1
vote
1answer
90 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 ...
1
vote
1answer
289 views

PostgreSQL 9.2 causes CPU utilization to go to 100%

We have a Java EE application (a online digital library portal) with Hibernate 4.3 which connects to a PostGres 9.2 database. Upon load testing with a load of 175 concurrent users logging in and ...
1
vote
1answer
620 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 ...
1
vote
1answer
231 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
593 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
784 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
1k 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
122 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
8k 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
295 views

osm2pgsql - Failed to allocate space for node cache file

it's my first time trying to set up a OSM server. I have been following this tutorial: https://github.com/AnderPijoan/vectorosm (with node why i need to change how the maps are rendered for some ...
1
vote
1answer
2k 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
213 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
797 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
909 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
576 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
1k 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
294 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
355 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
253 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
334 views

Postgres service does not restart after windows server restart

I have postgres 8.3 installed on windows server 2003. The postgres service is not started after windows server restart. Its startup type is automatic. I have to set log on password again in service ...
1
vote
1answer
337 views

SQL Server DBA moving to Greenplum / Postgres on Linux ( Centos ) looking for friendly MS Sql Agent like scheduler instead of CRON

To be honest, I and others are spoiled by Microsoft's SQL Agent. We'd really like to keep properties of SQL Agent : the features, the usable GUI. I searched serverfault for an evaluation of ...
1
vote
1answer
319 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
416 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
348 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
576 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
8 views

XA Connection for PostgreSQL in Weblogic

PostgreSQL supports XA Transactions. I need to use them in my WebLogic 12.1.3.0.0. When I try to create a new generic datasource in the admin console for this I can select 'PostgreSQL' but in the ...
0
votes
1answer
13 views

Setting up Postgres hot standby in AWS

We have a Posrgres 9.5 database running on an EC2 in AWS and we're trying to set up a hot standby. The server has around 3TB of data, so backing up is not a quick task. I initially tried to create a ...
0
votes
1answer
25 views

Upgrading PostgreSQL on EC2 with minimum impact to existing configuration

I have PostgreSQL 9.2 installed on an EC2 instance, with yum install. I now need to upgrade to PostgreSQL 9.4. I've noticed that yum list lists 9.2, 9.3 and 9.4 as completely separate packages, so I ...
0
votes
1answer
76 views

Postgresql Error: could not receive data from client: Connection reset by peer

I try this stack: nginx + uwsgi + django + postgresql, the request can reach to views of django, client show 500 server internal fault, I check postgres log, found the error could not receive data ...
0
votes
1answer
25 views

How to call ftp script from main script

I'm lookign for a way to create backups from several databases and send result files to server in Debian Linux 6 (Sqeeze) from crontab job There are databases named database1 .. database4 Backup from ...
0
votes
1answer
39 views

psql: duplicate GSS authentication request

What does it mean by saying 'duplicate' ? How to troubleshoot this? guest@www:~$ klist Ticket cache: FILE:/tmp/krb5cc_1000 Default principal: user/admin@SOHONET Valid starting Expires ...
0
votes
1answer
15 views

How to start postgresql server with the socket at a different place?

Good morning. The title says it, but let me precise it. I am working with openbsd. The web server is chrooted in /var/www. So the good thing would be that postgresgl place its socket (and the lock, I ...
0
votes
1answer
192 views

Zabbix + pg_monz shows service not running

I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz. I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). ...
0
votes
1answer
31 views

slapd configuration for back-sql: how to traslate examples from slapd.conf to slapd.d

I'm trying to configure slapd with back-sql (specifically postgresql backend). All documents I found (Postgresq LDAP Howto seems to be more complete) are related to old configuration that use ...
0
votes
0answers
302 views

Postgres segfault on Ubuntu 12.04 64

i have a unbelivable problem: Ubuntu server 12.04 64 bit running on Wmware Infrastructure, postgres 9.2 and django connecting via psycopg. Randomly postgres crashes with segfault, si i restart it an ...
0
votes
0answers
209 views

postgres process priority

We've noticed on our CentOS PostgreSQL database servers that every postgres process is no longer running at the default nice priority of '0'. They are running at a lower priority (2). Is Linux ...