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 ...
36
votes
10answers
5k 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 ...
2
votes
2answers
169 views
How to install Postgres on LINUX with two verions?
I want to upgrade my postgres8.3 to 8.4 for single domain. Don't affect other domain. How to manage it. Is it possible?
1
vote
3answers
185 views
Slow PostgreSQL response over VPN
I'm having a problem with a medical records program that uses a Postgre SQL as a backend.
Several offices are connecting to a corporate site via Cisco VPNs. There is an ASA5055 at corporate and most ...
3
votes
6answers
788 views
PostgreSQL Tips 'n' Tricks [closed]
This is meant to be a community wiki for collecting together different bits of PostgreSQL knowledge. Nothing is too common or too obscure. Post anything you know that would help others make the most ...
21
votes
7answers
21k views
How to restart postgres on OS X?
After a reboot, postgres on my machine hasn't restarted. What command should I use in Terminal to get it going again?
13
votes
6answers
17k views
GRANT SELECT to all tables in postgresql
Is there a one-liner that grants the SELECT permissions to a new user postgresql?
Something that would implement the following pseudo-code:
GRANT SELECT ON TABLE * TO my_new_user;
4
votes
3answers
677 views
Does Postgres database support differential backups
Does Postgres database support differential backups
9
votes
3answers
2k views
Extremely Slow IO with Simple PostgreSQL 8.4.4 Queries on Centos 5.5
The strange and extremely slow IO pattern I'm seeing is this (output of iostat -dxk 1 /dev/xvdb1):
Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm ...
1
vote
1answer
444 views
Can't create clusters in PostgreSQL 9.0
I'm trying to setup and run multiple clusters of PostgreSQL 9.0 in the same Ubuntu/Debian machine. Debian has a package called 'postgresql-common' to facilitate managing database clusters. However, ...
5
votes
1answer
3k views
Can't connect to PostgreSQL on VirtualBox guest
When I try to connect from a PostgreSQL client on the host system to the PostgreSQL server on a VirtualBox guest system, I get a "connection attempt failed" message.
The host system is Windows XP. ...
4
votes
2answers
330 views
choosing the right RAID level for PostgresQL database
I got an disk array appliance of 8 disks 1T each (UltraStor RS8IP4). It will be used solely by PostgresQL database and I am trying to choose the best RAID level for it.
The most priority is for read ...
2
votes
1answer
3k views
How to install PostgreSQL extension for PDO in Linux?
I have the VPS. I can build my PHP version using Easy Apache. I can find the option for PDO support for MySQL, SQLite. But I don't have any option of PDO pgsql driver.
How can I enable that?
It says ...
1
vote
1answer
138 views
Backup broken PostgreSQL 8.4 without pg_dump
So. I have a problem. PostgreSQL 8.4 won't start or restart without any output given.
But it worked for 3 monthes until hosting provider doesn't rebooted server. Now it is completly broken. It wan't ...
1
vote
1answer
705 views
How to restart postgresql 8.4 on Debian Squeeze when there are no clusters defined?
How to restart postgresql 8.4 on Debian Squeeze?
/etc/init.d/postgresql stop/start/restart does nothing (no output given).
1
vote
1answer
881 views
Empty error on starting almost-default PostgreSQL
When trying to start PostgreSQL, I get this 'empty' error message:
root@mountain-lion:/home/ubuntu# service postgresql start
* Starting PostgreSQL 9.1 database server
* Error: could not exec ...
1
vote
1answer
833 views
Crate a new, read-only user in postgres
I would like to create a new user in an existing postgresql database on an Ubuntu machine. I want to grant this user a read-only access to all the tables.
How do I do it? Do I need to create a new ...
0
votes
1answer
75 views
Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
We have an application where we are collecting timestamp-based data. Since a month of data goes over 30M rows (and growing each month), we decided to partition the data on an year-and-month basis.
We ...
0
votes
1answer
622 views
Strange permission errors in new PostgreSQL installation
A freshly installed PostgreSQL (with configuration overwritten) won't start:
$ sudo service postgresql start
* Starting PostgreSQL 9.1 database server
* Error: could not read ...
0
votes
3answers
1k views
Postgres cannot start on lion due to missing server configuration file
I am trying to setup pg on a relatively clean lion install and it's not being successful.
First I successfully installed homebrew, and installed postgresql without any errors.
Then I tried to run a ...
0
votes
1answer
938 views
Trying to determine the correct number of XFS allocation groups for postgresql server on Linux
I am running a postgres 8.4.5 server on the linux 2.6.33.7 kernel on an 8 disk raid array with an LSI controller.
Most of the tables are around 1GB or less.
I know that XFS uses allocation groups ...
0
votes
1answer
410 views
Connect to and reindex Postgres database with system table errors
I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per http://serverfault.com/questions/156152/after-db-disk-failure-now-cache-lookup-failed-for-index).
...
0
votes
1answer
351 views
After DB disk failure, now “cache lookup failed for index”
After resolving some problems with the network drive on which our Postgres database was hosted, we encountered this error:
OperationalError: FATAL: cache lookup failed for index 2662
That ...
0
votes
2answers
3k views
postgres on 64 bit linux or 64 bit windows server 2008?
Postgres does not have a 64 bit binary for windows server
quote
"As there is generally no reason to run with shared_buffers > 256 - 512MB on Windows, there isn't a great deal of incentive to put in ...
0
votes
5answers
451 views
how to speed up a database - hardware only
simple question - what is the best way to improve a database's performance using hardware only?
in this situation a few very very large tables are being queried very regularly by 1-4 processes at a ...
0
votes
2answers
524 views
PostgreSQL processes and the signals to which they respond
For PostgreSQL 8.3 and later, what are the processes that make up the server and that respond to a query?
What signals do the various processes respond to and what effect do the signals have?
What ...
-1
votes
1answer
21 views
postgresql access to same data [closed]
it's possible to access the same data from two different servers? the two servers have the same IP and not run simultaneously.
i try to point to directory created by another server but it doesn't work
...
-2
votes
1answer
194 views
Many Postgresql process. how to handle them?
I'm trying to fix an already install openNMS system on ubuntu. Currently I'm facing issue with postgresql. I stop server using this commnad:
service postgresql -$PGVERSION stop
after that when i ...
