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
0answers
675 views

Can't install libpq-dev on debian wheezy

I already have deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main in my /etc/apt/sources.list file. I have tried to follow the dependency trail but I have reached a dead end. This is how ...
1
vote
0answers
105 views

Is there a way to let PostgreSQL restore but not create a new timeline

I'm using PostgreSQL 8.4 and am creating a standby server. Since PostgreSQL 8.4 doesn't have built-in replication support, I did the following things try to get read only access to the standby server, ...
0
votes
1answer
575 views

Install Postgresql 9.4 with Puppet

I would like to let Puppet manage Postgresql 9.4 on Ubuntu 14.04.2 LTS. I have install the https://github.com/puppetlabs/puppetlabs-postgresql module and configured it like this for 9.3: class { ...
1
vote
2answers
256 views

ERROR: could not load library “/usr/lib64/pgsql/hstore.so”: /lib64/libc.so.6: version `GLIBC_2.14' not found

I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past: ERROR: could ...
2
votes
1answer
1k views

Make Wine run its applications as user profile, not Administrator

For a very specific case, I need to install PostgreSQL under Wine to run a Windows application that packs it's own installation of PostgreSQL even if PostgreSQL is already installed, for security ...
2
votes
1answer
135 views

Script stops when user is changed

I am trying to create a script that logs as a different user to create a database backup. So far I have encountered a few problems, such as having to input sudo password, or not being able to bypass ...
0
votes
1answer
34 views

CentOS6 Backup fails; “permission denied”

I am currently trying to do a backup of a server and am getting an error message when running my script. The script runs correctly on certain directories, but for the directory I am attempting to use ...
-2
votes
1answer
3k views

OSX: Snort: ERROR: /etc/snort/../rules/local.rules(0) Unable to open rules file “/etc/snort/../rules/local.rules”: No such file or directory

I'm trying to setup and run Snort IDS on mac using this kinda tutorial: https://discussions.apple.com/thread/3370709?start=0&tstart=0 OSX Yosemite (10.10.2); PostgreSQL 9.4.1 (installed with ...
0
votes
1answer
128 views

postgres -w flag breaking systemd

So I am pretty new to Arch and am having a strange issue. Using systemctl I can not start postgresql. Starting postgresql directly with pg_ctl works fine and it is even started briefly with systemctl. ...
-1
votes
1answer
723 views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
0
votes
1answer
68 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
2answers
2k views

CentOS 7 install PostgreSQL dependency error

When running yum install postgresql-server.x86_64, I encounter the following error: --> Processing Dependency: libreadline.so.5()(64bit) for package: postgresql-server-8.1.23-10.el5_10.x86_64 ...
1
vote
1answer
54 views

dd fails in postgres backup from one server to another

I've got a server which is running out of space. Unfortunately it doesn't even have enough space anymore to backup a postgres database I've got running on it. So I now want to backup the running ...
9
votes
3answers
2k views

Error while trying to start Postgres installed via Homebrew: Operation not permitted

I have recently installed Postgres on my Mac via Homebrew. (I may have already had it installed it was not running) brew install postgres ln -sfv /usr/local/opt/postgresql/*.plist ...
0
votes
0answers
41 views

If pg_dump with -o is enough?

Postgres says using pg_dump with -o switch keeps the OIDs of each row and it is useful for those applications that count on OIDs. I have a may be trivial question. Does it mean if we get dump by -o, ...
0
votes
1answer
291 views

Cannot start PostgreSQL: postgresql-upgrade is missing

Yesterday I upgraded my Fedora from 19 to 20. And now I cannot start PostgreSQL because of old database format. The steps are: 1. # systemctl start postgresql Job for postgresql.service failed. See ...
1
vote
0answers
126 views

Postgres won't start after restore point

i'm having a problem with postgresql. Everything was working fine until my computer crashed and windows did a restore checkpoint thing. After that it was a nightmare. Normally I would start postgresql ...
1
vote
0answers
431 views

PostGreSQL DB - phpPgAdmin using XAMPP

I have installed PostgreSQL Database in Linux server system. XAMPP is installed on my local system. I have followed the steps in install phpPgAdmin . But I still could not access the phpPgAdmin page ...
0
votes
1answer
3k views

Failing to start Postgres SQL Server on Centos

I just followed this tutorial: http://www.unixmen.com/postgresql-9-4-released-install-centos-7/ But I can't start my postgres sserver on my centOS 6.5 machine. Here's the error: [root@vm5 ~]# ...
3
votes
1answer
206 views

Why is Postgres sending network traffic on OSx

I was looking through my Activity Monitor seeing if there was anything running that was hogging my network and noticed that Postgres has the largest amount of bytes sent. Now the numbers aren't ...
2
votes
2answers
183 views

How do I pipe 7za output directly to psql?

I have a Postgres database dump in a .7z archive. I can extract it and import it with: 7za e dump.7z dump psql -h localhost db_name < dump but I'm just running out of disk space. What is the ...
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 ...
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 ...
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
240 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 ...
2
votes
1answer
843 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
0
votes
1answer
629 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 ...
1
vote
1answer
162 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
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
136 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 ...
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
649 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?
-2
votes
1answer
1k 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 ...
1
vote
0answers
370 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 ...
4
votes
1answer
11k 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
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
157 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
55 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
0answers
415 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 this error message: Error. There has been an error. Unable to write inside TEMP environment variable ...