Tagged Questions

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
1answer
561 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
34 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
46 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
151 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
1k 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
150 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
2k 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
346 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
3k 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
291 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
242 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
608 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
208 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
214 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
810 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
182 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
76 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
513 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
243 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
203 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
92 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
140 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
86 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
539 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
75 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
412 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
87 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
99 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
349 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
3k 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
44 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
81 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
212 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
193 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
195 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
302 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
445 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
844 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
725 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
1k 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 ...
2
votes
1answer
145 views

What is “backup mode” in postgresql?

I am in the process of setting up a standby server for a PostgreSQL 9.3 install. I was looking to use pg_basebackup to get the initial starting point for the standby server. However, the documentation ...
1
vote
1answer
1k views

how to install pg_archivecleanup for postgresql 9.3 on Ubuntu

I am trying to get streaming replication working with postgresql 9.3 on Ubuntu 13.04 (Raring Ringtail). I installed postgresql on master and slave by doing: apt-get install postgresql I believe ...
0
votes
1answer
197 views

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I ...
1
vote
1answer
116 views

Invalid byte sequence for character encoding 0x00 after upgrading from 8.3 to 8.4

I'm trying to upgrade a database from PostgreSql 8.3 to 8.4, I backed up the data from 8.3 and restored from 8.4 without issues, but, when I try to use the same program that is working perfectly ...
1
vote
2answers
113 views

How to disable 1 version of PostgreSQL server without uninstalling it

I have installed PostgreSQL 9.1 and 9.2 on my Ubuntu machine. The postgresql service starts both versions: $ sudo service postgresql start $ * Starting PostgreSQL 9.1 database server [ OK ] $ * ...
3
votes
2answers
995 views

Why doesn't sudo know where psql is?

The problem The CKAN installation documentation shows you how to list the installed PostgreSQL databases. The command looks like this: sudo -u postgres psql -l When I try that in my shell, I get ...
0
votes
1answer
62 views

Postgres - Ship WAL logs from many servers to one

I have a number of independent postgres servers in my (recently inherited) environment and I am planning on backing them up via WAL shipping. I'd like to make one backup server that contains a copy ...