I have installed two versions of Postgresql, 8.4 and 9.1. When I try to run psql
it only picks up the previous psql
version. For example, when I run the following line to connect to the database, ax_data
:
C:\Program Files (x86)\PostgreSQL\9.1\bin>psql ax_data
Password:
psql (9.1.2, server 8.4.8)
WARNING: psql version 9.1, server version 8.4.
Some psql features might not work.
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
ax_data=
It is not finding the more recent psql installation. When using pgAdmin
, if I click on psql
a small command window pops up, but when I type commands in nothing is happening. I'm not very experienced with Postgresql so I could have made some basic mistake somewhere along the way. Any thoughts on what I could be doing wrong?
EDIT:
I am able to login using:
C:\>C:\"Program Files (x86)"\PostgreSQL\9.1\bin\psql.exe -p 5434 -U postgres
psql (9.1.2)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# LS
postgres-#
but none of the commands seem to work. For example, whenever I type anything in after the prompt, there is no response.