Use the createdb program to create a database. For example,
./createdb testdb
Then, run psql specifying the testdb database. For example,
./psql testdb
Once you are successfully running psql, you can define new users
with the CREATE USER statement.. For example,
create user mauricio
Any such user can then log on under their own user ID and run
./psql testdb
You can use the GRANT statement to grant other users access to tables.
"J. Mauricio Cuenca H." wrote:
> Craig,
>
> Thank you very much for your help, this solved my problem, but now, when I
> try to run "psql" I get the following:
> [postgres@x ~/bin]$ ./psql
> psql: FATAL 1: Database "postgres" does not exist in the system catalog.
>
> What could be now?
>
> J. Mauricio Cuenca H.
> mcuenca@Telesat.com.co
>
> ----- Original Message -----
> From: "Craig Johannsen" <cjohan@home.com>
> To: "J. Mauricio Cuenca H." <mcuenca@Telesat.com.co>
> Cc: "PostgreSQL List" <pgsql-general@hub.org>
> Sent: Wednesday, August 16, 2000 1:10 PM
> Subject: Re: [GENERAL] Problems after instaling PostgreSQL 7.0
>
> > Try setting the LD_LIBRARY_PATH environment variable. For example, in
> Linux:
> > export LD_LIBRARY_PATH=/usr/local/pgsql/lib
> >
====================================
Craig Johannsen
Critical Path Consulting, Inc.
604-762-1514
http://members.home.net/cjohan/cpath
====================================