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

Oracle11g localhost:1158/em not connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
1
vote
1answer
849 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 ...
1
vote
1answer
4k views

Setting up postgresql server connection with pgadmin3 fails with Exception

I have installed postgresql database on Fedora 17. When I create a new server connection through pgadmin3, I get this Error in a popup window: postgresql The server doesn't accept the current ...
0
votes
1answer
43 views

postgresql 9.1 raspberry pi could not bind IPv4 socket

when I started my working sinatra app on my Raspberry pi rev 1 machine running wheezy with the latest apt-get upgrade a few weeks ago I find that my postgresql 9.1 server is no longer running. Hunting ...
0
votes
2answers
4k 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 ...
3
votes
1answer
5k views

Postgresql has broken apt-get on Ubuntu

On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
2
votes
2answers
12k 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
39 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
1answer
12 views

How to move postgresql database from one computer to another?

I've been created an Internet service on Debian server. I want to move all data from one server to a new one. So, how can I move the postresql database? What is the best pipeline?
0
votes
0answers
293 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 ...
0
votes
1answer
133 views

Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql

I want to pull data from a PostgreSQL database on my local network with Power Query. By default my version of Excel lists three options under the "Get External Data/From Database" menu on the Power ...
2
votes
1answer
7k 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
2k 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
32 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
43 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
35 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
52 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
936 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
23 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
28 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 ...
0
votes
0answers
30 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
106 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] ...
13
votes
4answers
16k 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 ...
1
vote
0answers
26 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 ...
1
vote
0answers
64 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 ...
0
votes
0answers
19 views

How to connect psql to the forumdb.py(a python file) in ubuntu?

I have my system with UbuntuOS installed. I am following an online course where it indicates the use of Vagrant and connects your Windows/Mac system using the Virtual Box having Linux installed in it. ...
2
votes
0answers
421 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
41 views

Upgrade Postgres from 9.2.2 to 9.3.6

I have an old server with a Postgres 9.2.2 database. Now I have a new server which has a Postgres 9.3.6 database. I copied the data-directory (/var/lib/pgsql/data) from the old server on the new ...
0
votes
0answers
33 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
0answers
32 views

How to check database relationships in PostgreSQL?

A guy made a DB design on MS Server 2010 and managed to import the schema to my PostgreSQL database, the thing is we want to check if the existing relationships were imported as well, how do i do ...
0
votes
1answer
85 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
110 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 ...
3
votes
3answers
737 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
307 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 ...
0
votes
2answers
2k 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
40 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
167 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
64 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
0answers
50 views

Revit DBLink fails to import from PostgreSQL ODBC driver

I am trying to export and import back a Revit 2014 model. I am also using PostgreSQL 9.3/9.4 as backend DBMS. I am able to export correctly the Revit model to a database in PostgreSQL but not the ...
0
votes
1answer
246 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
466 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
386 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
1k 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
57 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
12 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
86 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
34 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
976 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 ...
0
votes
0answers
228 views

Making a pgAdmin connection to PostgreSQL running on VirtualBox

I have a CentOS 6.5 development server that I installed postgresql on. It runs fine and I can connect to it from my computer using pgAdmin all works perfectly. I recently created a backup of this ...