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
2answers
24 views

Installing PostgresSQL on CentOS 6.4 without yum

I've got a company server running CentOS 6.4 on which I'm required to install the tools required for a webapp deployment. One of those tools is PostgreSQL server, however the company VPN is blocking ...
1
vote
0answers
12 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 ...
0
votes
1answer
61 views

Copying File From One User To Another

So I have this file stored in my account. It's postgres dump. To be able to use postgres it seems that I have to execute the following command. sudo su - postgres Once I do this I am now working as ...
0
votes
1answer
14 views

How do I configure Postgresql on Windows 8.1 to connect to Golang?

I'm trying to follow the tutorial here: https://gophercasts.io/lessons/4-postgres-basics but I'm having problems with the way in which the user is set up in Windows 8.1 (64-bit). The tutorial has a ...
1
vote
2answers
4k 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 ...
0
votes
1answer
2k views

ubuntu 13,10 “Failed to download repository information”

I have ubuntu 13.10- 64 bit version on my machine.recently i tried to install postgres for ROR development but i couldn't complete the postgres installation and found that my update manager always ...
0
votes
1answer
15 views

Check the contents of a PostgreSQL data directory

I have found an old unlabeled backup of mine with a PostgreSQL data directory in it. Is it possible to check its contents somehow, without installing PostgreSQL itself?
0
votes
1answer
2k 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
1answer
31 views

Error installing postgres on Windows 8

I am using a Windows 8 laptop as my dev server. I am trying to install postgres on my laptop, but I get the following error: Problem running post-install step. Installation may not complete ...
0
votes
1answer
2k 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
16 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 ...
0
votes
1answer
19 views

Is there a way to test Postgresql connection from VMware Fusion on a Mac?

I have some reasons to believe that VMware Fusion is not connecting to my postgresql database hosted on my Mac OS. Is there a way to test this connection from my Windows portion through VMware?
0
votes
1answer
58 views

How do I start Postgres on CentOS 6.5?

Whenever I try to start Postgres, it gives me an error. Even if I remove the directory it complains about, it still fails. [root@ip-172-31-15-65 init.d]# service postgresql start /var/lib/pgsql/data ...
0
votes
0answers
20 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
1answer
12 views

Is there a tool to manipulate pg_hba.conf programmatically (if not what comes closest)? [closed]

I'm looking for anything above the level of programmatic file manipulation, a command or a python library. There seems to be no alternative to editing the file (assuming that ...
0
votes
1answer
14 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
18 views

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS ...
0
votes
1answer
40 views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
0
votes
0answers
97 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
1answer
38 views

Postgresql starup script for second instance?

I need to run my second postgresql instance when linux boots. I added this command (like in postgresql documentation) in rc.local: /usr/lib/postgresql/9.1/bin/pg_ctl start -l logfile -D ...
1
vote
0answers
85 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 ...
0
votes
1answer
33 views

Can I tell if crashplan has backed up a particular file in a particular state?

I would like to be able to tell, programmatically, if CrashPlan has backed-up a particular file, including the current updates to that file. I.e., that the current contents of a file are backed up. ...
2
votes
3answers
171 views

SSH without password doesn't work with user postgres

I've tried manually adding the pub key to authorized_keys and authorized_keys2. I've also double checked the permissions on .ssh (700) and authorized_keys (644). I can login without password on the ...
1
vote
1answer
243 views

Need Tool to Extract ER Diagram fom PostgreSQL 9,1

Guys I need to compare 2 different databases running in PostgreSQL. I would like to use some tool to extract the diagram in a automatic way, Ive tried pgadmin3 and pgdesigner but they seem ...
0
votes
0answers
132 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
2answers
87 views

Change postgreSQL database user from windows user in CMD

i recently installed PostgreSQL on windows 7, each time i try to use CMD to execute SQL command, i get this error createdb: could not connect to database template1: FATAL: password authentication ...
0
votes
1answer
53 views

PostgreSQL does not start in ubuntu, says could not bind IPv4 Socket

I installed latest version of PostgreSQL. I tried to start with this command, bin/pg_ctl start -D testDB I got the following error message. LOG: could not bind IPv4 socket: Address already in ...
1
vote
1answer
69 views

How can I make my Upstart service depend on PostgreSQL?

I have a service configured as an upstart job. How do I make sure that PostgreSQL is running before my service is started? Ubuntu 14.04 here.
0
votes
0answers
11 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 ...
2
votes
2answers
2k 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
261 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 ...
0
votes
0answers
109 views

pgAdmin III - how to insert data into table

How can I insert the result of some function (e.g. point(0,0) or localtimestamp) into some cell in the edit data window of pgAdmin? I keep getting an error Invalid input syntax for type ...
0
votes
1answer
162 views

Simplest import of pipe-delimited text w/header to PostgreSQL

I am trying to create a database with several tables. One of the tables is intended to hold about 1.3 million rows of data from the U.S. Economic Census. The data is in a pipe-delimited text file. ...
0
votes
1answer
39 views

A few doubts about creating my own webhosting server

I just created a system administration website from scratch for one of my university's administration offices (for free) using a postgresql database. I have tested this new system for almost 3 weeks ...
1
vote
1answer
93 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. ...
0
votes
1answer
622 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
253 views

Any way to keep connection alive in pgAdmin without setting it on the server?

I am using postgres.heroku.com to host my databases. This means that I have no way of changing server settings. Therefore, the answer to this question does not help me. Heroku is not willing to change ...
0
votes
1answer
36 views

Only allow external PostgreSQL connections for specific database

I've got a Postgres server that's configured to only allow connections from localhost. I like that. However, I have a situation where I need to run a database that is accessible from something other ...
2
votes
1answer
555 views

How can I completely uninstall pgAdmin3 from OS X?

My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the ...
1
vote
0answers
272 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 ...
0
votes
1answer
145 views

How to edit PostgreSQL tables with a uuid primary key using IntelliJ's database Table Editor?

I have hooked-up PyCharm with my PostgreSQL database. All of my tables have a uuid column as their primary key. When I attempt to edit a row's value, I get the following error: [2014-03-05 17:31:08] ...
1
vote
0answers
263 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 ...
0
votes
1answer
169 views

How to configure PostgreSQL for best access from both Windows 7 host and Ubuntu 12.04 guest?

I have a new Ubuntu 12.04 installation freshly installed on VirtualBox, which in turn is running on a 64 bit Windows 7 machine with plenty of RAM. I would like to install PostgreSQL on this system in ...
0
votes
1answer
375 views

OS X Mavericks / Squirrel SQL Client / PostgreSQL 9.1

I have just downloaded and installed the Squirrel SQL client v3.5.0 (as 3.5.1 didn't work for me). I have also downloaded the PostgreSQL 9.1 jdbc client. When attempting to add the jdbc client ...
1
vote
2answers
81 views

Ensuring a complete uninstallation of PostgreSQL after a botched instal Windows)l

I recently attempted to install PostgreSQL on a Windows XP SP3 machine using the EnterpriseDB installer. The installation was not successful, probably because I did not remember to turn off my ...
0
votes
1answer
196 views

How to install hstore in Postgresql on Mac OSX?

I'm trying to install hstore in Postgres on Mac OSX 10.9, but I'm having major troubles with it. First I had some trouble getting psql to work after installing postgresql using brew, so I finally ...
0
votes
1answer
28 views

Change how PSQL shows queries

This is a minor issue, but it's driving me nuts. Anyways, on some of my servers I'm running PostgreSQL 8.4. When using PSQL (also 8.4), queries are shown with a less-like interface, which I'm quite ...
2
votes
2answers
362 views

Too Much Swapping, even though RAM is ~75% Empty

I have a VPS with 9GB RAM, 300GB HDD, 3 GB Swap, 7 Cores. The OS is CentOS 5.7 Final. I have postgres9.0 running on my machine, with proper tuning done (at least by book/wiki of PostgreSQL). What ...
4
votes
2answers
4k views

How can I create a database in PostgreSQL on Windows 7?

I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database. I tried with createdb mydatabase but I got this error message: createdb: could not ...
0
votes
1answer
95 views

How to start only one version of postgresql database, in this case 9.1?

I have installed postgresql 8.4 and 9.1 on same ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...