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)

2
votes
1answer
11k views

postgres server fails to start, produces no log, how to to troubleshoot? [closed]

I'm starting up a postgres 9.3 instance on a ubuntu 12.04 server : ~# service postgresql start * The PostgreSQL server failed to start. Please check the log output. ...
1
vote
1answer
247 views

What is proper host in PGAdmin for accessing postgresql through firewall

Here is my situation. I have Postgresql installed on a Windows Server on a LAN. I have an IIS web server set up outside the lan. I want to connect to the postgresql database from the webserver. ...
0
votes
1answer
94 views

Install PostgreSQL under a system user other than “postgres”?

I need to run my current Postgresql 9.3 under a system user other than postgres, say admin OR I need to install Postgresql 9.3 with the default user as say admin on Ubuntu 12.04
1
vote
0answers
102 views

Postgresql upgrade between major versions without downtime

Is there any recommended way to upgrade between different postgresql versions (say, 9.2 to 9.3) without downtime?
1
vote
1answer
354 views

Postgresql not listening on the correct port using service command

In my /var/lib/pgsql9/data/postgresql.conf I added port = 55434 and if I start Postgres with /usr/bin/pg_ctl start -D /var/lib/pgsql9/data/ as the postgres user then Postgres is listening to the right ...
3
votes
2answers
1k views

RHEL SELinux blocking Apache access to PostgreSQL

I'm running a Django app that uses PostgreSQL. The server is running RHEL 6.5 with SELinux. I'm having an issue where the Django app can't connect to the DB, and I think it's because SELinux is ...
2
votes
1answer
184 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
849 views

Understanding PostgreSQL disk usage

I'm using 9.1 and have a table called dpi in a database with UTF-8 encoding currently sitting at 18,628 rows. There's a TEXT column in there called foto that holds B64 strings which represent a unique ...
0
votes
1answer
597 views

Pgpool configuration with Liferay cluster

I'm using a Liferay cluster connected to pgpool2 and when I run heavy user activity against the web servers I see a lot of exceptions regarding liferay unable to establish a connection to the DB. ...
0
votes
1answer
364 views

PostgreSQL 9.1 on CentOS 6.5 - recovery.conf causing process exit with error code

I did setup streaming replication on the Ubuntu 12.04 LTS with rsyncing of the WAL files in case of failure. Now I was trying to do the same on the CentOS 6.5. To do this I've added official RPM from ...
3
votes
2answers
3k views

I have multiple PostgreSQL servers installed. How do I disable auto boot for older server?

I'm running Ubuntu 12.04 on Oracle VirtualBox. A couple months ago, I installed PostgreSQL server version 9.1 on my machine. Just recently, I learned that PostgreSQL server 9.3 supports JSON data ...
0
votes
1answer
260 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
539 views

postgresql - Approach for 'live'/hot file backup?

Forgive me for the ignorant question, but I see postgres has their WAL logs, and there are talks about using filesystem snapshots, and the WAL with the snapshots may or may not be sufficient ...
5
votes
2answers
6k views

PostgreSQL ERROR: no more connections allowed

How do you free up PostgreSQL connections that aren't properly being closed by client applications? I have a data-mining app that spins up multi processes, all connection to a local PostgreSQL 9.1 ...
0
votes
1answer
138 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 ...
1
vote
3answers
1k views

Completely reset PostgreSQL to default?

Question Is there a way to completely reset a PostgreSQL installation on Linux, so it is in the same state as when I installed it? Idea I have considered rm -rf /var/lib/pgsql/* rm -rf ...
3
votes
1answer
588 views

Tuning Postgresql on a 16GB Linode VPS

I'm running a dedicated PostgreSQL on a 16GB Linode (Ubuntu 12.04 32bit). I've tried using pgtune, but I'll run into shared memory errors. I.e. The PostgreSQL server failed to start. Please check the ...
1
vote
3answers
391 views

How can I determine PostgreSQL's port without root and make it listen to a port?

I currently have a Python script that needs to fetch some data from a PostgreSQL database. It currently works fine, but I have to move the script to another server B. The PostgreSQL database will ...
3
votes
1answer
272 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 ...
0
votes
1answer
230 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
986 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 ...
2
votes
1answer
352 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 ...
1
vote
1answer
150 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
1k 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 ...
0
votes
0answers
1k 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
530 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
75 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 ...
1
vote
2answers
1k 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
39 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
59 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
212 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 => ...
1
vote
2answers
4k 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
215 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 ...
1
vote
1answer
5k 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
507 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
7k 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
570 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 ...
0
votes
1answer
382 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
898 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
4k 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 ...
1
vote
1answer
309 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
369 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
3answers
2k 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
351 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
92 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
760 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
336 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
279 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
174 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
218 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 ...