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
0answers
439 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
274 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
152 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
414 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
40 views

Cannot configure PostgresSQL extension for php in Cpanel

I have a Centos 6.6 x86_64 vps cloud server with WHM and cpanel. It contains easyapache installed in it and working fine. php sites are working fine with it. I have installed PostgresSQL 9.3 in the ...
1
vote
0answers
24 views

Permission denied trying to setup postgres sql

I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on. So, When I try to ...
1
vote
0answers
51 views

I'm trying to install PostgreSQL onto Ubuntu 14.04, but I am having difficulties after following a guide

I originally followed the guide at http://www.postgresql.org/docs/9.2/static/runtime.html. It instructed me to install postgres-xc, which is meant for making clusters of databases. On other sites, I ...
1
vote
0answers
239 views

Can't install libpq-dev on debian wheezy

I already have deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main in my /etc/apt/sources.list file. I have tried to follow the dependency trail but I have reached a dead end. This is how ...
1
vote
0answers
34 views

Is there a way to let PostgreSQL restore but not create a new timeline

I'm using PostgreSQL 8.4 and am creating a standby server. Since PostgreSQL 8.4 doesn't have built-in replication support, I did the following things try to get read only access to the standby server, ...
1
vote
0answers
65 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
199 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
27 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
217 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
239 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
664 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
741 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
956 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
816 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
568 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
347 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
118 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
388 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
914 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
623 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
493 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
5 views

Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql

I want to pull data from a PostgreSQL database on my local network with Power Query. By default my version of Excel lists three options under the "Get External Data/From Database" menu on the Power ...
0
votes
0answers
29 views

Why would updating postgresql-client uninstall postgresql?

On a Debian 7 server, apt-get was offering me to upgrate the following 2 packages: postgresql-9.1 and postgresql-client-9.1. Since I didn't want to restart the database server, I decided only to ...
0
votes
0answers
13 views

How to connect psql to the forumdb.py(a python file) in ubuntu?

I have my system with UbuntuOS installed. I am following an online course where it indicates the use of Vagrant and connects your Windows/Mac system using the Virtual Box having Linux installed in it. ...
0
votes
0answers
30 views

I can't loign as postgres user

I have recently done a backup using Time Machine, shifting the data from a Mac mini to a Macbook pro. In this process I lost the possibility to access to postgres with my user. I can see the user on ...
0
votes
0answers
23 views

How to check database relationships in PostgreSQL?

A guy made a DB design on MS Server 2010 and managed to import the schema to my PostgreSQL database, the thing is we want to check if the existing relationships were imported as well, how do i do ...
0
votes
0answers
35 views

Upgrade Postgres from 9.2.2 to 9.3.6

I have an old server with a Postgres 9.2.2 database. Now I have a new server which has a Postgres 9.3.6 database. I copied the data-directory (/var/lib/pgsql/data) from the old server on the new ...
0
votes
0answers
39 views

Revit DBLink fails to import from PostgreSQL ODBC driver

I am trying to export and import back a Revit 2014 model. I am also using PostgreSQL 9.3/9.4 as backend DBMS. I am able to export correctly the Revit model to a database in PostgreSQL but not the ...
0
votes
0answers
172 views

Making a pgAdmin connection to PostgreSQL running on VirtualBox

I have a CentOS 6.5 development server that I installed postgresql on. It runs fine and I can connect to it from my computer using pgAdmin all works perfectly. I recently created a backup of this ...
0
votes
0answers
22 views

If pg_dump with -o is enough?

Postgres says using pg_dump with -o switch keeps the OIDs of each row and it is useful for those applications that count on OIDs. I have a may be trivial question. Does it mean if we get dump by -o, ...
0
votes
0answers
1k 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
13 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
60 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
28 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
52 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
183 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
371 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
24 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
82 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
276 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
77 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
513 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
120 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
79 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 ...