PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

2
votes
1answer
59 views

PostgresSQL created a user account on OSX

Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
1
vote
1answer
259 views

Postgresql is not avaible in Libreoffice Base

I want to edit a postgresql base using libreoffice-base. When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones ...
0
votes
1answer
96 views

Hide some functions from display in PG Admin III

I have installed modules (XML2, UUID) in Postgres. In PG Admin III, all the functions contained in those modules display under the "Functions" tree. The list is lengthy, and it slows down my work ...
0
votes
0answers
70 views

I don't understand how postgres is installed (OSX)

Im still having issues installing postgres and really do not understand all that is going on. ( Postgres could not connect to server: No such file or directory ) I've been using the homebrew ...
0
votes
2answers
6k views

Setting up PostgreSQL gives error sudo: initdb: command not found

Step 1: I installed PostgreSQL using sudo apt-get install postgresql-9.1 as recommended on the PostgreSQL website Step 2: I tried to run postgres. It's not found. For whatever reason, the install ...
0
votes
0answers
74 views

Postgresql stackbuilder not downloading any packages on Windows XP

This is a weird problem, I am facing. Postgresql Stack Builder doesn't download any packages. On Mac, Its downloading.! But, on Windows, It gives an alert saying "Failed to open ...
0
votes
2answers
1k views

Postgresql 9.2 where is the initdb located on Ubuntu

I am trying to install postgres on EC2 / EBS. I am following this article and stuck at the following step. sudo su - su postgres - /usr/pgsql-9.0/bin/initdb -D /pgdata I cant find the initdb ...
0
votes
1answer
51 views

Setting PostgresSQL for my VPS

I am about to deploy my app to a vps for the first time, and running into some issues while configuring my DB. After running the following commands... # PostgreSQL add-apt-repository ...
1
vote
0answers
86 views

Remove postgres from Mac that is installed in /usr/local/

I want to completely uninstall postgres and start from scratch - the version I have is refusing to work with PostGIS 2.0. I have read other answers on how to do this, but none of them seem to fit the ...
1
vote
2answers
294 views

PostgreSQL: Dump consistant state without locking

A good database backup is consistent, so the whole dump represents the state when the dumping was started. A typical strategy for this on MySQL is to lock the table, so no additional data can be ...
-1
votes
2answers
78 views

Torrentflux broke after upgrade [closed]

A working torrentflux setup seems to have gone broken after upgrading PHP to 5.3 and Postrgres to 9.2beta3 on a FreeBSD 8.2 server. The login screen will show up fine, but after clicking the login ...
1
vote
1answer
77 views

How to connect or set a specifig schema in LIBGDA database browser?

I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement: SELECT * FROM schemahere.tablehere; Or is ...
2
votes
1answer
703 views

User permissions for creating PostgreSQL DB

I'm working on Ubuntu. Following is one of my commands. $ psql -U kuser -d postgres Then this connects to the database. But from postgres terminal when i try postgres=> CREATE DATABASE kdb; ...
0
votes
1answer
273 views

How do I setup Java OpenID Server (JOIDS)?

I'm stuck on this step: Then you should modify the file in $CATALINA_BASE/conf/[enginename]/[hostname]/, especially the database and mail configurations, and the password for domain configurator(the ...
3
votes
1answer
3k views

Postgresql has broken apt-get on Ubuntu

On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
0
votes
1answer
554 views

Postgresql fails to start on Ubuntu 10.04.4 LTS

After I install and when restarting Postgresql I get this error. I have tried changing permissions accordingly(the owner of the all the directories and files in the error message is postgres) but to ...
0
votes
1answer
4k views

How to reset the postgres super user password on mac os x

I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it. All the directions I found ...
2
votes
1answer
494 views

(-bash: initdb: command not found) When installing postgres mac

I get the following error (-bash: initdb: command not found) in the terminal when trying to install postgres on my mountain lion mac osx? Also, does any one have a good resource for installing ...
0
votes
1answer
370 views

List of StopWords in Postgres 9.1

What is the list of stop words (ignored words) used by Postgres when doing fulltext searches? Is there a way I can find this out (by running a query or something)? So you know what I'm looking for, ...
1
vote
0answers
285 views

Mac OSX Mountain Lion Rails Postgres (wiped out a lot of stuff)

Having trouble with Postgres since I upgraded to Mountain Lion (and now regretting it). Lost hours trying to fix it to no avail. When running rails server then visiting my app at 0.0.0.0:3000 I get ...
1
vote
1answer
775 views

How do I add new users to PostgreSQL 9.1 on Mac OS X 10.6?

I am unable to run psql with my normal Mac user account in Terminal session, although I can do it using the postgres service account). When I enter the command psql mydb and type my password, I get ...
2
votes
1answer
649 views

Cannot start Postgres daemon after installing with Yum

I was trying to install Postgres 9.1.4 on Fedora 17 using Yum. If I do: sudo yum install postgres-libs sudo yum install postgres sudo yum install postgis All the installs appear to complete ...
0
votes
1answer
2k views

Mac updated just now, postgres now broken

I run postgres 9.1 / ruby 1.9.2 / rails 3.1.0 on a maxbook air for local dev. It's all been running smoothly for months, (though this is the first time I've done development on a mac.) It's a ...
4
votes
1answer
66 views

Is password required for restricted database servers [closed]

I have a dedicated Database server which is have PostgreSQL 9.1. This server has firewall. Only 10.0.0.3 is allowed to connect and access to this server via Firewall. All other requests from other ...
0
votes
1answer
310 views

I cannot get pg-0.14.0 gem installed after Mountain Lion install

I have been trying for some time now to get my Rails development environment back up since I upgraded from Lion to Mountain Lion. The problem is specifically installing the pg-0.14.0 (postgresql) gem. ...
2
votes
3answers
1k views

PostgreSQL Admin Tool for mac os X

I'm looking for desktop admin tool similar to phpPgAdmin for POstgreSQL in Mac os X . Any recomendation?
5
votes
1answer
6k views

How do I fix “Library not loaded: libssl.1.0.0.dylib” with PostgreSQL?

After deleting Macports, I've had some strange behaviour. When I try to run PostgreSQL via CLI, I get: pawel:~ pawel$ psql dyld: Library not loaded: /opt/local/lib/libssl.1.0.0.dylib Referenced ...
9
votes
1answer
4k views

PostgreSQL homebrew installation lacks config files

So I successfully installed PostgreSQL 9.1 on MacOSX Lion. Unlike people say, I didn't have to change the PATH and no other version of PostgreSQL was installed on the system ($ psql --version shows ...
2
votes
2answers
618 views

Help installing postgres in ubuntu

I'm trying to install postgresql in the latest ubunutu, and I'm following these instructions. When I sudo -u postgres psql postgres I get this error: could not change directory to "/home/james" I'd ...
7
votes
2answers
11k views

postgres ident authentication failed

I'm trying to set up django on a fresh Ubuntu VM. I'm following the tutorials along until I get to this: psycopg2.OperationalError: FATAL: Ident authentication failed for user "postgres" The ...
1
vote
1answer
1k views

How do I install the Postgres command-line client (psql) on OS X using MacPorts?

I'm trying to install the Posgtres command-line client (typically psql on Linux). I've got postgres installed through MacPorts (postgresql90 and postgresql90-server) but still don't see the client ...
0
votes
0answers
119 views

Terminal highlighting and auto complete

Do you know some plugin for highlighting and autocomplete in postgreSQL terminal?
1
vote
0answers
813 views

Running Postgresql on OSX

I'm trying to install Postgresql on OSX Lion. I'm using Homebrew, so my installation consisted of doing brew install postgresql initdb /usr/local/var/postgres Now when I try to start ...
2
votes
1answer
436 views

make pgrouting problem

I try to make pgrouting. What am I doing wrong? anton@anton-P4I45Gx-PE:~/src/pgrouting$ cmake -DWITH_TSP=ON -DWITH_DD=ON . -- POSTGRESQL_EXECUTABLE is POSTGRESQL_EXECUTABLE-NOTFOUND -- Found ...
0
votes
0answers
98 views

What enterprise tools exist for exporting from a database into a set of files?

I'm looking for software that's designed to select/query data from a database (SQL or NoSQL), and export it into files (CSV, XML). Ideal characteristics: Manage very large datasets (petabytes), ...
0
votes
1answer
2k views

How to change root password for PostgreSql phpPgAdmin?

What is the simplest way to change root password for PostgreSql phpPgAdmin ?
1
vote
1answer
528 views

Set collation order in shell sort to not ignore special characters

I am looking for a solution for sorting in postgres but it seems to be more of a problem of collation and therefore I ask the question for the standard Unix sort command instead. I have the following ...
0
votes
1answer
247 views

PostgreSQL Visualiser tools are slow

I just began working with PostgreSQL and have found both pgAdmin and Navicat to be really slow. Its slow to open a database, list the tables and list the first 100 rows. The db I'm looking at is very ...
0
votes
1answer
586 views

How can I fix this PostgreSQL installation error on Mac?

I am facing the following error upon PostgreSQL installation on MacOsX: sh-3.2# sudo port install postgresql84-server ---> Computing dependencies for postgresql84-server ---> Staging ...
0
votes
1answer
6k views

How to configure Postgresql (Ubuntu)

I installed postgresql in ubuntu but I am unclear how to start or configure it for a local server (apache) I tried typing (at the terminal prompt) psql but I am getting this error message: psql: ...
2
votes
2answers
737 views

PostgreSQL - syntax error

What is wrong with the following statement? GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO foo; I get this error ERROR: syntax error at or near "ALL" LINE 2: ON ALL TABLES ...
0
votes
1answer
2k views

How can I get a mysqldump file encoded in utf-8 for psql?

I am migrating some data from a MySql database (v5.1.44/MyISAM/collation=latin1_swedish_ci) to a PostgreSQL (v9.0.4/the one included in OSX Lion). I'm using $ mysqldump --compatible=postgresql > ...
1
vote
1answer
4k views

Trouble installing PostgreSQL 9 64bit on fairly fresh Windows 7 Pro 64bit [closed]

The installation proceeds most of the way without any issues. At the end, I get an alert saying that there was a "Problem running post-install step. Installation may not complete correctly. The ...
1
vote
1answer
91 views

How can I build an old application for 64bit?

I am trying to build postgresql 7.4.6 on a 64bit machine for 64bit. I'm not sure whether this code is 64bit compatible. Is there a way to check? If it is 64bit compatible, do I need to do anything ...
0
votes
1answer
8k views

How do I restore a plain text postgres .backup file

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is ...
2
votes
1answer
814 views

Searching a whole postgres db for a string

In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at ...
1
vote
2answers
76 views

How to I change the path when I log in as a new user in ubuntu?

I am running ubuntu on a flash drive. The default log in is "ubuntu". I installed Postgresql and created a new user called "postgres". However, when I switch to postgres with "su postgres", the ...
-1
votes
1answer
2k views

Setting up PostgreSQL on Mac OS 10.6.8 Snow Leopard?

I've installed PostgreSQL 9 on Mac OS. I need to change the configuration so that I can access Postgre with the blank password. Searching online yields lots of solutions for older versions of the ...
1
vote
0answers
1k views

Create a “postgres” user account on OSX?

I just made a mistake: I installed PostgreSQL on Mac OSX 10.6.7 and when I wanted to connect to it I did su postgres, then it asked me for a password and I did sudo passwd postgres to change the ...
1
vote
2answers
1k views

Free Database Browser for PostgreSQL?

Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...