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

PostgreSQL replicate data have different time

I'm notice that when I replicate data between 2 server with different time zone, the time data in PostgreSQL is shifted when I load it to a client (in my case, a Rails console). I thought all persisted data should be converted to UTC but it doesn't…
Phuong Nguyen
  • 703
  • 1
  • 12
  • 27
0
votes
1 answer

Unaccent for postgresql 9.0.8 (over RHEL6)

I need to install the unaccent extension in a postgresql server 9.0.8 running over a RHEL6 box which doesn't have the contrib package. So I need to install postgresql-crontrib first. Facts: Server doesn't have internet access so the yum option from…
Luke
  • 121
  • 3
0
votes
1 answer

Weblogic security store on PostgreSQL

I am trying to port a Weblogic environment from Oracle to PostgreSQL. When I configure a domain with the security store on PostgreSQL, it fails to start. Weblogic 12c, Java 7, PostgreSQL 9.3.4 here on Mac OS X but same problem on Linux. The domain…
Eric Darchis
  • 153
  • 1
  • 7
0
votes
2 answers

OpenNMS installation failure

I am willing to use OpenNMS to monitor my network. Monitoring it fully from the router to the nodes from a computer will be connecting the network as node not as administrator and that computer using Windows XP SP3, with 1.5 GB RAM, 160 GB Hardisk…
opa.mido
  • 1
  • 2
0
votes
1 answer

Lots of connections to loopback, could be slowing us down

I'm trying to debug a sudden increase in our load average. I looked at this page to see if we were being DDoS'ed but the standout IP address was the loopback address: $ netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort…
benwad
  • 255
  • 2
  • 12
0
votes
0 answers

Moved offices and now cannot connect remotely to postgres

Everything was working in my previous office. I've now moved to a new office, and cannot connect remotely to postgres. SSH works though. My IP is currently 70.90.155.138. Could not connect to server: connection timed out IP tables config: # …
Jeremy T
  • 101
  • 4
0
votes
1 answer

PostgreSQL 9.2 segfaulting on corrupt files

After a server crash one or more of Postgres' files have been corrupted (at least, for now, I will assume it is due to the crash and not due to faulty hardware). The problem seems to be limited to some rows of one quite large table, since we get…
rausch
  • 302
  • 2
  • 10
0
votes
2 answers

Postfix with Pgsql support

I'm trying to find an alternative repo with postfix that has pgsql support on Cenots 6. I previously used CentAlt but since that seems to be dead now i'm trying to find an alternative. I would prefer not to compile postfix from source if at all…
Callum
  • 21
  • 6
0
votes
1 answer

Database connection to postgresql refused for flask app under mod_wsgi when started by systemd

I'm having a weird problem where a flask application I am trying to run (https://github.com/pyfarm/pyfarm-master) under mod_wsgi under Apache under CentOS 7 cannot connect to a local postgresql server – but only if said apache has been started from…
guidow
  • 3
  • 2
0
votes
1 answer

Different technologies for syncing with server

Well, I'm currently teaching DB in a course in University. Students had already gone through advanced programming (this includes torturing them through a whole semester with massive projects, they really learn a lot). In my course there is currently…
Cristian Eduardo Lehuede Lyon
  • 105
  • 4
0
votes
0 answers

Postgres 9.3 on Linux - Resource utilization - Multiple vs one service services

I'm consolidating multiple Linux boxes running Postgres into one box. Given the way Postgres handles resource utilization, would one single server service handling all the databases provide a much better performance than multiple server services…
Diego Puertas
  • 9
  • 2
0
votes
1 answer

postgres stopped - how to restart?

my postgresql (9.3.4) was running on Ubuntu, and suddenly stopped tonight. When I try to stop it, logged in as postgres, I get ~$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop; pg_ctl: could not send stop signal (PID: 9242): No such…
user410932
  • 155
  • 2
  • 7
0
votes
2 answers

PostgreSQL fails to start -- no clear reason

I have a server which was happily running PostgreSQL, until a crash this morning. Trying to restart Postgres, but it fails: sudo /etc/init.d/postgresql start Starting PostgreSQL 9.1 database server Removed stale pid file. The PostgreSQL…
Daniel Winterstein
  • 101
  • 1
  • 3
0
votes
1 answer

What do the return codes mean for pg_archivecleanup?

I'm trying to run pg_archivecleanup from our DR Postgres server (Windows), but I am getting return code 2. I am guessing that the issue may be permissions since I can run the command myself and it works fine, but the Postgres service logs return…
pete the pagan-gerbil
  • 181
  • 2
  • 13
0
votes
1 answer

Cannot set postgres user password

Trying to install PostgreSQL with Ruby on Rails with Nginx on CentOS 6.5 using the following guide: http://karolgalanciak.com/blog/2013/07/19/centos-6-4-server-setup-with-ruby-on-rails-nginx-and-postgresql/ After install I went to configure the…
eComEvo
  • 1,011
  • 3
  • 20
  • 32
1 2 3
…
99 100