RE: can't connect, strange error

Try:
\connect x
Without the ';'.
It looks like it is looking for a database named 'x;'.
HTH,
Colin

> -----Original Message-----
> From: Jeff [mailto:cleaner@showmethenet.com]
> Sent: Wednesday, January 31, 2001 8:21 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] can't connect, strange error
>
>
> Can someone tell me what is going on.  Below is a sample of
> my interactive command line output inside postgres.  I can't
> install 7.0.2 on my current linux machine.  I installed the
> same version fine on two other linux machines.
>
> //------------------------------------------------------------
> ------------------
>
> jgreer=# \l
>   List of databases
>  Database  |  Owner
> -----------+----------
>  jgreer    | postgres
>  postgres  | postgres
>  root      | postgres
>  singlesc  | root
>  template1 | postgres
> (5 rows)
>
> jgreer=# create database x;
> CREATE DATABASE
> jgreer=# \connect x;
> FATAL 1:  Database "x;" does not exist in the system
> catalog.
> Previous connection kept
> jgreer=#
>
> //------------------------------------------------------------
> ------------------
>
> Here is how I do my install which has always worked.
>
> //------------------------------------------------------------
> ------------------
>
> (untar ungzip source)
>         (cd to <postgres src dir>/src/)
>         ./configure
>
>         gmake
>         gmake install
>
>         add this the .bashrc for postgres
>
>         PATH=".":/usr/local/pgsql/bin:$PATH
>         MANPATH=$MANPATH:/usr/local/pgsql/man
>         PGLIB=/usr/local/pgsql/lib
>         PGDATA=/usr/local/pgsql/data
>         export PATH MANPATH PGLIB PGDATA
>
>         (Edit file /etc/ld.so.conf to add a line
>      /usr/local/pgsql/lib)
>         ( run command /sbin/ldconfig.)
>
>         mkdir /usr/local/pgsql/data
>         chown postgres:postgres /usr/local/pgsql/data
>         su postgres
>
>         initdb
>         /usr/local/pgsql/bin/postmaster -i &
>         createdb
>
>
>         # do this for each user
>    createuser jgreer            # should pull up user id
> from
> /etc/passwd
>         createdb   jgreer
>
>         # add this to /etc/rc.d/rc.local
>         su postgres -c "/usr/local/pgsql/bin/postmaster -i
> -D
> /usr/local/pgsql/data"
>
>
> //------------------------------------------------------------
> ------------------
>
> Thanks
> --
> Jeff Greer
> - B.S. computer science - Univ. MO - Rolla
> - web developer/software engineer,
> dedicated to the struggle against the fascist
> Microsoft hegemony
>