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

3
votes
1answer
415 views

Ubuntu postgresql missing man pages, PGDATA, and critical commands

I installed postgresql as well as postgresql-doc, nevertheless it seems that ubuntu either does not put commands in my path, or if it does put them in my path, it removes the man pages for the ...
2
votes
1answer
69 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 ...
2
votes
1answer
628 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 ...
1
vote
1answer
16 views

How do I know if my Postgres table is clustered?

I have some tables in my Postgres database, and I have set the tables to cluster about an index. But I forget when was the last time I ran cluster maintenance on these tables, and I do not want to ...
1
vote
1answer
132 views

Chef and PostgreSql

With amazon annoucing postgresql service in RDS, can we setup chef-server(11) with amazon rds postgresql database, rather than using the default databse that gets installed with the omnibus installer. ...
1
vote
1answer
76 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
1
vote
1answer
3k views

Setting up postgresql server connection with pgadmin3 fails with Exception

I have installed postgresql database on Fedora 17. When I create a new server connection through pgadmin3, I get this Error in a popup window: postgresql The server doesn't accept the current ...
2
votes
0answers
146 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
2
votes
0answers
214 views

Could not open log file “pg_log/postgresql-Sun.log”: No such file or directory

After installing postgresql on fedora 17 using the yum package manager. When I try to start it I get the error message. [vagrant@example ~]$ sudo /sbin/service postgresql status Redirecting to ...
2
votes
0answers
127 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 ...
2
votes
0answers
351 views

How to copy and paste content from PostGIS psql console in Windows 7?

I just get started with POSTGIS and I am digging through Mannig's POSTGIS in Action. I am using Windows 7, POSTGIS 1.5 and Postgresql 9. Sadly, I am not able to copy and paste anything from my text ...
1
vote
0answers
10 views

Postgres won't start after restore point

i'm having a problem with postgresql. Everything was working fine until my computer crashed and windows did a restore checkpoint thing. After that it was a nightmare. Normally I would start postgresql ...
1
vote
0answers
30 views

PostGreSQL DB - phpPgAdmin using XAMPP

I have installed PostgreSQL Database in Linux server system. XAMPP is installed on my local system. I have followed the steps in install phpPgAdmin . But I still could not access the phpPgAdmin page ...
1
vote
0answers
17 views

How do I pipe 7za output directly to psql?

I have a Postgres database dump in a .7z archive. I can extract it and import it with: 7za e dump.7z dump psql -h localhost db_name < dump but I'm just running out of disk space. What is the ...
1
vote
0answers
20 views

Postgresql: How do full_page_writes help prevent data loss?

From the postgresql docs [full page writes are] needed because a page write that is in process during an operating system crash might be only partially completed, leading to an on-disk page that ...
1
vote
0answers
183 views

Questions on compiling homebrew php with postgres support on Mavericks

I recently upgraded to Mavericks on my MacBook Pro and a few things broke in the process. One of these was the ability to load a drupal page that sits on a postgres database. I get this message on a ...
1
vote
0answers
152 views

iptables configuration on Windows Azure (CentOS 6.5) for endpoint load-balanced set

I created 2 VMs (CentOS6.5) on Windows Azure for Postgresql database and HA cluster, everything works fine except when I set iptables service on, the endpoint load-balanced set is down. for security ...
1
vote
0answers
462 views

Installing and running two postgresql versions on different ports (or two instances of same server)

I have postgresql 9.1 installed on my machine (Ubuntu). I need another postgresql server that would run next to the old one. Exact version does not matter, but I'm thinking of using 9.2 version. How ...
1
vote
0answers
509 views

Unable to Import Postgresql Database into Amazon AWS Database

I have a Postgresql 9.3 database locally which needs to be 'restored' to an Amazon AWS database. I am able to restore this database to various local Postgresql servers but on Amazon, using pgAdminIII ...
1
vote
0answers
658 views

postgres: unable to install postgresql-contrib-9.1

My system version is Ubuntu 13.10 64bit. I encountered this problem by setting up PostgreSQL in a Rails app. First I ran rake db:migrate and it showed an error: -- enable_extension("hstore") rake ...
1
vote
0answers
713 views

Postgresql query within a bash script

We are having an issue with a postgresql bash query. The output of the query from the bash script add's additional quotes around the date. Please can you help me fix it?! Script: #!/bin/sh ...
1
vote
0answers
536 views

upgrading from postgresql 9.1 to 9.3 on ubuntu server with data intact

I have my production server(ubuntu 13.10) running with postgresql 9.1. I want to use few features of 9.3, hence want to upgrade. Could someone help me with upgrading from 9.1 to 9.3 so that there ...
1
vote
0answers
302 views

Ubuntu login screen doesn't show up after installing postgresql

I just installed Ubuntu 12.04 on my new machine and everything works fine. However, when I install postgresql and shut down the computer, when I log back in, there's no graphical login screen. The ...
1
vote
0answers
87 views

PostgresSQL giving blank screen on installation on Windows 64 bit

I downloaded postgresql-9.2.4-1-windows-x64. When I ran the exe it just gave me a blank screen. I tried "run as admin" but still the same result. I even uninstalled my anti-virus (Security ...
1
vote
0answers
312 views

installing redis server on an ec2 instance where postgres is installed

I have an ec2 microinstance. I have installed only my postgressql database server over there. I want to try redis for celery backend and also for some realtime value storing. I am expecting as of ...
1
vote
0answers
289 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
0answers
876 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 ...
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
0answers
578 views

Installation on Linux & Win7: Aptana, PostgreSQL, Ruby, JQuery (WWW on Apache)

Basically I have 2 systems, where I want to develop (and use) my application: A Linux (Debian) system. This is my server. Here I have PostgreSQL (& phpPgAdmin), Apache, Ruby. Typically I use ...
1
vote
0answers
450 views

Can't view database structure via pgAdmin, while psql works ok

I have a PostgreSQL database. I can connect to it via psql no problem, however, when I do database listing: my_database=>\l there is no my_database in the list! When I connect to this same ...
0
votes
0answers
15 views

Cannot start PostgreSQL: postgresql-upgrade is missing

Yesterday I upgraded my Fedora from 19 to 20. And now I cannot start PostgreSQL because of old database format. The steps are: 1. # systemctl start postgresql Job for postgresql.service failed. See ...
0
votes
0answers
79 views

Failing to start Postgres SQL Server on Centos

I just followed this tutorial: http://www.unixmen.com/postgresql-9-4-released-install-centos-7/ But I can't start my postgres sserver on my centOS 6.5 machine. Here's the error: [root@vm5 ~]# ...
0
votes
0answers
6 views

SquirrelSQL does not display schema owned by another user (Postgres)

I've noticed that SquirrelSQL (v3.6) does not display schemas in a Postgres (v9.2) database if it is owned by another user, even if I'm connected to the database on superuser. When I do alter schema ...
0
votes
0answers
26 views

Cannot connect to Postgres 9.3 outside of network

I'm trying to remotely connect to my postgresql database. I can connect remotely within my network but when i try to access it from outside the network I receive the error: Could not connect to ...
0
votes
0answers
14 views

Rails Server Not Serving Correctly

Having some issues actually serving my rails app, the server seems to run fine, and I'm incurring no permission errors, or even port bound already errors, nothing at all, but yet the app does not ...
0
votes
0answers
26 views

Why am I getting “FATAL: Ident authentication failed for user ”root“” after changing rails server to port 81

I was running my rails app on the default port of 3000. I opened port 300 with: sudo iptables -A OUTPUT -o eth0 -p tcp --sport 3000 -m state --state ESTABLISHED -j ACCEPT and sudo iptables -A ...
0
votes
0answers
149 views

Trouble installing PostgreSQL via npm on Windows 8

I've installed PostgreSQL on my (Windows 8) computer via the binary installer but it's a dependency for something I'm making so I want to install it via the command line to the project's directory. ...
0
votes
0answers
181 views

Postgresql 8.4 service not starting windows 7

Hi All i am not able to start Postgresql service from service manager in windows-7. Error 1053: The service did not respond to the start or control request in a timely fashion although pg_ctl is ...
0
votes
0answers
20 views

Debian - Postgresql can't install /etc/postgresql after purge

While trying to install DAVICAL on debian wheezy (7.5) I faced a problem and had to purge the postgresql package that is a davical requirement, and then tried to install it again. The installation ...
0
votes
0answers
54 views

PostgreSQL service password is reset after each Windows update

Daminion Server (the server based photo management software) installation insludes the PostgreSQL installation. All is Ok after installing the both Daminion and PostgreSQL services. However after ...
0
votes
0answers
216 views

Problems installing postgresql-9.3.4-4-windows-64 on windows 7

I am trying to install postgresql-9.3.4-4-windows-64 on Windows 7 x64 and keep getting the error message: Error. There has been an error. Unable to write inside TEMP environment variable path. ...
0
votes
0answers
26 views

how to set default data type for create table in dbvisualizer

I am creating a postgresql database in DBVisualizer. Things would go faster if I could gain control over the default data type I get when I create a column. For Postgresql, it defaults to bigint and ...
0
votes
0answers
64 views

How to increase IO for operation “SELECT”?

I use windows server 2008r2 with role Hyper-V. The guest system is Ubuntu 12.04 LTC (64 bit). It is situated on the dynamic virtual hard disk /dev/sda. There is postgresql-9.1 (amd64) on the Ubuntu ...
0
votes
0answers
402 views

Failing to setup postgres on raspberry pi

I installed postgresql on my raspberry pi. then, i try to access it and I get: pi@raspbmc:~$ psql psql: FATAL: role "pi" does not exist pi@raspbmc:~$ psql -U postgres psql: FATAL: Peer ...
0
votes
0answers
103 views

Network goes “Request Timed Out” when I run a query

I use postgreSQL 9.2 as the database and Java 6 as the programming language. There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
0
votes
0answers
76 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
0answers
98 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
0answers
149 views

Terminal highlighting and auto complete

Do you know some plugin for highlighting and autocomplete in postgreSQL terminal?
0
votes
0answers
108 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
0answers
510 views

PostgreSQL hangs regardless of which command I execute

The title pretty much sums it up. I'm running PostgreSQL 9.0.0 and am running a database that's using PostGIS. In more detail, the table that I'm having issues with is a monster. The table names have ...