PostgreSQL is a powerful, open source object-relational database system.
19
votes
3answers
11k 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 ...
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 ...
5
votes
5answers
3k 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
...
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
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 ...
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
78 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
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
514 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/...?
0
votes
0answers
334 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 ...
