Skip site navigation (1) Skip section navigation (2)

pgaccess and postgresql

From: "Johannes Graumann" <j_graumann(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pgaccess and postgresql
Date: 2001-04-08 20:32:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

Recently looked for a database system and was hinted towards postgresql in 
combination with pgaccess.

I installed the necessary rpms on my redhat 7.0 and got the most recent 

Now I want to start playing around. I open pgaccess and try to create a new 
database by using the menu: Database-New. I type in a name and upon 
"create", pgaccess produces the following error:
>TCL error executing pg_exec create database xyz
>is not a valid postgresql connection.

Obviously I have neither experiences with postgresql nor with pgaccess. I 
read in the pg documentation, that one is supposed to create a 
postgresql-master account and start postgresql before using it. How do I 
create a master account when installing via rpm?
How can I overcome the error message:

>postgres does not know where to find the database system data.  You >must 
>specify the directory that contains the database system either >by 
>specifying the -D invocation option or by setting the PGDATA >environment 

that shows upon calling "postgres" from bash?

Please help a clueless newby!

Thanks, Johannes
Get Your Private, Free E-mail from MSN Hotmail at

pgsql-novice by date

Next:From: Tom StricklandDate: 2001-04-08 23:55:56
Subject: Re: Re: table version history
Previous:From: Joel BurtonDate: 2001-04-08 18:48:49
Subject: Re: table version history

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group