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

Dovecot and reconnection to database

I've got a setup with Dovecot using a PostgreSQL backend together with vmm. I usually get messages like this into log: dovecot: dict: pgsql(10.0.0.2): Connected to database mail Based on ...
1
vote
1answer
23 views

PostgreSQL - Out of memory on count group by query

I'm trying to execute the following statement in PostgreSQL database: create table tmp_nodes as select node_id,count(way_id) as count from way_nodes group by node_id; This query fails because the ...
-2
votes
0answers
12 views

Install postgresql 8.4 along with 9.3 on Centos 5

Install Postgresql 9.3.X along with Postgres 8.4.4 on same CentOS box. error: conflicts with older version [root@downloads]# rpm -ivh postgresql93-libs-9.3.1-1PGDG.rhel5.x86_64.rpm Preparing... ...
2
votes
0answers
22 views

Database hangs when using owncloud on nginx php5-fpm postgresql - i think postgres if responsible

I have strange problem with this setup. Strangely it occurs only when using owncloud from one specific computer. Problem is when user click on "Activities" an "document" icons one after another ...
0
votes
1answer
25 views

Apache: Unable to connect to WSGIScriptAlias

I am trying to install istSOS following these instructions from the website: Installation Install PostgreSQL $ sudo apt-get install postgresql postgresql-client postgresql-contrib pgadmin3 ...
0
votes
0answers
17 views

PostgreSQL DB size increasing after restoring the same database backup

This is my batch script to take backup @ECHO OFF d: cd Apps\RemedyStar 9.0 KREMCOS\bin\Debug\PG pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -v -f "C:\Documents and ...
0
votes
1answer
23 views

Using pg_dump when connecting via a service

I connect to my postgres server using psql "service=subscription". How do I use the service with pg_dump? I tried to do the following: pg_dump -h "service=subscription" > /home/fogest/dump.out ...
0
votes
0answers
21 views

psql doesn't allow to input cyrillic symbols

I have a server with postgresql 8.4 installed on it. But when I try to insert some data in russian, for example: UPDATE category set question = '[there should be russian symbols]' WHERE id = 1; ...
0
votes
1answer
12 views

flagstaff_subset is not empty error when using pg_upgrade

sudo -u postgres /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /data/postgres/9.1/main -D /data/postgres/9.3/main -o ' -c ...
0
votes
0answers
29 views

Tons of “invalid command \N” when restoring a dump

I'm following these instructions to upgrade postgres from 9.1 to 9.3: http://www.postgresql.org/docs/9.1/static/upgrading.html When I restore (Step 8), I get a ton of messages like this: ...
-1
votes
1answer
33 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. ...
0
votes
0answers
9 views

Consolidating large table [migrated]

I need some help with a complex query. Table def: Table "public.agent_log" Column | Type | Modifiers ...
1
vote
1answer
33 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
32 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
0
votes
0answers
25 views

PostgreSQL Error: out of memory

I'm trying to run a query that should return around 2000 rows, but my RDS-hosted PostgreSQL 9.3 database is giving me the error "out of memory DETAIL: Failed on request of size 2048.". What does ...
0
votes
0answers
16 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?
0
votes
1answer
23 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 ...
0
votes
1answer
63 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
0answers
18 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 ...
1
vote
0answers
19 views

Efficient storage of messages [migrated]

I am developing a service that relies on users being able to recieve messages that they themselves choose. These messages need to be stored somewhere before they are send for processing. Right now ...
2
votes
1answer
41 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
0answers
44 views

Snort 2.9.2 doesn't see local network traffic any more

I installed Snort 2.9.2 + ACID BASE + Postgresql on Ubuntu Server LTS 12.04 about 5 month ago. Snort host have local IP address 10.0.40.3/24. There is a some hosts in 10.0.40.0 network. After ...
0
votes
1answer
39 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
0answers
13 views

libnss-pgsql logging transaction on screen

I've been configuring a pg database to authenticate user against pam. I installed libpam_pgsql and libnss_pgsql2. After I finish configuring the libnss_pgsql2, creating and editing the nss-pgsql.conf ...
0
votes
1answer
69 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 ...
1
vote
2answers
59 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
13 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
57 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 ...
1
vote
2answers
77 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
38 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 ...
0
votes
0answers
71 views

Postgres 9.3 won't work on Debian 7.1

Hi I am having problems installing postgres 9.3 on debian 7.1. I have added the following: deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main to the file ...
1
vote
3answers
63 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
165 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
52 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
74 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
58 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
102 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
76 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 ...
0
votes
0answers
24 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
28 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 ...
2
votes
1answer
124 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
89 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
157 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 ...
0
votes
2answers
63 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
33 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
88 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
31 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
34 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
34 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
52 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 ...