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
110 views

Understanding parse, bind, execute entries in PostgreSQL logs

I am new to PostgreSQL logging and have a few questions. PostgreSQL is used as a database for a couple of comercial products (both on the same server). This is run on a Windows 2008 R2 server (as I ...
1
vote
1answer
98 views

Remote Postgres Connection

I have followed everything I can find online about how to do this, and as far as I can tell everything is correct- but it's not working. I have a Linux 12.04 server running Postgres 9.1. I can SSH ...
3
votes
1answer
852 views

Postgres replication falling behind - master -> slave, slave, slave

I currently have 1 master server (a) and 3 replication servers (b, c, d) that come directly from the master, the archive_command I use is the following script: https://gist.github.com/Geesu/8640616 ...
1
vote
0answers
243 views

postgresql: invalid authentication method “pam”: not supported by this build

When I try to start postgresql 9.3.1 I receive this in startup log: # cat /var/lib/pgsql/pgstartup.log LOG: could not create IPv6 socket: Address family not supported by protocol LOG: invalid ...
0
votes
0answers
789 views

PostgreSQL log warnings: open temporary statistics file, pgstat wait timeout

We frequently get the following warnings with our Postgresql Database LOG: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device WARNING: pgstat wait timeout ...
1
vote
2answers
268 views

Any issues with filesystem-only backups on PostgreSQL?

I am running my DB server in amazon cloud, and I have the database files on a separate EBS volume. When it comes to backup/restore operations, I found it infinitely simpler to just do a ...
1
vote
0answers
61 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
0
votes
1answer
631 views

Dovecot cannot authenticate through IMAP

I want to setup a mail server with postfix + postgresql and dovecot. At the moment i can send emails to the mail server but i cannot connect to it with my mail client because it says that the password ...
-1
votes
1answer
35 views

Database management [closed]

First of all please forgive me if this question is off the topic. I have a developed social networking site where users can upload photos and update status. I thought of hosting in AWS EC2, but to get ...
0
votes
2answers
49 views

postgres shell keeps hiding the information

When using psql, \d <table> or select * from XXXX, after I exit and go back to shell, the information is not there and I need it to do the next command all the time. This is very very annoying. ...
0
votes
1answer
164 views

puppet gitlab postgresql conflict

I#m trying to setup a VM with postgresql and gitlab. I'm using the following packages: gitlab & postgresql This is my init.pp class { 'postgresql::server': ip_mask_deny_postgres_user => ...
0
votes
1answer
2k views

How to completly remove postgresql from Ubuntu 13.04

I've tried sudo apt-get purge postgresql sudo apt-get autoremove postgresql and sudo apt-get --purge remove postgresql But after this dpkg -l | grep postgres gives me that: pi postgresql-9.1 ...
2
votes
1answer
155 views

Monit “is alive” check of PostgreSQL tends to fail during a run of pg_dump, is there a better way?

I use pg_dump for my primary backup, once every three hours. I also use monit. When monit checks if PostgreSQL is alive during the pg_dump run, it sometimes times out, and restarts postgres. This ...
0
votes
1answer
3k views

pg_dump: [archiver (db)] connection to database failed: FATAL: Peer authentication failed for user “postgres”

I'm trying to backup my Postgres DB to another server but I keep getting denied access. my pg_hba.conf file looks like this: # DO NOT DISABLE! # If you change this first entry you will need to make ...
3
votes
0answers
392 views

UDP Overflow / UDP Drops on Standby Postgres Service

I am stumped trying to prevent an overflowing UDP buffer on a standby Postgres service. Any help would be most appreciated. Essentially a UDP buffer associated with the pg_standby process on my ...
1
vote
2answers
4k views

RoundCube login to local IMAP server failing

I've been following this guide to set up a mail server on my server: http://flurdy.com/docs/postfix/edition5.html The only difference is that this tutorial uses a MySQL database and I've used ...
-4
votes
1answer
312 views

how to install pgsql_pdo? [closed]

I need to install pgsql_pdo but getting this error via root@server5 [~]# pecl install pdo_pgsql root/tmp/pear/PDO/pdo_dbh.c:1139: error: ‘zend_internal_function’ has no member named ...
-1
votes
1answer
248 views

Update 9.3.x minor verison of postgres on Ubuntu 12.04?

What do I need to do to update Postgres to a new minor version? i.e. 9.3.1 to 9.3.2? All the documentation gives is stop the server and install the new binaries. I need more detailed information on ...
1
vote
1answer
649 views

Restore postgres Dump gives Errors: types do not exist

I´ve dumped a Database from an old Ubuntu machine with postgresql 8.4 wiandth postgis 1.5. On a new ubuntu 12.04 I´ve installed Postgresql 9.1 also with postgis 1.5. (created the postgis_template with ...
4
votes
1answer
3k views

Postgresql 9.3 installation fails

I'm trying to install postgresql 9.3 in my ubuntu lucid machine. The problem is that I'm getting this error when running apt-get install postgresql-9.3 => apt-get install postgresql-9.3 Reading ...
0
votes
1answer
221 views

PostgreSQL: WAL files on server are not deleted

Previously, the server was configured to hot_standby master. After a while he began to work alone. I changed the settings according to it, but the amount of WAL files is still growing ... How to get ...
1
vote
1answer
243 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 ...
4
votes
2answers
902 views

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can use cert authentication. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it ...
1
vote
1answer
215 views

One-line backup, compress, scp database file

I support a company with a remotely hosted web site. They use PostgreSQL dbs. I can't write scripts on the remote server, and I don't want to store any backup files on the remote server, but I can ...
-1
votes
1answer
77 views

New puppet master VM counted towards licenses used, old puppet master node made agent no longer responsive

*Using VSphere Client 5.1 Ubuntu precise VM's with Puppet Enterprise 3.3.1 and PostgreSQL 9.3.1 I am utilizing the same postgresql database to manage a new puppet master and I know that the licenses ...
0
votes
1answer
541 views

Migrate to AWS from Linode

Migration to another server is not easy when we have a large database. We want to move our database in Linode to amazon RDS database, i tried to pg_dump and pg_restore and it succeeds but it consume a ...
0
votes
1answer
255 views

Postgres 8.4 stopped working

A windows 7 machine running a Postgres 8.4.x server stopped working properly this morning. The errors are more than strange: The service is not running, according to the services control panel. ...
1
vote
0answers
212 views

Issue connecting to Amazon RDS with stunnel on Windows

I'm trying to set up a local pgbouncer server that then connects using SSL to Amazon's PostgreSQL RDS service. According to pgbouncer's documentation, you need to use something like stunnel to ...
1
vote
1answer
104 views

Is there a way to force PostgreSQL to use the UTF-7 encoding for the connection?

I have a PostgreSQL database which uses an arcane text encoding, and I can't change that. Is there a way tostore text in UTF-7 transparently (for the informed client) so that the database engine ...
0
votes
2answers
145 views

Can I install a PostgreSQL hot standby instance on the same server?

I'm trying to install a second instance of PostgreSQL on a server (Windows Server 2008) that already has it. I've managed to do this with different versions in the past, but in this case I want the ...
0
votes
1answer
93 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
0
votes
1answer
604 views

Cannot use pg_dump, command not found [closed]

I currently have two databases running in production. One a master and the other a slave. I use streaming replication. I'm looking into using pg_dump and sending the file over to amazon S3. I already ...
0
votes
2answers
3k views

CentOS 6 and PostgreSQL - Can't Connect to Port

SOLUTION: it turns out the ORDER of iptables matters. The firth INPUT rule is REJECT all ... which precludes the ACCEPT rule. So I had to use iptables -I INPUT 5 ... to add the rule in the fifth ...
0
votes
1answer
79 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 ...
3
votes
2answers
456 views

pg_archivecleanup not found Postgres 9.1, even though it is installed?

I have streaming replication setup on 2 Postgres 9.1 servers. Everything is ok apart from the archivecleanup. In the logs it says: sh: 1: pg_archivecleanup: not found 2013-11-19 09:17:37 GMT WARNING: ...
2
votes
1answer
94 views

Protect a public-facing PostgreSQL server against abuse

I have a Postgres database containing public information that I'd like to expose to the internet, for anyone to use. What steps can I take to prevent: Excessively expensive queries that could hog ...
3
votes
2answers
100 views

Use database for sudo

I asked a similar question today, about how to authenticate my server users to a postgres database instead of the /etc/passwd file or LDAP, and I got some useful answers there. I figured out that I ...
0
votes
0answers
1k views

Installing PosgreSQL Stack Builder on Windows with a proxy server

I have downloaded and installed PostgreSQL 9.3 (64 bit) on a developer machine running Windows 8.1 (64 bit). This developer machine requires use of a proxy server for accessing hosts external to the ...
3
votes
2answers
374 views

postgresql slave to master table replication

I currently have a few dozen sites pushing data to a central database over VPN with rsyslog. All these records are going into one table (there are roughly 20 - 30 per second being inserted per site). ...
6
votes
1answer
4k views

PostgreSQL timezone does not match system timezone

I have several PostgreSQL 9.2 installations where the timezone used by PostgreSQL is GMT, despite the entire system being "Europe/Vienna". I double-checked that postgresql.conf does not contain ...
-1
votes
1answer
46 views

How to increase the default number of Postgres processes?

Disclaimer: I'm relatively new to Postgres. On my production EC2 DB server, I'm experiencing high CPU usage on two of the five CPUs, ultimately resulting in latency for users of my application. I've ...
-1
votes
1answer
83 views

How to replicate a PostgreSQL database through a firewall?

I have the following requirements for replication: There is a primary server, which does all data modification. There is a secondary server, usable for read-only queries, up-to-date within a minute ...
2
votes
2answers
229 views

postgresql crashes gammu-smsd with encoding error

I am using gammu-smsd on ubuntu 12.04 as my sms-gateway. It scans information from my modem and inserts it into a postgresql database. Apparently, it tried inserting something into the inbox with ...
0
votes
1answer
211 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 ...
0
votes
0answers
204 views

Django + Apache WSGI + pscopg2 + PostgreSQL 9.1 unexpected EOF on client connection

There are two servers I have. One is SQL server, other is Django project server. And sometimes I get too many unexpected EOF on client connection error by postgresql and OperationalError: could not ...
0
votes
1answer
327 views

Proper management of PGPool II

Currently I have a site, with one Postgres database server. It is just for a select number of users (less than ten) but it needs the maximum uptime possible. I would like some kind of automatic ...
1
vote
1answer
510 views

Write hash password to LDAP when creating a new user

I am working on a project with a central user database system. One of the requirements of the system is that there should be only one set of users for all the application. FreeRADIUS and Samba are two ...
2
votes
3answers
946 views

Backup a big PostgreSQL database continually

I have a 20 Tb database in PostgreSQL 9.2 and I have no idea how to efficiently create backups. It's a database that grows a little bit every day and on the 1 of each month it grows about 200 Gb. I ...
0
votes
1answer
790 views

Can't install PG rubygem on Centos

I am attempting to run gem install pg on my Centos VPS but am getting Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native ...
2
votes
1answer
2k views

Change and initialize Postgresql 9.3 default data and log directories on Ubuntu 12.04 LTS

On Azure with Ubuntu 12.04 LTS image, we're trying to change Postgres 9.3 default data and log file paths and also initialize them for the first time on a secondary drive /mnt/pgdata. We've starting ...