Ubuntu
postgresql-common package

  1. Bug #193696
  2. Comment #8

Comment 8 for bug 193696

Revision history for this message
Martin Pitt (pitti) wrote : Re: [Bug 193696] Re: Postgresql 8.3 not responding

Murray Cumming [2008-03-11 12:25 -0000]:
> > Murray, what does "pg_lsclusters" show for you? It will display the
> port and status of the cluster.
>
> murrayc@murrayc-desktop:~$ pg_lsclusters
> Version Cluster Port Status Owner Data directory Log file
> 8.3 main 5433 online postgres /var/lib/postgresql/8.3/main /var/log/postgresql/postgresql-8.3-main.log

Ah, it listens on port 5433. Apparently there already was a cluster on
the standard 5432 port when this one was created?

> murrayc@murrayc-desktop:~$ sudo /usr/lib/postgresql/8.3/bin/pg_controldata /var/lib/postgresql/8.3/main
> [...]
> LC_COLLATE: en_US.UTF-8
> LC_CTYPE: en_US.UTF-8

So that locale must exist, since that is verified on both cluster
creation and startup.

Thanks,

Martin