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

Rsnapshot frequently exits with error 12 when processing tar.gz file

I have an rsnapshot tool to backup some machines. It's running on a QNAP NAS and backing up several machines. One of the things I backup is database backups. On one machine I create both plain text backup files, and a tar.gz of said files. Plain…
mmalmeida
  • 155
  • 1
  • 9
0
votes
1 answer

Postgresql 9.2.15 on Centos 7.2 failed to bind to ipv4

Ran the following for a fresh install. yum install postgresql-server postgresql-contrib postgresql-setup initdb systemctl start postgresql With standard config, no changes or anything. Nov 02 10:33:17 xxx.org pg_ctl[87482]: LOG: could not bind…
lbanz
  • 1,609
  • 5
  • 20
  • 30
0
votes
0 answers

Postgres Shared Memory Issue

I'm unable to restart my postgres server. I believe it is related to it's attempted usage of shared memory. Host is Ubuntu 14.04.05 LTS Postgres is 9.5 root@host:/# ls -lah /run/shm/ total 0 drwxrwxrwt 2 root root 40 Oct 21 17:42 . drwxr-xr-x…
bearrito
  • 380
  • 3
  • 16
0
votes
2 answers

Postgresql HA PITR

I've had success in the past with MySQL's delayed replication feature which allows you to stop replication, inspect the bin log to find a bad query and SLAVE UNTIL just before said query and skip over it. Since Postgresql introduced the…
Jason
  • 163
  • 1
  • 1
  • 7
0
votes
1 answer

Are general sotorage solutions suitable for ACID DB's storage?

We use IBM Storwize V3700 as storage solution in our company, it runs 3 storage volumes on RAID 5. The storage is used not only for DB's, but also for general VM storage and a shared filesystem available for the whole company. My understanding is…
David Hofmann
  • 131
  • 6
0
votes
1 answer

pgsql is not loading (centOS 6.8)

*First of all don't answer "php.ini >> uncomment extension=pgsql.so and restart httpd". did that millions of times, did not solve my problem. *Tried hundreds of methods described in different sites including stackoverflow, but unfortunately did not…
MD TAREQ HASSAN
  • 111
  • 1
  • 5
0
votes
1 answer

Nginx/postgres not using all cores

I have an Nginx+Postgres server with 8 cpu cores. I noticed that under load CPU is used only up to ~60%. I looked at top and here is a screenshot: It turns out that only 5 processes are actually run in parallel. What could cause this capping? I…
Džuris
  • 145
  • 1
  • 9
0
votes
1 answer

Connecting to RDS Postgres via jdbc & c3p0 unable to acquire from the underlying database

Trying to connect from an application using C3P0 and the latest Postgresql JDBC driver 9.4.1211. We want the connection string to be SSL and have an MD5 hash password on the user account: c3p0 { jdbcUrl =…
J Pullar
  • 101
  • 2
0
votes
1 answer

PostgreSQL generates many WAL files

We have PostgreSQL server running with a couple of databases around 6.6 GiB in total. Growing about 10 Mb every day. I have activated WAL archiving using a very basic setup: wal_level = archive archive_mode = on archive_command = 'rsync -a %p…
progressdll
  • 1
  • 3
0
votes
1 answer

Use SQL views instead of tables with Asterisk dynamic realtime

I had hoped that I would be able to use an SQL view instead of a table to provide e.g. iaxusers and iaxpeers to Asterisk via dynamic realtime (ARA). I have just noticed that iaxpeers apparently requires several columns for Asterisk to store…
Drux
  • 656
  • 1
  • 9
  • 24
0
votes
0 answers

postgresql log shipping doesn't seem to work

There are two servers. One is the on-site database server; the other is the off-site backup server. Since the on-site database server already contains just shy of 900G of data, backups are important. Originally, we used a daily pg_dumpall, but for…
Wouter Verhelst
  • 438
  • 3
  • 8
0
votes
1 answer

Postgres autovacuum errors while restoring a dump

Restoring a dump on a Ubuntu 16.04 system takes several hours. Autovacuum is just canceled after waiting more than 3 hours (10926330.443 ms): 2016-07-20 05:20:00 CEST [78652-2414] LOCATION: exec_simple_query, postgres.c:946 2016-07-20 08:22:05 CEST…
Barmi
  • 439
  • 1
  • 6
  • 15
0
votes
1 answer

ZFS: ARC and buffer cache with PostgreSQL

I am using Ubuntu Xenial, zfs and PostgreSQL 9.5 with all updates available atm. All testing is done on EC2 m4.xlarge (8GB RAM) and table size ~4GB. PostgreSQL effective_cache_size=6GB. First scenarion: primarycache=metadata, arc_max_size=1GB…
Vladimir
  • 145
  • 10
0
votes
1 answer

Why should I use VPN in this scenario?

I have one web application, that is deployed on cloud. Now, this web application needs to access 3 Postgres databases, located in 3 different location(Lets call them, client systems). So one day, I met with this guy, who is very experienced and…
Bhushan
  • 93
  • 1
  • 11
0
votes
1 answer

Making temp_tablespaces favor certain tablespaces over others

I've got three tablespaces. Two of them are on disks with ~400GiB free, and one is on a disk with ~200GiB free. I want to set up temp_tablespaces to use the latter disk less frequently in case I run out of space on it. How can I do this?
sudo
  • 265
  • 3
  • 11
1 2 3
…
99 100