The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
3k 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
3answers
526 views

apt-get no longer works after manually deleting folders of a previously installed application

I have been struggling all weekend, to upgrade an existing postgresql database from version 8.4 to 9.1. I have (had) both versions of databases after I updated my OS from 10.0.4 to 12.04. I finally ...
0
votes
1answer
21 views

What packages do I need to install in order to bulld postgres from source?

I need to be able to build postgres-8.4.2 from source. What dependencies should I install?
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.
0
votes
1answer
569 views

postgresql server fail to start ubuntu?

I have an ubuntu system and installed postgresql server on ubuntu. Till yesterday evening its working fine and I did shutdown it properly. Today morning when I started it then it boot and gave the ...
3
votes
2answers
1k views

Why am I unable to install,remove or upgrade packages?

When I wanna do anything with Synaptic or apt-get or stop,start,restart postgresql I receive following error Setting up postgresql-common (114) ... * Starting PostgreSQL 8.4 database server ...
1
vote
1answer
2k 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
1answer
13k views

How to remove PostgreSQL 8.4 completely?

I am looking for a way to remove PostgreSQL 8.4 completely? Can any one help me?
13
votes
6answers
44k views

Cannot connect to postgresql on port 5432

I installed the Bitnami Django stack which included PostgreSQL 8.4. When I run psql -U postgres I get the following error: psql: could not connect to server: No such file or directory Is the ...
16
votes
2answers
23k 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 ...
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 ...
14
votes
3answers
38k views

How to remove Postgres from my installation?

I have ubuntu 9.10(karmic), and when I attempted to install a new program, the postgres was installed as a dependency of that program, no problem at all if the installation occurs with success, but ...
12
votes
4answers
11k views

How to stop postgres from autostarting during start up

I have postgresql 8.4 installed on my desktop. It keeps starting on bootup because I think I used default settings. so I issue /etc/init.d/postgresql stop everytime and sometimes i keep forgetting ...
12
votes
3answers
9k views

How do I create a Unicode databases in PostgreSQL 8.4?

I installed the postgresql-8.4 package with default options. Everything worked fine, however I can't seem to manage to create unicode databases: -- This doesn't work createdb test1 --encoding UNICODE ...
4
votes
3answers
453 views

Which Ubuntu version for PostgreSQL?

I need to order a new server for hosting a PostgreSQL 8.4 database, however I have to choose between Ubuntu 9 or 10: which one would be better / any special caveat with one or the other?
1
vote
1answer
884 views

What calls PostgreSQL's initdb on package installation?

I'm trying to a build a custom package of PostgreSQL with some configuration tweaks suitable for our application. Part of that configuration involves a pg_hba.conf using "trust" instead of the ...
6
votes
4answers
354 views

Postgresql 8.4 for newbies

Are there any how-to's or tutorials about postgresql 8.4 fro doing following things: Logging in to postgresql creating database getting into database environment adding or altering the tables ...