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

1
vote
1answer
103 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
2k 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
455 views

Connect to PgSQL, DROP existent DB, recreate it using CREATE and run some queries alone and from files using Bash script

I need some advice creating a script for help me with repetitive task I do all the time on a development environment. I've a PostgreSQL server and since I'm developing a web application I need to ...
2
votes
3answers
4k 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 ...
1
vote
1answer
570 views

Make phppgAdmin accessible on Apache/Windows 7

I have my custom stack folder located here... C:\MEDIA\INTERNET\WAPP\ I have Apache located here... C:\MEDIA\INTERNET\WAPP\Apache 2.4\ I have PostgreSQL located here... ...
0
votes
1answer
87 views

PostgreSQL BitRock Installer Hangs

While installing PostgreSQL the BitRock installer hangs when it reaches the point that it should copy the files. There were very few things that came up on search engines for Windows 7, I tried netsh ...
0
votes
1answer
241 views

How to compare databases?

I tried using meld on two dumps from two different databases from the same RDBMS, but it seems that those dumps are not comparable because not being canonical. I tried both pg_dump ... (standard) and ...
0
votes
1answer
2k views

PostgreSQL 9.3 denying remote connection from user despite pg_hba.conf/postgresql.conf configurations

I am running PostgreSQL 9.3 on ubuntu 14.04 LTS. It is the stock Postgres distribution available in apt. I found a bunch of threads in various forums that indicate that the correct way to allow remote ...
1
vote
0answers
33 views

Postgresql: How do full_page_writes help prevent data loss?

From the postgresql docs [full page writes are] needed because a page write that is in process during an operating system crash might be only partially completed, leading to an on-disk page that ...
1
vote
1answer
163 views

How do I know if my Postgres table is clustered?

I have some tables in my Postgres database, and I have set the tables to cluster about an index. But I forget when was the last time I ran cluster maintenance on these tables, and I do not want to ...
0
votes
1answer
630 views

How to get crontab to run when backup requires a password

I am running a script to backup my postgres database on Debian. I am basically running exactly this: https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux Now I have everything working fine when ...
0
votes
1answer
113 views

tsvector type does not exist in Postgres 8.2.15 - how to fix?

I've been working on setting up a Greenplum DB with the server VM at https://network.pivotal.io/products/pivotal-gpdb This VM runs Greenplum on Postgres 8.2.15. I need to set up a text search ...
0
votes
1answer
668 views

Metasploit wouldn't work with the database

I am running Arch Linux on my i386 laptop. I've made a fresh install of ruby1.9 and metasploit from AUR and now I'm experiencing some weird stuff with it. First, it does not load any modules upon ...
0
votes
1answer
1k views

postgres creating new user/role

I am following this tutorial, and being logged in as postgres I run: createuser --interactive provided name and choosen superuser then: createdb dogspot but when trying sudo -i -u dogspot I get: ...
0
votes
1answer
137 views

Delete PostgreSQL data and Library directories on Mac

I want to completely clean PostgreSQL off of my Mac. I ran the uninstaller and that removed everything but the data and Library directories. I want to get rid of these two directories as well, but ...
0
votes
1answer
630 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 ...
1
vote
2answers
2k views

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h ...
0
votes
0answers
732 views

Postgresql 8.4 service not starting windows 7

Hi All i am not able to start Postgresql service from service manager in windows-7. Error 1053: The service did not respond to the start or control request in a timely fashion although pg_ctl is ...
0
votes
2answers
1k 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
280 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
650 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
26 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?
1
vote
0answers
371 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
360 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
124 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
158 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
56 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
536 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
6k 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
1answer
267 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 ...
2
votes
0answers
980 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
262 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
617 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
909 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
1answer
793 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
454 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
1k 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
60 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
341 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. ...
7
votes
1answer
5k 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
76 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
5k 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
551 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
648 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
824 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
644 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
900 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
928 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
83 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
873 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 ...