Re: [Gnumed-devel] Postgres installation and setup in lenny

[James Busser]

ok... I am whole again :-)

On 3-Sep-08, at 6:30 PM, Karsten Hilbert wrote:

> I would do
>    apt-get remove --purge postgresql-8.3 postgresql-common


removed, as a result, were
  postgresql* postgresql-8.3* postgresql-common* postgresql-contrib*
  postgresql-contrib-8.3*

I then did
  apt-get install postgresql-8.3 (reinstalls postgresql-common)

and I then did
   apt-get install postgresql
   apt-get install postgresql-contrib
   (which also installed postgresql-contrib-8.3 and three -perl  
packages )

after which pg_lsclusters (running as root) gave
Version Cluster   Port Status Owner    Data  
directory                     Log file
8.3     main      5432 online postgres /var/lib/postgresql/8.3/ 
main       /var/log/postgresql/postgresql-8.3-main.log

and su - postgres (from root)
and then psql template1 -U postgres
permitted me to connect to template1 :-)

Some of the shell output from the reinstallation of the postgres  
server is appended in order to show where files that require editing  
for GNUmed now live (may be helpful if others look up this thread, or  
for the wiki)
...
Do you want to continue [Y/n]? y
Preconfiguring packages ...
Selecting previously deselected package postgresql-common.
(Reading database ... 113601 files and directories currently installed.)
Unpacking postgresql-common (from .../postgresql-common_90_all.deb) ...
Selecting previously deselected package postgresql-8.3.
Unpacking postgresql-8.3 (from .../postgresql-8.3_8.3.3-1_i386.deb) ...
Processing triggers for man-db ...
Setting up postgresql-common (90) ...
Setting up postgresql-8.3 (8.3.3-1) ...
Creating new cluster (configuration: /etc/postgresql/8.3/main, data: / 
var/lib/postgresql/8.3/main)...
Moving configuration file /var/lib/postgresql/8.3/main/ 
postgresql.conf to /etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_hba.conf  
to /etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_ident.conf  
to /etc/postgresql/8.3/main...
Configuring postgresql.conf to use port 5432...
Starting PostgreSQL 8.3 database server: main.
debianhost:/var/lib#