PostgreSQL is a powerful, open source object-relational database system.

learn more… | top users | synonyms

1
vote
1answer
1k views

apt-get -f install gives error

When I run apt-get -f install, it gives the following error: # apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting ...
2
votes
2answers
7k 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.
5
votes
1answer
654 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 ...
2
votes
2answers
4k 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 & $ ...
1
vote
2answers
876 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 ...
0
votes
2answers
914 views

How to Install PostgreSQL 8.4 on 8.04?

How can I install Postgresql 8.4 for Ubuntu Hardy 8.04 ? sudo apt-get install postgresql will install postgreSQL 8.3 I tried installing individual packages from ...
6
votes
1answer
2k 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 ...
8
votes
2answers
10k 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 ...
13
votes
6answers
9k 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 ...
2
votes
1answer
4k 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 ...
1
vote
1answer
737 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
900 views

How do I install Davical?

i'm using ubuntu 11.4 oneiric ocelot and tried to set up the Davical Server. I have installed it and added the users davical_app and davical_dba. A tutorial on ...
2
votes
1answer
2k views

Is there an Postgres ERD tool (or pgAdmin III plugin)?

Don't hold it against me, but I have a fond memory of MS SQL Server Management Studio. I could very easily generate an ERD diagram from an existing database. Tables, relationships, the works. You ...
1
vote
1answer
5k 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 ...
2
votes
1answer
659 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/...?
7
votes
2answers
3k 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 ...
1
vote
1answer
3k 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
838 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
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)
9
votes
2answers
35k 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 ...
0
votes
1answer
5k views

How do I uninstall Postgres?

How can I completely uninstall postgres and reinstall it. I have tried: sudo apt-get --purge remove postgresql postgresql-doc postgresql-common But I got: Package postgresql is not installed, so ...
3
votes
1answer
705 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 ...
25
votes
3answers
21k 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 ...
3
votes
2answers
8k 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 ...
2
votes
0answers
410 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 ...
16
votes
2answers
24k 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
5answers
13k 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 ...
1
vote
1answer
547 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)?
2
votes
2answers
2k 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 ...
9
votes
1answer
3k 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 ...
1
vote
3answers
1k views

When will postgres 9 be supported?

When will Ubuntu support postgres 9?
6
votes
2answers
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 ...
0
votes
2answers
378 views

After upgrade to 10.10, mediawiki on postgres is broken

I upgraded to Ubuntu 10.10 from 10.04. 90% of the upgrade was ok but my Ubuntu-apache2-postgres-8.4 - mediawiki1.16 does not work anymore. Is there a bug in the postgres client or in php5 pg?
4
votes
3answers
6k 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 ...