[Pkg-postgresql-public] psql & running 8.0 and 8.1 concurrently

[Robert Treat]

On Sunday 16 July 2006 12:47, Martin Pitt wrote:
> Hi Robert,
>
> first, the current PostgresSQL was *designed* to allow multiple
> versions of PostgreSQL run in parallel (and even run several instances
> of one version in parallel.
>

yep, thats why i was hoping that this would work

> Robert Treat [2006-07-16  0:07 -0400]:
> > The servers seem to run ok, but I can't get psql to run...
> >
> > postgres at ridley:~$ psql -l
> > Error: You must install at least one postgresql-client-<version> package.
> >
> > postgres at ridley:~$ dpkg -l | grep postgres
>
> This looks fine (you seem to be running Ubuntu 6.06). However, please
> bear in mind that version 8.0 is *entirely* unsupported! It was
> removed from Debian and is not supported in Ubuntu Dapper either, so
> you are running a PostgreSQL server with known security holes and
> bugs.
>

uh... actually there aren't any known security holes in 8.0.*, but I 
understand where your coming from.  The thing is that doing postgresql 
related development, I need access to an 8.0.x server. (planetpostgresql 
still uses 8.0.x for example)

> That being said, it should still work. What does 'pg_lsclusters' say?
>

postgres at ridley:~$ pg_lsclusters
Version Cluster   Port Status Owner    Data directory                     Log 
file
8.0     main      5480 online 
postgres /var/lib/postgresql/8.0/main       /var/log/postgresql/postgresql-8.0-main.log
8.1     main      5433 online 
postgres /var/lib/postgresql/8.1/main       /var/log/postgresql/postgresql-8.1-main.log

that seems to work ok, its just the pg specific clients (psql, pg_dump, 
pg_restore) that don't seem to realize I have the client packages installed. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL