Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgresql-9.3]

PostgreSQL is a powerful, open source object-relational database system. Please use this tag for questions related specifically to version 9.3 of this software.

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.

Related tags:

24 questions
24
votes
1 answer

Django: CONN_MAX_AGE persists connections, but doesn't reuse them with PostgreSQL

I've got a django setup are using Django 1.6.7 and Postgres 9.3 on Ubuntu 14.04 LTS. At any given time, the site gets about ~250 simultaneous connections to the PostgreSQL database, which is a Quad Core Xeon E5-2670 at 2.5GHz, and has 16GB of ram. …
synic
  • 783
  • 1
  • 8
  • 13
17
votes
7 answers

Wrong version of pg_dump on Ubuntu

I originally installed postgres 9.2 on Ubuntu and later upgraded to 9.3 according to the instructions here: http://www.postgresql.org/download/linux/ubuntu/ (using the postgres apt repository). However, pg_dump, which is an alias for…
BillRobertson42
  • 371
  • 1
  • 2
  • 11
12
votes
2 answers

Why can't user login on Postgres

I have attempted to set up a read-only user in Postgres, but they are unable to log on. I am unsure the next step to take to solve the problem. When I try and log on as user XXXX I get an error - psql: FATAL: password authentication failed for…
davidgo
  • 5,964
  • 2
  • 21
  • 38
5
votes
1 answer

Using PGPASSWORD variable does not seem to work any more on Postgresql 9.3

In Posgresql you can set a variable called PGPASSWORD (and PGUSER) so you don't have to use password when using postgresql commands such as psql or pg_dump But I am a bit confused because I can't get it to work on Postgresql 9.3.10 and it's still…
Ulukai
  • 829
  • 2
  • 10
  • 28
4
votes
1 answer

pg_basebackup automatic password

I have a master and slave database setup. The master database is on a secure network and only the postgres port is allowed through to the slave database server. The database needs to be secured and only the admin has the database password. The…
Chris
  • 195
  • 3
  • 8
3
votes
5 answers

PostgreSQL won't start after moving datadir on Centos 7

I've installed PostgreSQL 9.3 on Centos 7. After installing I could start the system service and login to psql. I want to move the PGDATA folder to another partition, so I tried several things to change DATADIR. I copied the /var/lib/pgsql/data…
SPRBRN
  • 561
  • 4
  • 12
  • 27
3
votes
1 answer

Diagnosing low disk space error from PostgreSQL despite low disk usage

I have a Django web application using a PostgreSQL 9.3 database, which occassionally throws the error: File "/usr/local/my_site/.env/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value,…
Cerin
  • 3,497
  • 17
  • 57
  • 72
3
votes
1 answer

Reduce the size of main/base mysterious buildup

Using PostgreSQL 9.3. I had a long-running query updating around 8M rows. Something obviously went wrong. 2 days later I got a low disk space alert. I stopped the query and this is what I saw. root@server:/var/lib/postgresql/9.3/main# du -BM * |…
panta82
  • 248
  • 2
  • 10
3
votes
1 answer

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so I can store all of the log files. Master…
Aidan Kane
  • 185
  • 1
  • 1
  • 8
2
votes
2 answers

Postgres SSPI authentication on Windows

I'm trying to enable windows authentication for Postgresql 9.3 (Windows x64 not in domain, UAC is disabled, my account is local admin). The one click installer set the server running under NETWORKSERVICE which I think is fine. I followed this answer…
UserControl
  • 135
  • 1
  • 6
1
vote
1 answer

What is postgres-9.4-postgis-2.1

What is postgres-9.4-postgis-2.1 ? what is the difference of postgres-9.4-postgis-2.1 and postgis sudo apt-get install postgres-9.4-postgis-2.1 and sudo apt-get install postgis which one enable the postgis plugin of a postgres database
Hello lad
1
vote
3 answers

httpd.service Cannot connect to database Centos 7

I'm trying to connect to PostgreSQL Unix domain socket from a python web application with mod_wsgi. Relevant system components: CentOS 7 x64 Python 2.7.5 SELinux disabled PostgreSQL is listening on standard port 5432 and I have no problems to use…
xav
  • 21
  • 5
1
vote
0 answers

How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit" is working in Debian 6.0 Squeeze It contains 12 databases accessed by 100 users from internet. md5 password authentication method is used. Total…
Andrus
  • 169
  • 4
  • 11
1
vote
1 answer

Can't read files into postgres

We've just set up a postgres 9.3 server on a Windows 7 machine. If we try to copy data into a database from C:\dbfeeds\csv.csv we get the following error: ERROR: could not open file "C:\dbfeeds\csv.csv" for reading: Permission denied SQL state:…
JamesF
  • 195
  • 1
  • 2
  • 5
0
votes
1 answer

Manually start PostgreSQL 9.3 after installer quietly refuses to install Windows service

I need to access a small database from about four years ago. I have the original installer and the entire original directory including the data folder. Unfortunately the installer for 9.3 and 12.0 absolutely refuse to create a service for Windows.…
John
  • 131
  • 8
1
2