Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgresql]

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 (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

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 (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.

PostgreSQL has won praise from its users and industry recognition, including the Linux New Media Award for Best Database System and five time winner of the The Linux Journal Editors' Choice Award for best DBMS.

Best of all, PostgreSQL's source code is available under a liberal open source license: the PostgreSQL License. This license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source. Any modifications, enhancements, or changes you make are yours to do with as you please. As such, PostgreSQL is not only a powerful database system capable of running the enterprise, it is a development platform upon which to develop in-house, web, or commercial software products that require a capable RDBMS.

1955 questions
0
votes
2 answers

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 second instance to be a hot-standby (read only…
pete the pagan-gerbil
  • 181
  • 2
  • 13
0
votes
1 answer

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 difference is that I do not use postgres account for…
AmShegar
  • 259
  • 1
  • 2
  • 9
0
votes
1 answer

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 when I try to start Postgres, it says 2013-11-20…
Chris Curvey
  • 359
  • 1
  • 2
  • 9
0
votes
1 answer

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 noticed that Postgres appears to only run two…
user67856
  • 129
  • 1
  • 6
0
votes
1 answer

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 or so. The primary can access the secondary over…
Peter Westlake
  • 806
  • 2
  • 6
  • 17
0
votes
1 answer

To fix Postgres' login permissions for a new user

How can you enable the login for heo? I get the following The problem seems to be in permissions for the user/role "heo" and probably in pg_hba.conf. I put the following line to the file unsuccessfully local all heo …
Léo Léopold Hertz 준영
  • 809
  • 6
  • 22
  • 43
0
votes
1 answer

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 the postgresql database the rails application is…
Corillian
  • 101
  • 2
0
votes
0 answers

Django + Apache WSGI + pscopg2 + PostgreSQL 9.1 unexpected EOF on client connection

There are two servers I have. One is SQL server, other is Django project server. And sometimes I get too many unexpected EOF on client connection error by postgresql and OperationalError: could not connect to server: Connection timed out error by…
Sencer H.
  • 562
  • 1
  • 8
  • 17
0
votes
1 answer

Proper management of PGPool II

Currently I have a site, with one Postgres database server. It is just for a select number of users (less than ten) but it needs the maximum uptime possible. I would like some kind of automatic failover for the database. So I was thinking something…
Cathy
  • 103
  • 3
0
votes
1 answer

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I cannot find this file. How do I get the space…
user2104778
  • 103
  • 2
0
votes
1 answer

Postgres - Ship WAL logs from many servers to one

I have a number of independent postgres servers in my (recently inherited) environment and I am planning on backing them up via WAL shipping. I'd like to make one backup server that contains a copy of all of the databases from each of the production…
nrb
  • 93
  • 1
  • 6
0
votes
1 answer

Unable to login in phpPgAdmin

I am trying to login to phpPgAdmin from a remote client. I've created the user root, but when I login phpPgAdmin returns an error message saying "Unable to login" When I check the log it says: "provided user name (root) and authenticated user name…
Alfons
  • 11
  • 1
0
votes
2 answers

PowerDNS pgSQL Configure Different Schema

I've been using PowerDNS for a few years now and finally decided to switch over to pgSQL instead of mySQL. I've been researching this question but I haven't found anything solid so I'm assuming it's probably not possible. I'm curious if it's…
Diemuzi
  • 105
  • 7
0
votes
2 answers

How to build & install pgsql PHP extension manually on Ubuntu

I've searched high and low and haven't found anything. Perhaps I don't know what to search for. Environment is Ubuntu Lucid (10.4) with PHP 5.2.4 & PostgreSQL 9.2. PHP is "held" at 5.2.4 with dpkg --set-selections. I can only find a 5.2.6 version…
kentr
  • 181
  • 1
  • 1
  • 9
0
votes
1 answer

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 start. The log below: LOG: database system was…
migajek
  • 171
  • 2
  • 10
1 2 3
…
99
100