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
545 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
285 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.
1
vote
0answers
952 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
1answer
50 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
224 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
1k 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 ...
1
vote
1answer
2k 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
59 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
3k 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
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 ...
0
votes
1answer
334 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
567 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
520 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
562 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
462 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 ...
2
votes
1answer
628 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
49 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
610 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
6k 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
402 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
311 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
3k 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 ...
2
votes
1answer
8k 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.
5
votes
3answers
9k 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 ...
14
votes
2answers
20k views

How do I connect to a PostgreSQL server using LibreOffice Base?

I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well): The following syntax ...
0
votes
2answers
1k 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
242 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 ...
5
votes
1answer
2k 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 ...
2
votes
1answer
48 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
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
1answer
420 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 ...
2
votes
2answers
482 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 ...
0
votes
1answer
316 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
1answer
788 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 ...
2
votes
1answer
11k views

NOQUEUE: reject: Relay access denied

I recently setup a mail server following the instructions on linode.com (https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql) except I am using postgreSQL instead of mySQL. ...
0
votes
1answer
90 views

Postgres DB table recovery

I was using PG Admin and modifying a table in my DB. I was actually adding two fields. Once done, I hit the OK button and PG Admin hung up. I think this is the first time. Now I cannot open that ...
0
votes
1answer
612 views

Postfix: change recipient_delimiter with virtual_mailboxes

I have an email setup using Postfix, Dovecot, PostgreSQL. I am trying to change the recipient_delimiter to be - (dash) instead of + (plus) but the address are being rejected. In order to get the + ...
0
votes
1answer
28 views

Some tricky configurations in postgreSQL

I'm trying to set up some security configurations over my server, but I've checked file postgresql.conf and I just managed to change the IP it listens to. What I am looking to do is the following: ...
5
votes
1answer
1k views

Calling the psql command without selecting any database

The syntax of the psql command line client is psql [option...] [dbname [username]] I am passing the command ALTER DATABASE x RENAME to y to this command: echo `ALTER DATABASE x RENAME to y` | psql ...
3
votes
3answers
200 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 ...
1
vote
0answers
344 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 ...
3
votes
2answers
640 views

Are PostgreSQL's database files binary compatible between Windows, Linux and Mac OS X?

Assuming 64-bit OS editions on each and only one copy of PostgreSQL running at a time, can I host my PostgreSQL database files in Dropbox and expect binary compatibility on all three platforms? I've ...
0
votes
3answers
182 views

Postgres configuration

I'm installing PosgreSQL 9.0 over FreeBSD 8.1. In MySQL I have to change the root SQL user's password, here how can I do? And how can I add other SQL users? Thanks.
1
vote
2answers
1k 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
40 views

Model for Cooperation in a class? [closed]

Assume you have six classes of students with low level of computer skills. They use Gmail inboxes to store old exam questions, notes and tips. Dropbox and Google Drive too, since Gmail inboxes get ...
0
votes
1answer
879 views

How to configure bi-directional replication on a single table in symmetricDS?

I have installed and configured the database replication software from http://www.symmetricds.org/ on the client and the server. I have followed the directions to setup the example replication, and ...
0
votes
1answer
631 views

Exception while configuring symmetricDS with postgresql on Linux

SymmetricDS is a java tool which can replicate databases and tables across an intermittent internet connection. I am having trouble configuring it to work with postgresql. I am doing this piece of ...
0
votes
0answers
510 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 ...
1
vote
1answer
826 views

How display result of multi select in PgAdmin III?

select 1 as a,4 as b, 5 as c; select 1 as a,3 as b; Result display only of `select 1 as a,3 as b; How display result of multi select in PgAdmin III?`
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 ...