In response to "Josh Harrison" <joshques@xxxxxxxxx>: > Hi > I have a postgres version 7.4 and version 8.3 installed in my system. > 7.4 uses port 5432 and 8.3 uses port 5433. > I started 7.4 and the database is running fine. Now i started the database > server in version 8.3 > and it started fine. > > pg_ctl -D /export/home/josh/postgres8.3/pgsql/data start -l log8.3.log > server starting > -sh-3.00$ pg_ctl status > pg_ctl: server is running (PID: 4408) > /usr4/postgres8.3/bin/postgres -D /export/home/josh/postgres8.3/pgsql/data > > But when I type psql -l I get this error > -sh-3.00$ psql -l > psql: FATAL: database "postgres" does not exist > > why? Is it not possible to have multiple version installations i the same > machine(in different ports)? PostgreSQL 7.4 doesn't install a "postgres" database by default. Try explicitly connecting to template1. -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
