PostgreSQL is a powerful, open source object-relational database system.
18
votes
3answers
10k views
How do I migrate my postgres data from 8.4 to 9.1?
I have upgraded my ubuntu development machine from 11.04 to 11.10.
In the process my postgres was also upgraded from 8.4 to 9.1.
But I seem to have lost all my data. If I look, I can see that my data ...
12
votes
3answers
13k 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 ...
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 ...
7
votes
2answers
1k views
How do I set which PostgreSQL version is to be used by default?
I have 2 different versions of PostgreSQL installed on my system (Ubuntu Lucid):
/var/lib/postgresql/8.4
/var/lib/postgresql/9.0
By default, when I run a PostgreSQL command such as createdb or ...
6
votes
1answer
3k views
Where can I get a Postgres 9.0 package?
I want to use Postgres 9.0 in Ubuntu. Does anybody know any repository that already has the debian package for Postgres 9.0? Do you think I should wait for the next Ubuntu release or Postgres 9.0 is ...
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 ...
6
votes
1answer
1k views
How do i install postgresql-8.3?
I get
> sudo apt-get install postgresql-8.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package postgresql-8.3 is not available, but is referred ...
5
votes
4answers
9k views
Problem Installing and configuring PostgreSQL
I am a newbie here and to the server administration. A couple of days back I have registered a server with Hetzner with Ubuntu 11.04.
I intend to work with PostgreSQL, for which I have installed ...
5
votes
2answers
4k views
rails & libpq-dev nasty dependencies
I don't know if this question belongs here, but I'll take a shot. Hi. I'm running ubuntu 11.10 dual-boot with windows vista on my machine. On Ubuntu, I've installed RVM, rails gem, & PostgreSQL ...
5
votes
2answers
20k views
Installing pgadmin 3 for Ubuntu 11.10 and postgresql 9.1
I've installed pgadmin3 on a remote ubuntu client and succesfully connected to the postgres db using:
sudo apt-get install pgadmin3
Problem is that when connecting to the postgres 9.1 server it ...
5
votes
1answer
636 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 ...
5
votes
1answer
468 views
Why isn't the new “postgres” user I created showing up in User Accounts?
I just did a fresh install of Ubuntu 12.04 on a Dell Inspiron 1545, then downloaded & installed all the latest updates. Now when I create a new user postgres in the "User Accounts..." window, it ...
4
votes
2answers
998 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 ...
4
votes
4answers
1k 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
...
4
votes
2answers
1k views
How to uninstall PostgreSQL installed from .run file?
I am a new Ubuntu 12.04 user and I'm using 64bit.
This morning I installed Posgresql 9.2 from the graphical installer (not from Ubuntu repository) . Now I want to uninstall it, but I don't know how.
...
4
votes
2answers
65 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
...
4
votes
3answers
233 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 ...
4
votes
4answers
2k views
What is the difference between “service restart” and “service reload”
I'm trying to understand the difference between service restart [someservice] and service reload [someservice]. I understand that "restart" restarts the service whereas "reload" reloads the ...
3
votes
2answers
6k views
How can I update pgadmin3 to v1.14?
I installed Ubuntu 11.10 yesterday. From the repos I installed postgresql and pgadmin3. postgresql 9.1 is the current version but it seems pgadmin3 v1.12 is not properly compatible with 9.1.
How can ...
3
votes
1answer
41 views
juju override defaults in service
Working on the postgresql charm a bit, and I'm wondering if there is a way to supply overrides for default values in a "juju-way".
In my charm that will be consuming the services provided by ...
3
votes
1answer
417 views
pgadmin III doesn't work due to “The server lacks instrumentation functions.”
When pgAdmin III is used to open a PostgreSQL database the following message appears.
There does not seem to be any obvious package listed in the Ubuntu Software Center for this.
The server lacks ...
3
votes
3answers
4k views
pgadmin3: Unable to initialize gtk, is DISPLAY set properly? [closed]
I'm having some trouble getting pgadmin3 to run on a remote server. I'm logging in to the server using SSH with the -X option. When I first installed pgadmin3, I was able to launch it using the ...
3
votes
1answer
611 views
Which Ubuntu version for PostgreSQL 9?
For a database server that will be running in its own VPS:
Is it better-supported to install the latest Ocelot 11.10 release with the standard package for postgresql9, or to install 10.04 LTS with ...
2
votes
1answer
936 views
PostgreSQL 9.1 adminpack install
everywhere I see guides for postgre, it seems to be on version 8.4. In that case the instruction is:
sudo -u postgres psql < /usr/share/postgresql/8.4/contrib/adminpack.sql
that location doesn't ...
2
votes
3answers
544 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 ...
2
votes
1answer
552 views
Where is a postgresql 9.1 database stored in ubuntu 12.04?
I installed and created a Postgresql database on ubuntu. I then created the database using the following command:
sudo su postgres createdb mydatabase
However, I can't figure out where the database ...
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.
2
votes
1answer
2k views
Run a PostgreSQL instance locally
I'm trying to follow this tutorial, but at the beginning it says to run a postgresql instance "locally" instead of as a daemon using the following commands.
$ initdb pg
$ postgres -D pg &
$ ...
2
votes
1answer
2k views
Packages having unmet dependencies: Broken Packages
When I try to install postgresql i get the following error:
sudo apt-get install postgresql-client
Some packages could not be installed. This may mean that you have
requested an impossible ...
2
votes
2answers
49 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?
2
votes
1answer
63 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 ...
2
votes
1answer
80 views
Remove a previously deselected package to install postgres?
So I was meant to run
add-apt-repository ppa:pitti/postgresql
apt-get update
apt-get install postgresql libpq-dev
but instead I ran without the previous two commands
apt-get install postgresql ...
2
votes
1answer
3k views
How do I install pgAdmin III for postgreSQL 9.2?
I have a Windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu 12.10 workstation box.
I installed pgAdmin III from synaptic and also tried direct download from ...
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
1answer
109 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 ...
2
votes
0answers
79 views
Postgresql 8.2 service will not stop and uninstall
My system config is as follows:
System (running on Amazon EC2)
Ubuntu 10.04
Postgresql-8.2 installed and it is working.
ubuntu@ip:~$ sudo /etc/init.d/postgresql-8.2 status:
Running clusters: ...
2
votes
0answers
317 views
Postgresql: change default data path [closed]
I would like to point the PostgreSQL server to a particular non-default data directory upon startup. Right now, I have to (either manually or in a script) use pg_ctl to stop and restart the database ...
1
vote
2answers
456 views
Creating symlink for Postgres
As a developer, I often ssh right into my local database, just to test my application before pushing my code.
However, I find that every time I want to access Postgres, I have to type in
...
1
vote
2answers
439 views
Unable to install PostgreSQL
I am trying to install postgresql on Ubuntu. I tried installing it using the following command:
apt-get install postgresql
Which results in
Reading package lists... Done
Building dependency tree
...
1
vote
1answer
46 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 ...
1
vote
2answers
142 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 ...
1
vote
1answer
104 views
postgreSQL installation from graphical installed
I tried to install postgreSQL on ubuntu 12.04 64-bit. I have version pgsql9.1 on my windows machine and wanted to make both installation the same with the same components.
I downloaded ...
1
vote
2answers
42 views
Regarding inbuilt application PostGreSQL
In my work I need to study about FOSSology. This tool supports only in Linux. So i have installed Ubuntu version 12.10 Quantal. Through net i have come to know Ubuntu has inbuilt postgreSQL ...
1
vote
2answers
5k views
How to uninstall Postgresql properly?
I have messed around with the template1 database, and would like to reset everything as it was.
Hence I have done a sudo apt-get purge postgresql
However the next time I reinstalled it, the ...
1
vote
1answer
283 views
Does libpg-java support passwordless login? [closed]
The following command runs fine, that is, doesn't ask for a password, prints no warnings or errors, and simply provides a DB prompt:
$ psql -U dbuser dbname
psql (8.4.10)
Type "help" for help.
...
1
vote
1answer
4k views
PostgreSQL 8.4 to 9 manual upgrade (11.04 to 11.10)
After updating 11.04 to 11.10 using 'do-release-upgrade', installer did not updated PostgreSQL 8.4 to 9 version, saying that i have to do it manually. But how? I heard many problems, for example data ...
1
vote
1answer
510 views
How do i configure postgis
PostGIS has been installed on ubuntu server 11.10...
Now how do i create a database, admin user, etc..
where does it get installed ls -l /etc/...?
1
vote
1answer
1k views
How do I install Postgres Graphical Installer?
I am a newbie in using Ubuntu (more precisely never used linux except the production deployment ). Now I choose to hold a grip on the system and intalled a latest 11.10 Ubuntu in my 32 bit Intel** ...
1
vote
2answers
999 views
1
vote
1answer
23 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 ...
