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
1 answer

TOLVEN installation: Test Database and LDAP Connections After ConfigPhase1

I am trying to install tolven, and following the manual http://wiki.tolven.org/index.php/Installation_Guide My linux system info is as follows: root@localhost:/> cat /etc/issue **CentOS release 6.4 (Final)** root@localhost:/>…
Devlpr
  • 5
  • 3
0
votes
1 answer

How do I upgrade Postgres database in Cygwin?

I updated some Cygwin packages and now I can't start Postgres: $ /usr/sbin/postmaster FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 8.2, which is not compatible with this…
Chloe
  • 1,164
  • 4
  • 19
  • 35
0
votes
1 answer

Optimize nginx/php-fpm/postrgresql

I've got: a CPU E5-2407 (quadcore Xeon 2.2GHz) 16GB of memory DDR3 RAID1 Intel520 SSD 240GB My homemade applications are using a permanent PG connection on 7 pages (one called by customers as API, others called by a CURL bash loop with 10s timer)…
KuroNeko
  • 19
  • 7
0
votes
1 answer

pg_basebackup exclude one table

We perform (Point in time recovery) PITR backup on postgresql. We use pg_basebackup for daily snapshots and recovery_command for incremental backup. So, we have a big table with logs in the database (about 70 Gb). We don't want to back it up every…
user184843
  • 1
0
votes
1 answer

Installed JDBC drivers into Solr

I am running Solr4 on Jetty9 and I am trying to include the JDBC drivers for both MySQL and PostgreSQL. I'm a little confused about how I do this. I believe these to be the two files I need:…
J.Zil
  • 1,123
  • 3
  • 21
  • 29
0
votes
1 answer

How to upgrade Postgresql Database Server 8.2.11-1.fc8 to 9.2

I'm new to Postgresql Database. We have an old Fedora 8 Server where we have postgresql database server 8.2.11-1.fc8, Would like to know if we can upgrade this version of postgresql database server to the latest version 9.2? In case of upgrade, how…
Big Data
  • 114
  • 2
  • 11
0
votes
1 answer

Backing up remote Postgres database

I have a Windows 2008 Server machine with a postgres database running on it. I'd like to back it up daily and have it sent to another machine (running Ubuntu or Windows). What's the best way to set this up?
NinjaCat
  • 576
  • 1
  • 9
  • 21
0
votes
2 answers

Transferring data but not structure between Postgres and MySQL

I am currently migrating a web application from one platform to a different one, and part of this migration involves moving data from a Postgres DB to a MySQL DB. The table structures will not be the same, so I am wondering what are some suggestions…
Paul T
  • 115
  • 4
0
votes
2 answers

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC DataSources. This is for an Oracle database, though I…
Robin Green
  • 451
  • 3
  • 11
0
votes
1 answer

pgbouncer - failed to restart

I am logged in to a server and trying to restart pgbouncer. $ /sbin/service pgbouncer restart Stopping pgbouncer service: [FAILED] pgbouncer already running [FAILED] When I call for…
hackg
  • 3
  • 1
  • 2
0
votes
1 answer

how can I change the logfile permssions for postgresql 8.4?

I see that there is a log_file_mode that was introduced in either 9.0 or 9.1, but it is not available for PG 8.4. How to people manage to give access to the logfiles to users other than the postgres user? (I'm on RHEL 6.3)
Chris Curvey
  • 359
  • 1
  • 2
  • 9
0
votes
1 answer

change socket to other then default in phpPgAdmin

I need to change the socket phpPgAdmin connects to in its config. // Hostname or IP address for server. Use '' for UNIX domain socket. // use 'localhost' for TCP/IP connection on this computer $conf['servers'][0]['host'] =…
Daniel W.
  • 1,609
  • 4
  • 26
  • 48
0
votes
1 answer

Sed issue with numbers exceeding 9

May be my problem is kinda obvious for you but I really need to get a solution. I need to generate a file.sql file from a file.csv, so I use this command : cat file.csv |sed "s/\(.*\),\(.*\)/insert into table(value1, value2) values\('\1','\2'\);/g"…
Imane Fateh
  • 101
  • 2
0
votes
1 answer

Where to look for PostgreSQL sock file on Centos 6.4?

I installed postgresql9.1 into my Centos 6.4. I can do psql template (as root) to open the database console but cannot use Rails rake db:create to create the database: FATAL: Ident authentication failed for user "root" My configuration is as…
Phuong Nguyen
  • 703
  • 1
  • 12
  • 27
0
votes
2 answers

Graph arbitrary data on the command line

I'm currently debugging an issue where I see a large number of threads in my application hanging on to a database connection even though they are asleep, often the threads sleep for a significant length of time (10-300s) (they're sensor…
Lee Hambley
  • 360
  • 3
  • 12
1 2 3
…
99
100