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
0answers
7 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
9 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
16 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
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 ...
-1
votes
0answers
17 views

How to disable prepared statement in heroku with postgres database

I fixed an issue on my rails project locally (with postgres config) while adding in database.yml this statement: test: prepared_statements: false It fixed a bug with the following stack trace: ...
0
votes
0answers
6 views

Postgres memory usage too low [migrated]

I have a 400GB postgres 9.3.4 DB running on Fedora20, and a few indices per table. I have upped shared buffers to 4GB (the system has 16GB available), set shm in the kernel and set the ...
0
votes
1answer
27 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
70 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
458 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
68 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
26 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 ...
1
vote
1answer
148 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
39 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
50 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
45 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
52 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
197 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
42 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
78 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
17 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
284 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 ...
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 ...
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
43 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
40 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
84 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
82 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.
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 ...
11
votes
2answers
13k 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
1answer
928 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
2answers
680 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 ...
0
votes
0answers
42 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 ...
2
votes
2answers
41 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 ...
3
votes
1answer
706 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
30 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
27 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
164 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 ...
1
vote
2answers
137 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
157 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
138 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
135 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 ...
1
vote
1answer
49 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
1answer
751 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
31 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
160 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
21 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
95 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 ...
0
votes
0answers
21 views

Attach a new EBS volume to an existing EC2 db server instance

I had a micro instance of EC2, wherein I put my PostgreSQL database server. The EC2 instance came with the default Block Store. As of now, I want to attach a new Block Store to the existing EC2 ...
3
votes
3answers
110 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
181 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 ...