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

0
votes
3answers
76 views

Linux equivalent to Windows error code 3010?

I am fairly new to error codes and was trying to figure out an equivalent error code to Window's error code 3010 which states that an installation succeeded but requires a reboot. I tried looking ...
0
votes
1answer
76 views

Why does PgAdmin III give warning that PgAdmin.exe has disappeared from C drive?

So I'm currently working with PostgreSQL, PostGIS, p-mapper, and QuantumGIS to build a web-mapping system. And earlier this morning, I opened PgAdmin III just to check on my database, no editing, no ...
-1
votes
1answer
37 views

COmmunication between windows host and centos guest through vbox [closed]

I am trying to access the db which is there on my windows 7 machine through centos mounted on oracle virtual box. I am using python as the language, using Django. I have made the following changes ...
0
votes
2answers
189 views

Postgresql on linux ami

I'm a newbie to aws and postgresql I've launch an instance with quick wizard of linux ami 2013.03.01 It says that the instance include a repository access to postgresql - I thought that means that ...
0
votes
2answers
115 views

redirect output from rpm -Uvh postgresql91-*.rpm

I have a bash script to install postgresql part of the script contains this command rpm -Uvh postgresql91-*.rpm i need to direct ALL the output generated by this rpm command into a log file FROM ...
0
votes
2answers
293 views

How to manually install PostgreSql on Redhat

I have to install PostgreSql onto Redhat. I cannot use YUM. I have downloaded these rpm's postgresql91-9.1.9-1PGDG.rhel5.x86_64.rpm postgresql91-contrib-9.1.9-1PGDG.rhel5.x86_64.rpm ...
0
votes
0answers
184 views

Discourse won't restart after a server reboot.

I had an instance of Discourse up and running on my Virtual Private Server. I'm configuring the application and all of a sudden mails stop working. In attempt to get mail working I get the bright ...
0
votes
1answer
227 views

How do I install PostgreSQL 9.1.4 on RHEL 5?

I specifically need version 9.1.4 --- unfortunately there are no ifs, ands, or buts. It's not my decision. I have downloaded the .run file available from PostgreSQL's SourceForge listing, but I can't ...
0
votes
1answer
454 views

How to recompile the PHP with --with-pgsql

I have installed the postgresql, php and apache to Amazon Linux AMI. Now I want to use the phpPgAdmin, it prompts "Your PHP installation does not support PostgreSQL. You need to recompile PHP using ...
2
votes
0answers
125 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 ...
0
votes
0answers
346 views

PostgreSQL installation on Debian: “Sub-process /usr/bin/dpkg returned an error code (1)”

apt-get install postgresql Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: postgresql 0 upgraded, 1 ...
0
votes
0answers
251 views

Cannot connect to Postgresql fresh install

I recently installed Postgresql to start developing with Python, but I cannot get the server to work properly. After installing with yum, from Fedora repositories (not from Postgres' website) and ...
0
votes
2answers
841 views

pgAdmin list of keyboard shortcuts

I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu. ...
0
votes
1answer
136 views

Difference between `/var/lib/pgsql/9.1/data/pg_hba.conf` and `/var/lib/pgsql/pg_hba.conf`

From http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html, it says: A default pg_hba.conf file is installed when the data directory is initialized by initdb. I would assume when ...
1
vote
3answers
186 views

Difference between `/sbin/service postgresql-9.1 start` and `/etc/init.d/postgresql-9.1 start`

I have seen two ways to start a postgresql server: /sbin/service postgresql-9.1 start /etc/init.d/postgresql-9.1 start Could anyone explain the difference between these two? Or there's no ...
1
vote
1answer
661 views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
3
votes
3answers
5k views

Install postgresql 9.3 on ubuntu 12.04

I am attempting to install PG 9.3 on Ubuntu 12.04 ---- Begin output of apt-get -q -y install postgresql-client-9.3=9.3~beta1-1.pgdg12.4+2 ---- STDOUT: Reading package lists... Building dependency ...
0
votes
1answer
456 views

PostgreSQL Windows installation failure

I was trying to install PostgreSQL 9.2 in Windows 7. When I launched the installer, it failed and showed the error message: Unable to write inside TEMP environment variable path I did a lot of ...
0
votes
1answer
626 views

Oracle11g localhost:1158/em not connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
1
vote
0answers
177 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 ...
0
votes
0answers
142 views

PHP - adding PostgreSQL (and other) modules doesn't work - debian 6

I try to install nginx + PHP 5 (FastCGI) + PostgreSQL on my Debian 6 VPS and I have a problem with adding new modules, especially pgsql. My phpinfo() shows "PDO drivers: no value" and of course ...
0
votes
1answer
420 views

Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe. I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver. When I go into Excel bring in the ...
1
vote
1answer
415 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
0
votes
1answer
237 views

Access PostgreSQL on Mac without switching users

I've got a Mac running OS X Lion (10.7.5), with PostgreSQL 9.2.4 installed. I've initialized a database cluster and started a server, all as the postgres user. When I try to access certain ...
0
votes
0answers
82 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
2answers
3k views

Default password for postgreSQL

What is the default password for the "postgres" user when I install postgreSQL on Windows? I googled for "postgres default password" but it doesn't return any immediate result.
1
vote
1answer
314 views

PostgreSQL installed from source, no pg_config alias

So I installed pgsql 9.0.10 on Ubuntu 12.10 from source (./configure, make, make install). It all went well, created /usr/local/pgsql/ and everything that it should contain, but I have encountered one ...
0
votes
1answer
134 views

where do I put my `pg_hba.conf` file in EnterpriseDB for OS X

I have a pg_hba.conf.sample file, but no pg_hba.conf file. I want to make one and put it in the right place. Where do I put pg_hba.conf?
0
votes
1answer
117 views

Upgrading PostgreSQL via Homebrew

I'm attempting to update PostgreSQL from my system's version (9.1.5) to the latest release (9.2.3). I've followed the directions on this railscast and am encountering issues. After installing psql ...
0
votes
1answer
641 views

Debian PostgreSQL doesn't appear to be working

I've just set up a server running Debian 6.0 64-bit. I've installed PostgreSQL through aptitude, and now i try to access PostgreSQL without any luck. I am trying to access psql as the user postgres, ...
2
votes
1answer
915 views

PostGreSQL Authentication Failure with “trust” option

I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
0
votes
1answer
202 views

Watch folder and import into database

I am trying to set up a system that whenever a new file is created in a folder it will automatically read the content and push it in a database. These files will mainly be .txt files but I might have ...
0
votes
1answer
58 views

How to change output pattern in shell?

I run the psql command from a Linux shell. The resulting output looks like a table: Name Age ----------------- John 24 But I would like to get the result with commas like ...
0
votes
1answer
163 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
905 views

Homebrew postgres won't start after uninstall, reinstall and reboot

I uninstalled and reinstalled postgresql via homebrew. It worked fine until I restarted my computer. Now I'm trying to run my tests and they're blowing up. I'm looking at the current processes and I ...
3
votes
1answer
318 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 ...
0
votes
1answer
677 views

How to install PostgreSQL 9.2 on CentOS 5?

PostgreSQL 9.2 isn't available on CentOS (the latest version is 8.1), so in order to get it, one has to add a postgre repository with the command rpm -ivh ...
1
vote
1answer
2k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
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
1answer
212 views

rsync fails under daemon but succeeds when run from terminal

I have script [1] that is executed by Postgres daemon (WAL archiver) and fails with exit code 12; see [2]. But if I execute the same script on a terminal/ssh session, it succeeds; see [3]. User ...
1
vote
2answers
353 views

PhpPgAdmin: Edit contents

How can I edit the contents of a table in phpPgAdmin without using SQL? Or is there an alternative tool that allows me to edit datasets?
0
votes
1answer
1k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
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 ...
3
votes
3answers
109 views

heredoc prompts not passed in

I'm trying to automate the creation of a PostgreSQL user with a bash script. I'm specifying the initial password as prompted by the "createuser" command, and I'd like to do it in bash, which I think ...
3
votes
1answer
703 views

Connection to postgresql inside Virtualbox via portforwarding fails

I have a postgresql server inside a virtualbox created by vagrant. I have also set up a portforwarding from 5432 inside the box to 15432 on the host system via the Vagrant file. When connecting via ...
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 ...
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 ...