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
votes
1answer
20 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
0answers
15 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 ...
1
vote
0answers
13 views

Search results mismatch after postgresql update

Today we had to update the PostgreSQL version on our database servers. Before update the version was 9.3.4 and the new one is 9.3.6. Despite the small difference in the database version and the ...
0
votes
0answers
11 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
0answers
12 views

Display only table names in psql [migrated]

How can I print only table names from a specified database in psql? That is, if I have tables called "table1" and "table2" then the output will be: table1 table2 and only that. I've been trying ...
0
votes
0answers
17 views

Stop PostgreSQL from logging statements on error [migrated]

My postgresql 9.3 logs are sprinkled with entries like these (redacted to protect the guilty): STATEMENT: INSERT INTO table (key, value) VALUES ($1, $2) ERROR: duplicate key value violates unique ...
0
votes
1answer
30 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
32 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
49 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
29 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
44 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
63 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
24 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. ...
-3
votes
0answers
60 views

Error while installing PostgreSQL PHP PDO driver, at running ./configure

I have found a tutorial, installing PostgreSQL's PDO driver on PHP. I couldn't do without a tutorial, because yum and other repo's couldn't find required pdo packages. It starts with wget ...
0
votes
1answer
16 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
27 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
217 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
77 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
21 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
45 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
39 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
77 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
97 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
116 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
28 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
72 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
52 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
26 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
32 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
56 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
160 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
88 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
154 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
424 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
109 views

Importing Data Dump Using pgAdmin

I looked around and found the following code on how to import a data dump using pgadmin: CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$ tables RECORD; gmdeclare statement ...
0
votes
0answers
23 views

How to change username on RDS instance

I have a single RDS postgresql instance with username 'psql' owning the database. How do you change the username?
0
votes
1answer
176 views

postgresql LDAP authentication

I am trying to give an LDAP authentication to my postgresql database. Here is my pg_hba.conf config file local all all md5 local all postgres md5 host all all 0.0.0.0/0 ldap ...
0
votes
0answers
30 views

Is it possible to do an Online Index Rebuild in Postgresql

Is it possible to do an Online Index Rebuild in Postgresql or is your only option to do a drop and recreate? Thank you.
0
votes
1answer
43 views

Secure Database Password Contained Inside a File

I've got a Linux based application (Java) that connects to an external database (PostgreSQL) in the same LAN. However, due the sensitiveness of the database contents I would like to avoid the admins ...
1
vote
1answer
112 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 ...
1
vote
1answer
96 views

How to apply PostgreSQL “GRANT ALL ON ALL TABLES” to new tables?

As discussed in the question at GRANT SELECT to all tables in postgresql, as of PG 9.0 you can mass-grant privileges on all existing tables to user u, using a command like: GRANT ALL ON ALL TABLES IN ...
1
vote
1answer
190 views

unable to connect to public postgresql rds instance

I created a basic test PostgreSQL RDS instance in a VPC that has a single public subnet and that should be available to connect over the public internet. It uses the default security group, which is ...
1
vote
1answer
115 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 ...
0
votes
0answers
153 views

PostgreSQL failed to start. unable to load private key file << server.key >> : key values mismatch

I am trying to install PostgreSQL on my Linux Debian 7.2 server but it fails. this is what I did : user ~ $ sudo apt-get install postgresql Lecture des listes de paquets... Fait Construction de ...
1
vote
1answer
217 views

How do I link a security group to my AWS RDS instance

I have a postgres db setup on RDS. It is running great. However, I want to link this to a set of autoscaled EC2 instances sitting behind an ELB that all reside in a single EC2 security group. I've ...
0
votes
1answer
94 views

AWS RDS Postgres Upgrade without losing data

I currently have a Postgresql v9.3.3 running on AWS RDS. I've learned that if I upgrade Postgres to 9.3.5 that I can create read replicas. However, I am afraid of losing data. Can I just select ...
0
votes
1answer
138 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
votes
1answer
64 views

I cannot change privileges for folder with chmod on CentOS

On CentOS 7 server for the folder /var/lib/pgsql/9.3/data/ I do: sudo chmod -Rf 755 /var/lib/pgsql/9.3/data/ But it doesn't change privileges for folder. But sometimes it changes for 10-15 minutes. ...
0
votes
0answers
60 views

Postgres on OpenSuse doesn't start after update

I tried to upgrade OpenSuse from 12.1 to 13.1 and after 'zypper update' and reboot Postgresql doesn't start. Here is the output of service postgresgl status: postgresql.service - LSB: Start the ...
1
vote
0answers
130 views

Unable to perform replication in Bucardo in a Master-Slave setting

When I was trying to perform replication from Master to Server, the replication was able to run on the Master server, but the table in the slave database did not receive and apply the changes. ...