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
1answer
8 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 ...
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?
-2
votes
1answer
27 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
0answers
13 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
45 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
1answer
16 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
0answers
19 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
17 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
37 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
84 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
36 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
79 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
32 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. ...
0
votes
0answers
118 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
83 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
49 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
63 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 ...
0
votes
0answers
245 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
106 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
146 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 ...
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 ...
0
votes
1answer
239 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 ...
1
vote
0answers
263 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
257 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
140 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] ...
0
votes
1answer
165 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 ...
2
votes
1answer
536 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 ...
0
votes
1answer
364 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
80 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
188 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 ...
0
votes
1answer
91 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 ...
2
votes
2answers
69 views

Install postgres without apt-get

I have access to a machine on a scientific hpc, and I'm setting up an environemnt to create a web application, made up basically of TOMCAT and postgresql. I cannot use another web server. The OS is ...
0
votes
2answers
353 views

Unable to get Postgresql commands to work in terminal

After installing Postgresql by dragging folder into my applications folder I am unable to get commands to work in the terminal and unable to add the path so that is shows up using the command $ echo ...
0
votes
1answer
194 views

How do I execute/run a .sql file in PostgreSQL 9.2.6 + CentOs

I would like to know how to execute a .sql file in PostgreSQL. I'm using CentOs 6.4. I have created a database and just need to run a script given to me to create tables. Thanking you in advance.
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
0answers
63 views

PostgreSQL: pg_upgrade does not run on Windows

I'm trying to run pg_upgrade on Windows 8.1. I am the Administrator user. I have the postgres service turned off. I do RUNAS /USER:postgres "CMD.EXE" SET PATH=%PATH%;C:\Program ...
0
votes
2answers
872 views

Upgrade directly from PostgreSQL 9.1 to 9.3

Can I upgrade directly from PostgreSQL 9.1 to 9.3? Or should I upgrade to 9.2 first? I'm using Windows 8 and am planning on using pg_ugrade(); I tried to do this and pg_upgrade() froze on me. No ...
2
votes
2answers
58 views

2 instances of postgresql but I really need one

I happen to have 2 installed instances of postgresql at my machine: 9.1 and 9.2: sudo service postgresql status 9.1/main (port 5432): down 9.2/main (port 5433): down They are located at ...
0
votes
0answers
42 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 ...
1
vote
1answer
92 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
2answers
211 views

Running a test database on RAM disk

Is it possible to create and start a Postgresql server as an unprivileged user with data directory owned by the same user? I want to run tests and create a test database for it, the data files being ...
2
votes
1answer
35 views

Why does `psql --file` misinterpret tilde?

Earlier I used pg_dump to create a database backup in my home directory called book_dump.sql. I want to restore the backup to an empty database called book. To restore the backup, I tried this ...
0
votes
1answer
198 views

Installing Unity Asset Server on Debian has problems with postgresql

I used to have Debian Lenny (non-VPS, dedicated hosting) and Unity Asset Server (Unity3D's version control) was running smoothly. But recently I moved to Debian Squeeze (running on VPS) and I can't ...
0
votes
0answers
178 views

Can't install pg gem on mac os x Lion

Im using Mac OS X 10.7.4 Trying to install pg gem to work with PostgreSQL. Typing: sudo gem install pg Got This answer: Building native extensions. This could take a while... ERROR: Error ...
0
votes
1answer
275 views

How come the shell for my Mac can't find the postgresql command?

I just installed PostGreSQL on my Mac. I'm sure of that since I can open up the pqsl shell just fine via clicking on However, when I try calling postgres -D /usr/local/pgsql/data in terminal to ...