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
0 answers

Dovecot and reconnection to database

I've got a setup with Dovecot using a PostgreSQL backend together with vmm. I usually get messages like this into log: dovecot: dict: pgsql(10.0.0.2): Connected to database mail Based on investigation I think it's because Dovecot is losing/closing…
frlan
  • 573
  • 1
  • 8
  • 27
0
votes
3 answers

Apache: 403 Forbidden for WSGIScriptAlias

I am trying to install istSOS following these instructions from the website: Installation Install PostgreSQL $ sudo apt-get install postgresql postgresql-client postgresql-contrib pgadmin3 Install PostGIS $ sudo apt-get install…
JJD
  • 77
  • 1
  • 10
0
votes
0 answers

PostgreSQL DB size increasing after restoring the same database backup

This is my batch script to take backup @ECHO OFF d: cd Apps\RemedyStar 9.0 KREMCOS\bin\Debug\PG pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -v -f "C:\Documents and Settings\GDS\Desktop\backup\RStar.backup" "RStar" echo Backup Taken…
Thomas Gabriel
  • 1
0
votes
1 answer

psql doesn't allow to input cyrillic symbols

I have a server with postgresql 8.4 installed on it. But when I try to insert some data in russian, for example: UPDATE category set question = '[there should be russian symbols]' WHERE id = 1; terminal doesn't allow me to type russian…
user3734
  • 101
  • 2
0
votes
1 answer

Install PostgreSQL under a system user other than “postgres”?

I need to run my current Postgresql 9.3 under a system user other than postgres, say admin OR I need to install Postgresql 9.3 with the default user as say admin on Ubuntu 12.04
Ajo Augustine
  • 1,262
  • 4
  • 16
  • 21
0
votes
1 answer

Pgpool configuration with Liferay cluster

I'm using a Liferay cluster connected to pgpool2 and when I run heavy user activity against the web servers I see a lot of exceptions regarding liferay unable to establish a connection to the DB. There are two DBs behind pgpool Exception…
Crushing
  • 111
  • 1
  • 4
0
votes
1 answer

PostgreSQL 9.1 on CentOS 6.5 - recovery.conf causing process exit with error code

I did setup streaming replication on the Ubuntu 12.04 LTS with rsyncing of the WAL files in case of failure. Now I was trying to do the same on the CentOS 6.5. To do this I've added official RPM from postgresql.org and installed postgresql 9.1 using…
mickula
  • 342
  • 1
  • 2
  • 10
0
votes
1 answer

trying to install postgresql-contrib for pg 8.4 in Ubuntu 12.10

I had to do some strange voodoo last year sometime to get postgresql 8.4 installed on a relatively modern ubuntu OS. I had to use 8.4 because the production site is 8.4 and we needed to ensure compatibility in our test environment. (we have no…
Jeremy Holovacs
  • 407
  • 1
  • 6
  • 22
0
votes
1 answer

Securing the Django web site which is run with Apache mod_wsgi

I have made a website in Django 1.6 with PostgreSQL database which is hosted on Ubuntu 12.04.3 with Apache 2.2.22 and I have recently noticed lots of hacking (probing) attempts from various IPs constantly every day which fills my inbox with reports…
errata
  • 543
  • 1
  • 6
  • 9
0
votes
1 answer

High CPU usage in RHEL machine

I have RHEL machine that runs postgres-9.1 database. In a particular time, sar output shows as follows: Refer link for snapshot: http://imgur.com/gKcOhOX,vNwTpwC#0 where as %user is high between 12:50 AM and 1:50 AM & others are asusual, and later…
harishtallam
  • 1
0
votes
1 answer

HAProxy pgsql-check error

I use HAProxy 1.5-dev21 to load balance PostgreSQL connections over some read-only Postgresql 9.2 servers. Version 1.5 of HAProxy implements a pgsql-check option, similar to mysql-check. Here is my typical HAProxy configuration for such pool: listen…
Nicolas Payart
  • 101
  • 1
  • 3
0
votes
0 answers

PostgreSQL log warnings: open temporary statistics file, pgstat wait timeout

We frequently get the following warnings with our Postgresql Database LOG: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device WARNING: pgstat wait timeout When we get the above two warnings, our database…
Big Data
  • 114
  • 2
  • 11
0
votes
1 answer

puppet gitlab postgresql conflict

I#m trying to setup a VM with postgresql and gitlab. I'm using the following packages: gitlab & postgresql This is my init.pp class { 'postgresql::server': ip_mask_deny_postgres_user => '0.0.0.0/32', ip_mask_allow_all_users => '0.0.0.0/0', …
soupdiver
  • 807
  • 2
  • 9
  • 26
0
votes
1 answer

PostgreSQL copy permissions

I'm using pgadmin to copy a csv file into the database. this worked fine a million times until today. I get the following error Could not open file "/path.csv" for reading: permission denied I poked around google, and some of the suggestions were to…
dassouki
  • 103
  • 4
0
votes
1 answer

Migrate to AWS from Linode

Migration to another server is not easy when we have a large database. We want to move our database in Linode to amazon RDS database, i tried to pg_dump and pg_restore and it succeeds but it consume a lot of time. My Question is: is there a fast way…
mohamed-ibrahim
  • 131
  • 1
  • 7
1 2 3
…
99 100