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 ...
1
vote
1answer
25 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
30 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
26 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 ...
-1
votes
1answer
9 views
Cannot use pg_dump, command not found [on hold]
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
23 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
13 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
8 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: ...
1
vote
1answer
26 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 ...
0
votes
0answers
17 views
PostgreSQL backup tool with retention support [closed]
I am currently running daily backups using custom script and keep backups for 2 months. Can anyone recommend a backup tool that would allow to implement some retention, e.g. keeping last two weeks ...
3
votes
2answers
48 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
40 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
28 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). ...
1
vote
1answer
27 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
21 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
43 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 ...
