Thread: Getting Started

Hi all!
I am having troubles getting started with a database, I have pgsql installed,
but can not seem to connect.
I am running Linux Mandrake 7.2
here is what I get from the command line:

[fred@localhost fred]$ psql
psql: FATAL 1:  Database "fred" does not exist in the system catalog.

if I use the GUI program PostgreSQL Access, and try to create a new database,
I get the error message "Tcl error executing pg_exec create database first is
not valid postgresql connection"
where I was trying to create a database named "first"
What setting have I overlooked?
Sorry if this is a FAQ, but I have looked over the docs, but have not found
anything as of yet.
TIA,
Fred

On Thu, 08 Feb 2001 15:19:16 Fred Schroeder wrote:
>I am having troubles getting started with a database, I have pgsql
>installed,
>but can not seem to connect.
>I am running Linux Mandrake 7.2
>here is what I get from the command line:
>
>[fred@localhost fred]$ psql
>psql: FATAL 1:  Database "fred" does not exist in the system catalog.

You can't create a database from within pgaccess. Create the database from
the command line:

bash$ su
bash# su postgres
bash$ createdb first
bash$ psql first
psql=> \i myscript.sql

Assumes "myscript.sql" contains DROP TABLE, CREATE TABLE, CREATE INDEX, and
GRANT/REVOKE commands. The SQL script can contain multiline comments in C++
fashion:

/* This is a multiline comment.
   It ends with the closing asterisk
   and slash.
*/

or single line comments in SQL fashion:

-- This is a single line comment.
-- You can use several in a row, but
-- each one must begin with two dashes.


Both styles are acceptable to postgresql, and both are displayed as a
comments in my favorite editor, vim.

Tony
--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>