[YLUG] postgres on ubuntu

[Richard G. Clegg]

Arthur Clune wrote:
> 
> Anyone tried to install postgresql on ubuntu recently (via apt-get)? I'm 
> getting 404 Not Found errors on the package. Is this just me or is the 
> package borked?

Installed and ran fine on edgy.  Admittedly I wasn't rigorous in 
testing.  It did give a warning about being an old version though.

richard at sepulchrave:~$ sudo apt-get install postgresql
Password:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
   libpq3 postgresql-7.4 postgresql-client postgresql-client-7.4
   postgresql-client-common postgresql-common
Suggested packages:
   postgresql-doc-7.4
Recommended packages:
   postgresql-plpython-7.4 postgresql-plperl-7.4 postgresql-pltcl-7.4
The following NEW packages will be installed:
   libpq3 postgresql postgresql-7.4 postgresql-client postgresql-client-7.4
   postgresql-client-common postgresql-common
0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded.
Need to get 4622kB of archives.
After unpacking 12.8MB of additional disk space will be used.
Do you want to continue [Y/n]?
Get:1 http://archive.ubuntu.com edgy/universe libpq3 1:7.4.13-4 [190kB]
Get:2 http://archive.ubuntu.com edgy-backports/main 
postgresql-client-common 71~edgy1 [40.1kB]
Get:3 http://archive.ubuntu.com edgy/universe postgresql-client-7.4 
1:7.4.13-4 [964kB]
Get:4 http://archive.ubuntu.com edgy-backports/main postgresql-common 
71~edgy1 [103kB]
Get:5 http://archive.ubuntu.com edgy/universe postgresql-7.4 1:7.4.13-4 
[3314kB]
Get:6 http://archive.ubuntu.com edgy/universe postgresql-client 7.5.21 
[4752B]
Get:7 http://archive.ubuntu.com edgy/universe postgresql 7.5.21 [7014B]
Fetched 4622kB in 3s (1180kB/s)
Preconfiguring packages ...
Selecting previously deselected package libpq3.
(Reading database ... 189143 files and directories currently installed.)
Unpacking libpq3 (from .../libpq3_1%3a7.4.13-4_i386.deb) ...
Selecting previously deselected package postgresql-client-common.
Unpacking postgresql-client-common (from 
.../postgresql-client-common_71~edgy1_all.deb) ...
Selecting previously deselected package postgresql-client-7.4.
Unpacking postgresql-client-7.4 (from 
.../postgresql-client-7.4_1%3a7.4.13-4_i386.deb) ...
Selecting previously deselected package postgresql-common.
Unpacking postgresql-common (from 
.../postgresql-common_71~edgy1_all.deb) ...
Selecting previously deselected package postgresql-7.4.
Unpacking postgresql-7.4 (from .../postgresql-7.4_1%3a7.4.13-4_i386.deb) ...
Selecting previously deselected package postgresql-client.
Unpacking postgresql-client (from .../postgresql-client_7.5.21_all.deb) ...
Selecting previously deselected package postgresql.
Unpacking postgresql (from .../postgresql_7.5.21_all.deb) ...
Setting up libpq3 (7.4.13-4) ...

Setting up postgresql-client-common (71~edgy1) ...
Setting up postgresql-client-7.4 (7.4.13-4) ...

Setting up postgresql-common (71~edgy1) ...
adduser: Warning: that home directory does not belong to the user you 
are currently creating

Setting up postgresql-7.4 (7.4.13-4) ...
Creating new cluster (configuration: /etc/postgresql/7.4/main, data: 
/var/lib/postgresql/7.4/main)...
Moving configuration file /var/lib/postgresql/7.4/main/postgresql.conf 
to /etc/postgresql/7.4/main...
Moving configuration file /var/lib/postgresql/7.4/main/pg_hba.conf to 
/etc/postgresql/7.4/main...
Moving configuration file /var/lib/postgresql/7.4/main/pg_ident.conf to 
/etc/postgresql/7.4/main...
Configuring postgresql.conf to use port 5432...
  * Starting PostgreSQL 7.4 database server 
   [ ok ]

Setting up postgresql-client (7.5.21) ...
Setting up postgresql (7.5.21) ...


-- 
Richard G. Clegg,
Dept of Elec. Eng.,
University College London
http://www.richardclegg.org/