[GENERAL] multiple version installation in the same machine ????
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)? thanks josh
Re: [GENERAL] multiple version installation in the same machine ????
Josh Harrison wrote: 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 Yep. why? Is it not possible to have multiple version installations i the same machine(in different ports)? It is, and lots of people do. Answer the following questions and you'll find out why you get your error (or just guess, and you'll probably figure it out). Q1. Do you have two versions of the psql command installed? Q2. Which one are you running above? Q3. What is the default port, user, database that it is connecting as to run -l? Q4. Does the version of the PostgreSQL on that port have that user and database? Personally I wrap my commands in aliases: alias psql82='/usr/local/pgsql82/bin/psql -p5433' alias psql83='/usr/local/pgsql83/bin/psql -p5483' Others prefer a small wrapper script, or even a set default installation command. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] multiple version installation in the same machine ????
Thanks...It works... josh On Dec 18, 2007 3:06 PM, Richard Huxton [EMAIL PROTECTED] wrote: Josh Harrison wrote: 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 Yep. why? Is it not possible to have multiple version installations i the same machine(in different ports)? It is, and lots of people do. Answer the following questions and you'll find out why you get your error (or just guess, and you'll probably figure it out). Q1. Do you have two versions of the psql command installed? Q2. Which one are you running above? Q3. What is the default port, user, database that it is connecting as to run -l? Q4. Does the version of the PostgreSQL on that port have that user and database? Personally I wrap my commands in aliases: alias psql82='/usr/local/pgsql82/bin/psql -p5433' alias psql83='/usr/local/pgsql83/bin/psql -p5483' Others prefer a small wrapper script, or even a set default installation command. -- Richard Huxton Archonet Ltd
Re: [GENERAL] multiple version installation in the same machine ????
In response to Josh Harrison [EMAIL PROTECTED]: 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
