PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

1
vote
2answers
1k views

Accessing Internal Server from Outside through SSH

The issue is as follows: I am using Ubuntu Linux. I am working from home, and I need to access a PostgreSQL database severer within my company's network. Call the DB server X. For security reasons, ...
0
votes
1answer
238 views

Postfix: change recipient_delimiter with virtual_mailboxes

I have an email setup using Postfix, Dovecot, PostgreSQL. I am trying to change the recipient_delimiter to be - (dash) instead of + (plus) but the address are being rejected. In order to get the + ...
2
votes
2answers
69 views

Install postgres without apt-get

I have access to a machine on a scientific hpc, and I'm setting up an environemnt to create a web application, made up basically of TOMCAT and postgresql. I cannot use another web server. The OS is ...
0
votes
1answer
36 views

Postgresql starup script for second instance?

I need to run my second postgresql instance when linux boots. I added this command (like in postgresql documentation) in rc.local: /usr/lib/postgresql/9.1/bin/pg_ctl start -l logfile -D ...
0
votes
1answer
694 views

How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I ...
0
votes
1answer
612 views

PostgreSQL Windows installation failure

I was trying to install PostgreSQL 9.2 in Windows 7. When I launched the installer, it failed and showed the error message: Unable to write inside TEMP environment variable path I did a lot of ...
0
votes
2answers
2k views

How do I uninstall postgres on Mac OS? Can't kill data

I'd like to uninstall postgres on Mac OS 10.6 and start again with a completely fresh installation and empty databases. I've killed all running postgres processes and tried to delete the postgres ...