At 11:14 AM 9/10/99 +0100, [EMAIL PROTECTED] wrote:
>I get the "FATAL 1" message from "postgres -i":
>[postgres@lexis postgres]$ postgres -i
>FATAL 1: Database postgres does not exist in pg_database
>FATAL 1: Database postgres does not exist in pg_database
>What may I be doing wrong?
>(By the way, where is the "-i" option documented? The HTML manual I am
Well, your problem is twofold maybe threefold. For the first problem, you
are trying to connect to a database that doesn't exist. Use createdb to
create the database. The -i option is documented under the postmaster man
page. They are both the same file, just separated by names to
differentiate the function. The postmaster function is used to spawn a
postgres backend for each connection. By default the postmaster/postgres
programs listen on local sockets. However, if you want to be able to
access the database via TCP/IP sockets, then you need the -i
function. Note... calling postmaster will enable you to have multiple
connections... postgres is a single backend. If you want to interact with
the database, I would recommend using the PSQL frontend client, or creating
your own.
E.G. You want to create a database called "networks" then connect to it.
1) Make sure that postmaster (prefered) is running, or a single postgres.
2) As your postgres user, run "createdb networks"
3) connect to the database with "psql networks"
*if you type createdb with no parameters, it will create a database with
the name of the user you are logged in as. Eg. As postgres, you type
"createdb", it will create a database called "postgres"
Hope this helps.
Sincerely Yours,
Jacques Dimanche
VP of Research and Development
Tridel Technologies, Inc.
************
