5

5 Interesting Things You Can Do With PostgreSQL

view full story
linux-howto

http://ectnews.com.feedsportal.com – PostgreSQL is one of the most versatile, powerful and reliable object-relational database systems available. The enterprise-class open source database is in use by some of the largest companies in the world, handling exceptionally large workloads. But you knew all of that already, so let's talk about a few features in PostgreSQL you probably didn't know about already. The fact is that PostgreSQL is a sophisticated creature. You have to dive beneath the surface to really understand just what PostgreSQL is actually capable of. (General)

qq124's picture
Submitted by qq124 on 07/17/2012 – Made popular on 07/17/2012

Stories similar to 5 Interesting Things You Can Do With PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software.

I installed postgresql 9.2 from "add-apt-repository ppa:pitti/postgresql" using "apt-get install postgresql-9.2"

At the end of the install and every time I try to launch postgresql by using the following command

/etc/init.d/postgresql start

or

service postgresql start

I get this error:

Error: could not exec /usr/lib/postgresql/9.2/bin/pg_ctl /usr/lib/postgresql/9.2/bin/pg_ctl start -D

I am trying to upgrade postgresql from 9.0.4 to 9.2.3 using the directions from the wiki (postgresql page, under "upgrading"), due to systemd causing my connections to be refused on my socket for 9.0.4...# pacman -S postgresql-old-upgrade postgresql-libs :: postgresql-libs is in IgnorePkg/IgnoreGroup. Install anyway?

Navicat is a professional database administrator and development tool for many kind of database such as MySQL, SQL Server and PostgreSQL. Here you can download the latest version of Navicat for PostgreSQL 9.1.5 for Mac OS X users. It works with almost any version of PostgreSQL server. With Navicat for PostgreSQL you can easily connect [...]

The new version of PostGIS 1.2.0 already released. This new version fix many bugs and performance improvements of the previous PostGIS. You can download this PostGIS 1.2.0 from the link provided below this post. PostGIS Publisher Description: PostGIS adds support for geographic objects to the PostgreSQL object-relational database.

Edit: see comment for answer.

I have an interesting question. On my OS X 10.8 server postgres is running fine.

Launchd has is loaded under the label 'org.postgresql.postgres' and '# launchctl list org.postgresql.postgres' gives the output I expected.

The problem is: I cant find the configuration file. In /S/L/LaunchDeamons and in /L/LaunchDeamons I only have an 'org.postgresql.postgres_alt.plis

Postgresql fails to start 35 weeks 4 days ago

I have installed postgresql using pacman. And followed the wiki to get started. But, I got stuck at starting the server.

when I wanna doing anything with Synaptic or apt-get or stop , start, restart postgresql I will recivied following error

Setting up postgresql-common (114) ... * Starting PostgreSQL 8.4 database server * Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 63.

I have installed postgresql via apt-get install postgresql, but have an error, don't make the folder /etc/postgresql/9.1.

The error on psql:

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?