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

Request Tracker migrate PostgreSQL to MySQL

I am in the process of migrating a request tracker 3.6 instance from one server to another. The old server uses PostgreSQL and the new one will use MySQL. Is there a way to migrate the data from one ...
1
vote
3answers
1k views

Postgresql behind firewall: Query takes too long

Here is my setup: two CentOS 5.2 boxes on VMWare ESXi 4.0. The first box ip is 192.168.22.52 on eth0 and 192.168.99.1 on eth1. The second box runs PostgreSQL 8.3 with ip 192.168.99.2 on eth0. Here are ...
0
votes
2answers
894 views

What is a good django admin-like tool for postgres?

I am looking for a tool that will give a few people the ability to muck around in our database. Currently I write custom SQL queries every time we need to do something we don't have tools for. I ...
18
votes
8answers
15k views

What is the best filesystem for insert performance on PostgreSQL?

I'm curious if anyone out there has done any experimentation or comparisons between file systems and database performance. On Linux, I'm wondering what is the optimal file system for a postgres ...
42
votes
10answers
6k views

PostgreSQL Replication

We constantly bat this around the office, and the question continues to come up. How do you deal with PostgreSQL replication? I'm not even necessarily talking about advanced clusters, just keeping it ...
5
votes
5answers
9k views

how to install fuzzystrmatch.sql pg_trgm.sql on postgresql on mac os x

I have installed postgresql according to this, but I also need fuzzy string match functions, but I have no idea how to install these.
3
votes
2answers
2k views

Postgresql 'invalid page header' recovery

I'm currently working with an embedded system that uses Postgresql for data storage. We currently have a problem where the boxes will sometimes get rebooted with no warning, and no proper shutdown. ...
1
vote
4answers
4k views

How to migrate data from a Firebird database to PostGreSQL on Linux

Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly ...
5
votes
4answers
8k views

Can you explain exporting and then importing ProgreSQL using phpPgAdmin? (And what's with permissions?)

Bounty Edit: I've left the original question but would like a good answer on the whole permissions debacle that Postgres seems to bath in. 'Importing & exporting clients db's: A field guide' I ...
1
vote
3answers
1k views

Is Access connecting to a remote Postgresql database via ODBC usable?

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking ...
16
votes
4answers
7k views

Which database server scales better: PostgreSQL or MySQL?

I'm working on a website that could eventually have a very large database. The website will be an art community not until deviantART. I'll be running a lot of queries for analyzing how the site is ...
4
votes
3answers
2k views

PostgreSQL encrypted backups

Is it possible to ensure that dumps taken from a PostgreSQL db are always encrypted? The data in the database is highly sensitive and we cannot afford un-authorized personnel, including Sys Admins ...