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
vote
1answer
397 views

postgres server works on LAN but not WAN (connection refused)

I'm trying to set up a postgres server, but I cannot access it through the Internet. It works fine on my LAN. Server is just a desktop computer using Ubuntu 12.04 desktop. disclaimer: I am not ...
1
vote
1answer
185 views

Windows server 2008/glassfish/postgres proxy timeout HTTP idle after 120 seconds

Environment: Windows 2008 Server Edition Netbeans 6.7.1 Glassfish 2.1 Apache 2.2.15 for win32 Original problem (almost fixed): The HTTP/1.1 GET method to send data fails if I wait for more than ...
1
vote
1answer
255 views

how to access my lan based postgresql db from my website

We have lan based .Net application with Postgresql 8.1 , now i have task to provide interface on website to read and write two tables on LAN based database I don't know where to start Please help me ...
1
vote
1answer
207 views

Postgresql with ldaps:/// url on port 636

Is it possible to connect postgres' LDAP authentication to the SSL (ldaps://) port 636 of an LDAP server (eg, openldap)? It appears that it can use StartTLS on the regular 389 port, but is it ...
1
vote
1answer
272 views

PSQL error with restarting postgres in SSL

I set up server.crt, root.crt and servery.key in postgresql (using http://howtoforge.com/postgresql-ssl-certificates for instructions), set ssl = on and restarted the service successfully. However, ...
1
vote
1answer
321 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...
1
vote
1answer
526 views

Load balancing issue with pgpool2 and postgresql-8.3

I'm using the latest release of pgpool2 on Ubuntu 8.04 with postgres 8.3.11. Replication is working great, but none of my SELECT queries are being load balanced to my secondary server. These are ...
0
votes
1answer
12 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
12 views

pg_createcluster ssl cert behaviour different for 9.1 and 9.3 on Debian Squeeze

I think i found a bug in pg_createcluster when creating a 9.3 cluster. At first, my configuration: Debian Squeeze with PostgreSQL 9.1 from squeeze-backports and PostgreSQL 9.3 from apt.postgresql.org ...
0
votes
1answer
21 views

A more complex PostgreSQL query log

There are some laws in my country that require me (as a service provider) to have a log which explains which person did what action. Now I know that PostgreSQL has a query log, but I was wondering if ...
0
votes
1answer
38 views

Lots of connections to loopback, could be slowing us down

I'm trying to debug a sudden increase in our load average. I looked at this page to see if we were being DDoS'ed but the standout IP address was the loopback address: $ netstat -ntu | awk '{print ...
0
votes
1answer
78 views

Postfix with Pgsql support

I'm trying to find an alternative repo with postfix that has pgsql support on Cenots 6. I previously used CentAlt but since that seems to be dead now i'm trying to find an alternative. I would ...
0
votes
1answer
113 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
83 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
1answer
88 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
439 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 ...
0
votes
1answer
438 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 ...
0
votes
1answer
757 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 ...
0
votes
1answer
65 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 ...
0
votes
1answer
156 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
1answer
147 views

Postgres fails to start, pg_clog fails

Recently one of the machines running Postgres ran out of disk space. After deleting some trashes (not related in any way to postgres!) I've rebooted the system, and - after that - Postgres refuses to ...
0
votes
1answer
52 views

Sed issue with numbers exceeding 9

May be my problem is kinda obvious for you but I really need to get a solution. I need to generate a file.sql file from a file.csv, so I use this command : cat file.csv |sed "s/\(.*\),\(.*\)/insert ...
0
votes
1answer
603 views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
0
votes
1answer
145 views

In Mac OS ,Postgres after changing data folder location . Unable to start Postgres database . it doesnt give any error

I'm trying to use Postgres on a Mac. After changing the location of the data folder, postgres didnt start. It doesnt give any error message. I've copied the data folder from another location, and ...
0
votes
1answer
53 views

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let ...
0
votes
1answer
114 views

GRANT/REVOKE on functions

I am using the has_function_privilege, to check and see if a certain user can access a function in my database. However, if I use REVOKE to revoke access, has_function_privilege still returns true: ...
0
votes
1answer
312 views

Facing authentication error on postgres 9.2 -> dblink functions

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows: SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 ...
0
votes
1answer
464 views

PostgreSQL fails on boot, but works fine after logging in

I'm not sure if my problem started after update. I'm running Debian Squeeze and postgresql-8.4(8.4.12-0squeeze1). On startup or after reboot, I noticed that my PostgreSQL database service fails. ...
0
votes
1answer
124 views

PostgreSQL 9.1 won't restore because “a user is connected”

I'm transferring a database as part of transferring a website. I've not used PostgreSQL before, so assume that I don't know much about it (I primarily use MySQL). We cannot directly connect the ...
0
votes
1answer
427 views

PHP script times out after 60 seconds on Apache

An old site I've inherited has a script that users can run from the CMS that basically pulls out all the products from the database table and exports them as a xls file. There aren't that many ...
0
votes
1answer
769 views

Error in osm data data import while nominatim installation

I am doing nominatim installation on my server. I run the following command ./utils/setup.php --osm-file /usr/share/osm2pgsql/planetfile/planet-latest.osm.pbf --all to import the pbf file and Few ...
0
votes
1answer
155 views

ERROR: function make_standard_name(unknown) does not exist while installing OSM-nominatim API

I am installing nominatim on my own server using the guidence of http://wiki.openstreetmap.org/wiki/Nominatim/Installation... But I am facing problem while adding country phrases / codes to my pgsql ...
0
votes
1answer
396 views

Installing multiple instances of postgres on suse

Is there a HOWTO out there somewhere that explains how to install multiple instances of Postgres on a SUSE server? Im building a test environment and need to have about 2 or 3 instances of postgres ...
0
votes
1answer
600 views

postgresql unable to start

postgresql log file: * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output: 2012-02-24 04:26:07 GMT ...
0
votes
1answer
197 views

restore data from backup from file in postgres

I need to restore data which is there in .backup file from /home/somepath/backupfile.backup to mydb.I tried with following psql dbname < infile but it is not restoring data it gives an error says ...
0
votes
1answer
98 views

Is it possible to set a default column value in PostgreSQL using an external non-SQL function?

For example, say I wanted to have one column take the row id and run it through a Python script which returns some information related to that number (random example). Would I need to manually ...
0
votes
1answer
626 views

call multiple Sql files in a single SQL file in Postgres

How do call multiple sql files in a single sql file, in postgres For example I have aaa.sql, bbb.sql, ccc.sql. I want to execute this 3 files from xxx.sql. Can anyone suggest me how to do this.
0
votes
1answer
70 views

Execute SQL statements automatically after Postgresql service starts

Would like to setup Postgresql 8.3 and above on Windows to automatically execute a series of SQL statements after the server has started. Can't seem to find any information. Any ideas ?
0
votes
1answer
343 views

Can't get postgresql running from Homebrew with Lion

I'm new to unix and having trouble running initdb with postgresql. I installed postgres via homebrew with "brew install postgres", and have attempted to run the initdb command as follows: initdb ...
0
votes
1answer
119 views

Postgresql Service Start Fail How I Can Backup My Database - Cenos

I Use Centos 5 and boot from linux rescue PostgreSQL Fail on start and I need my database on Postgresql How I can backup postgresql database without use service (copy database files and ...) thanks
0
votes
1answer
444 views

Issues installing postgresql with homebrew OS 10.6.8

I'm having issues installing postgresql with homebrew on my MBP running OS 10.6.8. It finishes sudo brew install postgresql without any issues. When I try: initdb /usr/local/var/postgres ...
0
votes
1answer
255 views

VMWare Fusion 4.0 + Postgres

The setup: Mac OS X Lion, PostgreSQL 9.0.4 Host Windows 7 VM I used to be able to connect from the VM to Postgres via pgAdmin and / or the software I'm developing on Windows just fine. That was ...
0
votes
1answer
148 views

Problem restarting postgres on OS X

I am running PostgreSQL in OS X. I am trying to restart the postgres service. When I attempt to sudo su postgres, nothing happens admin$ sudo su postgres admin$ Then, I try using -l and this is ...
0
votes
1answer
70 views

Path application Postgresql installation on Windows 64 bit

I want to know where is postgresql installation path on Windows XP 64 bit. If on Windows 32 bit, the path is on registry Software\\PostgreSQL\\Installations\\postgresql-8.4\\. Would anybody tell ...
0
votes
1answer
564 views

How to install Python and PostgreSQL on CentOS

I have a dedicated server running centOS. I want to install python 2.6 and postgreSQL on it so python users can host their web apps on my server. (Apache) Can anyone give me a detailed tutorial for ...
0
votes
1answer
182 views

sqlalchemy fails to connect to db after server is idle for a few hours

I have a fairly standard setup where the application server is separated by a firewall from the database server. The application is using sqlalchemy and the db is postgres. The system works fine for ...
0
votes
1answer
53 views

unable to do switchover in postgresql9.0

I m trying to do switchover in postgresql. That means making standby server as master and master as standby server. But it's writing these lines in log file... 2011-06-24 09:15:45 ETC/GMT LOG: ...
0
votes
1answer
309 views

Postgres service does not restart after windows server restart

I have postgres 8.3 installed on windows server 2003. The postgres service is not started after windows server restart. Its startup type is automatic. I have to set log on password again in service ...
0
votes
1answer
141 views

PostgreSQL: Pooling LDAP connections

I have PostgreSQL 8.4 configured to authenticate database users by performing a LDAP bind, as described in http://www.postgresql.org/docs/8.4/static/auth-methods.html#AUTH-LDAP. It works. However, for ...
0
votes
1answer
143 views

Database Statistics tools

I have to monitor database statistic for postgresql.In future it may change.So the tool which support multiple database server would be better. The statistics are like : 1. Query execution time. 2. ...