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

4
votes
1answer
18k 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
219 views

Can not find script file prerun_checks.vbs when installing postgresql 9.4.4 on Windows x64

I am getting the following error in the bitrock_installer log when I try to install postgresql (postgresql-9.4.4-3-windows x64): Script output: Input Error: Can not find script file ...
0
votes
0answers
418 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 ...
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 ...
4
votes
2answers
3k views

How can I use UTF-8 on Linux from Windows 7 via PuTTY?

I use PuTTY on Windows 7 to access a Linux machine with Ubuntu 10.10. I think that Windows 7 is using Latin-1. But I need to use UTF-8 on the Linux machine and in a PostgreSQL database. How can I do ...
1
vote
1answer
48 views

NAS suitable for this situation?

I work from home and am considering getting a NAS. Would using a NAS be suitable for my situation: I alternate working from a desktop and laptop, both of which run Linux I use PostgreSQL a lot along ...
0
votes
2answers
200 views

Unable to install PosgreSQL on Ubuntu 14.04

I have been trying to install PostgreSQL on my Ubuntu machine. I end up getting this error. postgresql : Depends: postgresql-9.3 but it is not going to be installed postgresql-contrib : Depends: ...
1
vote
1answer
193 views

PgAdmin III writes files with junk in them, which causes PSQL to fail

I encountered the dilemma of needing to run some psql console commands because a colleague needed to use psql's \i directive in a saved script to execute additional SQL-statements from another file, ...
1
vote
0answers
155 views

Cannot configure PostgresSQL extension for php in Cpanel

I have a Centos 6.6 x86_64 vps cloud server with WHM and cpanel. It contains easyapache installed in it and working fine. php sites are working fine with it. I have installed PostgresSQL 9.3 in the ...
1
vote
2answers
2k 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 ...
2
votes
1answer
35 views

Is the order of columns significant in a Postgresql Primary key definition?

Postgresql allows you to define a primary key using a group of columns instead of one if desired, like so: PRIMARY KEY(a_id, b_id) But is the order of the columns in this definition significant? ...
0
votes
1answer
69 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
1
vote
0answers
39 views

Why would updating postgresql-client uninstall postgresql?

On a Debian 7 server, apt-get was offering me to upgrate the following 2 packages: postgresql-9.1 and postgresql-client-9.1. Since I didn't want to restart the database server, I decided only to ...
0
votes
1answer
170 views

Snorby with PostgreSQL installation issue in Mac OS X 10.10.2 (Yosemite)

Trying to setup Snorby for Snort with PostgreSQL on Mac OS X 10.10.2 (Yosemite) Snort 2.9.7.2 GRE (Build 177) PostgreSQL 9.4.1 ruby 1.9.3p551 (2014-11-13 revision 48407) [x86_64-darwin14.1.0] ...
1
vote
0answers
43 views

Permission denied trying to setup postgres sql

I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on. So, When I try to ...
2
votes
0answers
98 views

I'm trying to install PostgreSQL onto Ubuntu 14.04, but I am having difficulties after following a guide

I originally followed the guide at http://www.postgresql.org/docs/9.2/static/runtime.html. It instructed me to install postgres-xc, which is meant for making clusters of databases. On other sites, I ...
2
votes
0answers
508 views

How to copy and paste content from PostGIS psql console in Windows 7?

I just get started with POSTGIS and I am digging through Mannig's POSTGIS in Action. I am using Windows 7, POSTGIS 1.5 and Postgresql 9. Sadly, I am not able to copy and paste anything from my text ...
0
votes
0answers
43 views

I can't loign as postgres user

I have recently done a backup using Time Machine, shifting the data from a Mac mini to a Macbook pro. In this process I lost the possibility to access to postgres with my user. I can see the user on ...
0
votes
1answer
179 views

How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser

I've spent all day working on a Database project to try and teach myself how to use SQL and PHP. When I finally went to go and try to host it, the command prompt kept closing really quickly. I took a ...
0
votes
2answers
232 views

Postfix not connecting to postgres pool with local ip address

I have a postfix e-mail server that is contacting a database to query and verify e-mail addresses etc. It connects using pgbouncer to cycle through connections, however my problem was that the ...
9
votes
3answers
3k 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 ...
1
vote
0answers
680 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
2answers
3k views

Debian PostgreSQL doesn't appear to be working

I've just set up a server running Debian 6.0 64-bit. I've installed PostgreSQL through aptitude, and now i try to access PostgreSQL without any luck. I am trying to access psql as the user postgres, ...
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, ...
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 ...
0
votes
1answer
129 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. ...
0
votes
1answer
578 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 { ...
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 ...
-1
votes
1answer
725 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 ...
-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 ...
2
votes
1answer
136 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
35 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
2answers
185 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
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 ...
1
vote
1answer
5k views

How to change root password for PostgreSql phpPgAdmin?

What is the simplest way to change root password for PostgreSql phpPgAdmin ?
1
vote
1answer
218 views

Terminal highlighting and auto complete

Do you know some plugin for highlighting and autocomplete in postgreSQL terminal?
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, ...
-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 ...
0
votes
1answer
1k views

How to recompile the PHP with --with-pgsql

I have installed the postgresql, php and apache to Amazon Linux AMI. Now I want to use the phpPgAdmin, it prompts "Your PHP installation does not support PostgreSQL. You need to recompile PHP using ...
1
vote
0answers
1k 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 ...
0
votes
1answer
292 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
127 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
433 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 ...
3
votes
2answers
5k views

How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I ...
2
votes
2answers
3k views

Homebrew postgres won't start after uninstall, reinstall and reboot

I uninstalled and reinstalled postgresql via homebrew. It worked fine until I restarted my computer. Now I'm trying to run my tests and they're blowing up. I'm looking at the current processes and I ...
3
votes
1answer
207 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 ...
0
votes
1answer
81 views

Copying File From One User To Another

So I have this file stored in my account. It's postgres dump. To be able to use postgres it seems that I have to execute the following command. sudo su - postgres Once I do this I am now working as ...
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 ...