Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgresql-9.1]

PostgreSQL is a powerful, open source object-relational database system. Please use this tag for questions related specifically to version 9.1 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:

13 questions
10
votes
2 answers

How to change Postgresql database from Read-only to Writable

I'm new to managing servers, especially postgresql on Ubuntu Server, so bear with me. I'm trying to synchronize between two databases on two different computers, but I'm not sure what I did wrong, since whatever I tried to do, it seems to have…
hdr
  • 163
  • 1
  • 2
  • 9
4
votes
0 answers

Meaning of postgresql log "using stale statistics instead of current ones because stats collector is not responding"

I have a Postgresql 9.1+134wheezy4 running on Debian 7 Wheezy. From 2015-02-07 on (I guess it has been backported then, see below) I regularly see the following line in /var/log/postgresql/postgresql-9.1-main.log: 2015-02-07 11:08:33 CET LOG: using…
sebix
  • 4,313
  • 2
  • 29
  • 47
4
votes
3 answers

Unable to locate package postgresql-server-dev-9.1 on Ubuntu 14.04 x64

I am trying to install postgresql-server-dev-9.1 on Ubuntu 14.04 x64. I first did sudo apt-get install postgresql and it worked. I then tried sudo apt-get install postgresql-server-dev-9.1 and i get the error message Reading package lists...…
madstap
  • 143
  • 1
  • 5
1
vote
1 answer

Poor website performance

I have a website where the number of visitors is increasing and it is facing a poor response time. I am not a server specialist and for this reason I want to expose my issue here to receive some feedback. The website has the following…
JORGE
  • 111
  • 1
1
vote
0 answers

Postgres pg_trgm Extension Creation Error

I have installed Postgres 9.5 in an attempt to install GitLab. As part of the process the trigram extension (pg_trgm) needs to be created on the database. When I issue the create statement I get the following error: ERROR: could not open…
FluxIX
  • 111
  • 2
1
vote
1 answer

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 MB/s. I've already found some interesting sources on…
Thorsten Schöning
  • 683
  • 7
  • 20
1
vote
1 answer

Why would updating postgresql-client uninstall postgresql?

On a Debian 7 server, apt-get was offering me to upgrate the following 2 packages: postgresql-9.1 and postgresql-client-9.1. Since I didn't want to restart the database server, I decided only to upgrade the client and ran: sudo apt-get install…
Herka
  • 11
  • 2
0
votes
1 answer

Unable to backup postgres databse

We have postgres 9.1 running on Ubuntu box. The postgres db size is 155GB and it has about 13200 tables. The Ubuntu box has 120GB RAM. The Ubuntu box is a docker container. When an attempt to backup the db was made, it failed saying: pg_dump:…
Maddy
  • 101
  • 1
0
votes
1 answer

psql: duplicate GSS authentication request

What does it mean by saying 'duplicate' ? How to troubleshoot this? guest@www:~$ klist Ticket cache: FILE:/tmp/krb5cc_1000 Default principal: user/admin@SOHONET Valid starting Expires Service principal 12/11/2015 07:37:08 …
user319773
  • 1
  • 2
0
votes
1 answer

Migrate data from postgresql 8.4 to postgresql 9.4 in 2 different servers

I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in postgresql 8.4 to postgresql 9.4 in different server…
Phong Đặng
  • 53
  • 1
  • 5
0
votes
2 answers

Data Directory PostgreSQL 9.1 to Windows 2008 Server R2

"My predecessor" has installed PostgreSQL 9.1, now I would like to know what is the "Data Directory" installation. Now I am using this interface: Can I know using this interface the Data Directory? Thanks.
Francesco Irrera
  • 205
  • 1
  • 4
  • 10
0
votes
1 answer

Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to: Add username map in pg_ident.conf: vp vagrant …
Jorge Arévalo
  • 197
  • 1
  • 11
0
votes
1 answer

Postgres Table size & record counts

I want to understand the below result behavior for finding a size for a table with x MB while try to count record in this table but no records found in postgres database db_server=# \dt+ List of relations Schema | …
Moustafa
  • 1
  • 2