PostgreSQL is a powerful, open source object-relational database system.
1
vote
1answer
21 views
How to install postgresql-8.4?
sudo add-apt-repository ppa:pitti/postgresql
# ... OK
sudo apt-get install postgresql-8.4
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package ...
0
votes
0answers
14 views
variety of instructions for this error: Error: Unable to initialize gtk, is DISPLAY set properly?
I have pgadmin3 installed on a remote ubuntu server (running nginx) following the instructions I got here https://help.ubuntu.com/community/PostgreSQL
Error: Unable to initialize gtk, is DISPLAY set ...
0
votes
1answer
27 views
Setting up Django and Posgtresql on ubuntu
I am running Kubuntu 12.04 LTS.
I have been reading the django book and I have hit a snag where I'm unable to set up posgresql to work with the django app.
I have installed both python-postgresql ...
0
votes
1answer
15 views
Unable to run PostgreSQL 9.2 [duplicate]
I followed an instruction on how to setup Ubuntu 10.04 with PostgresSQL
$ psql
Or this:
lucid@ubuntu:~$ sudo -u postgres psql postgres
[sudo] password for lucid:
psql: could not connect to ...
0
votes
2answers
29 views
How to create .s.PGSQL.5432?
I installed postgresql 9.
By mistake,I deleted the .s.PGSQL.5432. Now i cant able to add server from pgAdmin. I don't have any server in on .
How to create .s.PGSQL.5432?
No such file or directory
...
0
votes
0answers
18 views
pgadmin3 Error connecting to the server
I can't connect to the server through pgadmin and the error was:
Error connecting to the server: server closed the connection unexpectedly.
This probably means the server terminated abnormally ...
3
votes
1answer
53 views
I don't want to store passwords in an unencrypted file
I'm using Ubuntu 12.04 LTS on my developer machine and just realized that psql stores passwords in '~/.pgpass'. Furthermore this file is unencrypted. So anyone who has super user rights (i.e. is in ...
1
vote
1answer
15 views
What accounts for the differing instructions on setting password for postgres?
I'm following this blog post http://hendrelouw73.wordpress.com/2012/11/14/how-to-install-postgresql-9-1-on-ubuntu-12-10-linux/ to install postgres on ubuntu. These are steps two and three.
STEP 2: ...
-1
votes
0answers
56 views
metasploit: unrecognized service. and Try setting MSF_DATABASE_CONFIG to a file that exists [closed]
On Kubuntu 12.04 I try running the command service metasploit start
and get the error:
metasploit: unrecognized service.
When trying to run arbitrage it also displays Try setting ...
5
votes
5answers
4k views
How to install PostgreSQL on Ubuntu 13.04?
How to install PostgreSQL in Ubuntu 13.04?
I followed by this tutorial, How to install postgreSQL 9-2 - UbuntuGeek.com
But in logs it says:
the package is deprecated and no longer will be used
...
2
votes
2answers
49 views
Cannot open port
I've been struggling to open the port 5432 for remote PostgreSQL access. Which I installed on a Ubuntu 10.04 desktop machine.
Here is the shell log:
xybrek@ubuntu:~$ sudo ufw allow 5432
[sudo] ...
0
votes
0answers
34 views
Ubuntu crashes while upgrading from 11.04 to 11.10 while installing Postgresql
I am in the process of upgrading from Ubuntu 11.04 to 11.10 , but I've experienced the same error for the second time now after trying to upgrade for a second time.
I used the Update Manager program ...
0
votes
3answers
173 views
Install postgresql. Unmet dependencie “ postgresql-common”
I'm trying to install postgis on Ubuntu 13.04. I've attempted to follow a number of different blogs and wikis on line, but always run in to the same problem...
$sudo apt-get install postgis ...
0
votes
1answer
89 views
Got “Package operation failed” error while installing postgresql using ubuntu software center
I am trying to install JDownloader. But, while installing it using sudo apt-get install jdownloader, I got some error. Like this:
j@ubuntu:~$ sudo apt-get install jdownloader
Reading package lists... ...
0
votes
2answers
193 views
How to install apt-get package manager [closed]
I am booting Ubuntu via VirtualBox. PostgreSQL 8.0 is already installed in the disk image I am using. Now I want to upgrade the PostgreSQL database to a higher version.
I tried using:
apt-get upgrade
...
0
votes
1answer
173 views
How to setup DB in postgresql 9.2.4 on 12.04.2 LTS
I THINK I have PostgreSQL running correctly on my box: I have a PID and I see that postgres is "listening" on port 5432.
I'm trying to create a DB to experiment with, using the "Book" db outlined in ...
1
vote
0answers
38 views
ldap postgresql backend segmentation fault
I am running the latest version of LDAP on XUbuntu 12.4 LTS and it works pretty fine as long as I use hdb or bdb as the backend. Nevertheless when I change the backend to sql and try to restart the ...
0
votes
0answers
342 views
13.04 Upgrade Options from Terminal
I will be upgrading a production server from 12.10 to 13.04 from the terminal. I encountered issues upgrading my notebook which resulted in uninstalling PostgreSQL 9.2 (full details here). This ...
0
votes
0answers
19 views
Is there a way to install specific Postgresql driver version
I need to install a specific version(version 9.1.5)of Postgresql Driver for PHP, I am currently using version 9.1.8 and I do not know if the driver version is causing the errors on my code.
I am ...
1
vote
1answer
292 views
Postgres - could not create shared memory segment: Invalid argument
Shmmax, Shmall, I just can't win ;)
I've tried changing around my /etc/sysctl.d/30-postgresql-shm.conf file a fair bit uncommenting and changing the kernel.shmmax and kernel.shmall a bit but it ...
2
votes
2answers
79 views
How do I downgrade PostgreSQLl?
In my ubuntu 12.04 x64 I installed PostgreSQL 8.4. It got automatically upgraded to 9.1.1. Due to some inconsistencies, I want to downgrade it to 8.4. How can I do this using the terminal?
0
votes
1answer
195 views
Uninstall Postgresql 9.1.1
I have Postgresql 9.1.1 in my Ubuntu 12.04 which got installed due to automatic upgrades and whenever I uninstall it using the command:
sudo apt-get --purge remove postgresql-9.1.1
I get an error ...
0
votes
0answers
96 views
Installation of : Django-CMS+PostgreSQL+Ubuntu12.04 on a separate system user account
I am new to Django CMS and Ubuntu. I would like to install Django-CMS on a separate system user on Ubuntu, so that my python environment dedicated to Django-CMS would not conflict with other python ...
6
votes
2answers
2k views
What is the easiest way to install PostGIS?
What is the easiest way to install postgis on Ubuntu Server 11.10?
apt-get install ...
0
votes
1answer
297 views
Is there syntax highlighting for psql?
Is there some setting or package that I could use to give syntax highlighting to psql (the PostgreSQL shell)?
0
votes
1answer
119 views
Update postgresql with latest security update
PostgreSQL announced on the 4th of April a security update to its PostgreSQL server.
I really want to install that update. But if I run sudo apt-get update and sudo apt-get upgrade the update does ...
1
vote
0answers
14 views
How to upgrade postgresql from 9.2.0 to 9.2.4 [duplicate]
The title says it all.
if I run sudo apt-get update and then sudo apt-get upgrade none of the postgresql packages get updated. While the psql version 9.2.0 is and the last update is 9.2.4.
Am I ...
2
votes
1answer
69 views
Getting powernap's IOMonitor to work with postgresql
I have a 12.04 box running postgresql 9.1.8-0ubuntu12.04, which serves a Java webapp (an Atlassian Confluence wiki). I'm trying to take advantage of powernap's IOMonitor feature. However, if I ...
0
votes
1answer
63 views
PostgreSQL postmaster not starting
I'm trying to install a PostgreSQL instance after building it from source, but running the postmaster daemon prior to starting up the database cluster doesn't seem to work. Here's the error message I ...
2
votes
1answer
187 views
pg_connect(): Unable to connect to PostgreSQL server
I have read multiple articles detailing this fix for this exact issue. I have tried all kinds of variations of editing the pg_hba.conf file but no luck I still get the following error in my Apache log ...
5
votes
1answer
776 views
Postgres-xc won't uninstall (Fails on Stopping Co-ordinators)
I was doing some rails development and accidentally installed postres-xc instead of the normal postgres package. I immediately went to remove postgres-xc, but apt-get will not uninstall it. I also ...
13
votes
3answers
14k views
How do I upgrade to Postgres 9.2?
Just recently, I've read that PostgreSQL 9.2 is released. My Ubuntu 12.04 has PostgreSQL 9.1.5 installed. How can I update to 9.2 version? I tried apt-get update and apt-get upgrade but no updates for ...
0
votes
1answer
255 views
Ubuntu 12.04 Depends: postgresql-9.1-postgis
I am installing LocalWiki on a Virtual Machine hosted by 1&1.com It is Ubuntu 12.04.
When I run sudo apt-get install localwiki as instructed by http://localwiki.org/install/,
I get the following ...
1
vote
2answers
180 views
Install postgreSQL on Ubuntu dependency errors
I just installed a Bitnami Ruby Stack (Ubuntu, Rails, Rub, ...).
I would like to install postgreSQL.
I tried the following command:
sudo apt-get install postgresql
But, I get this:
Reading ...
2
votes
2answers
1k views
How to install older version on PostgreSQL and PHP5?
Because of differencies in package versions between my development machine and my provider's server, I have to downgrade packages installed on my computer.
In Ubuntu 10.04 LTS default PostgreSQL ...
2
votes
2answers
3k views
How do I install older PostgreSQL (8.4) in Ubuntu 12.04?
Well, it's the whole question. I installed 9.1 before, but I need older version now and I haven't yet found out how to do that.
1
vote
1answer
29 views
Extending postgresql code
In postgresql source code there is a file called postgres.c precisely in /src/backend/tcop/. Inside there is a function called exec_simple_query.
I want add a line that call my_function that is in ...
0
votes
1answer
421 views
How do I find the path to pg_hba.conf from the shell?
I would like to obtain the path to pg_hba.conf from the shell. The path varies between versions of PostgreSQL. For instance, for 8.4 and 9.1:
/etc/postgresql/8.4/main/pg_hba.conf
...
0
votes
0answers
49 views
Slow Reads While Writing in Ubuntu Server VM
We have a VMWare 5.0 environment with 7 Dell PowerEdge R710s with dual 6 core CPUs and 192GB each. For storage we have a NetApp FAS3210 SAN and currently using 1GB iSCSI. We have dual SAN ...
8
votes
2answers
12k views
How to fix PostgreSQL installation
I upgraded from Maverick to Natty recently and everything went fine except during the dist-upgrade something went wrong with PostgreSQL. I've since tried reinstalling, removing, and even purging it ...
4
votes
3answers
283 views
How to manually restart services affected by apt upgrades?
How can I issue apt upgrades without automatically stopping/starting daemons? I'd like to manually restart services.
To cite a specific example:
I'll revisit a long-running machine and run sudo ...
0
votes
1answer
214 views
Installing PostgreSQL 9.x on Ubuntu 11.04
I tried following the direction from various websites:
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install postgresql
Unfortunately, it still wants to install 8.4. ...
0
votes
1answer
234 views
Can't update or remove PostgreSQL 9.1
The last update of PostgreSQL 9.1.7 seems to break my APT.
When I try to update, I get the following error:
Reading package lists... Done
Building dependency tree
Reading state information... ...
0
votes
1answer
79 views
Attempting to re-install postgres fails due to rabbitmq
On 12.04, when I do apt-get install on postgresql (which is already installed), it returns an error that mentions rabbitmq-server. What are the circumstances that could cause this type of failure?
# ...
-1
votes
1answer
2k views
Error uninstalling postgresql: `Sub-process /usr/bin/dpkg returned an error code (1)` [closed]
I am getting this error while executing
sudo apt-get remove postgresql-8.4
E: Sub-process /usr/bin/dpkg returned an error code (1)
0
votes
2answers
622 views
Postgres gem won't install on 12.10
I am trying to get Ruby on Rails working on my computer but the pg gem keeps failing. I have found a lot of other questions saying that you just need to use the libpq-dev package from apt and that ...
4
votes
2answers
1k views
apt-get upgrade stuck on postgresql dependency
I ran sudo apt-get upgrade on my 12.04 server, and I have become stuck with a PostgreSQL dependency.
The console output (of sudo apt-get -f install) is below:
dpkg: dependency problems prevent ...
2
votes
3answers
612 views
Unmet dependencies. Try using -f
I'm running into the following error when I'm installing any package on 12.04.
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run ...
4
votes
2answers
79 views
Why is there a shell given to user for PostgreSQL?
cat /etc/passwd |grep postgre
postgres:x:115:127:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
apt-cache show postgresql
Package: postgresql
Priority: optional
Section: database
...
1
vote
1answer
52 views
I did not install postgresql, so why do I have postgresql related binaries in 12.04?
I am going to compile postgresql from source, but the system already has postgresql related binaries such as pg_config, which gives me a lot of environment variables etc when I run it. I did not ...
