RE: can't connect, strange error
От | Colin Taylor |
---|---|
Тема | RE: can't connect, strange error |
Дата | |
Msg-id | 4B045DC53446D111A6CD00A0C949AB735E78F9@TOBY обсуждение исходный текст |
Ответ на | can't connect, strange error (Jeff <cleaner@showmethenet.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: