Received: from mailrtr03.ntelos.net (mailrtr03.ntelos.net [216.12.0.103])
	by postgresql.org (Postfix) with ESMTP id ED2D7474E49
	for <pgsql-interfaces@postgresql.org>;
	Wed, 31 Jul 2002 17:30:46 -0400 (EDT)
Received: from wsogmm2 (chas-106-198.access.ntelos.net [216.12.106.198])
	by mailrtr03.ntelos.net (8.11.4/8.11.4) with ESMTP id g6VLUkP32161;
	Wed, 31 Jul 2002 17:30:46 -0400
Content-Type: text/plain;
  charset="iso-8859-1"
From: "John L. Turner" <jlt@wvinter.net>
Reply-To: jlt@wvinter.net
Organization: JCI Inc.
To: "C. Maj" <cmaj@freedomcorpse.info>
Subject: Re: PGACCESS Error Relative Path @ export table
Date: Wed, 31 Jul 2002 17:27:37 +0000
User-Agent: KMail/1.4.2
References: <Pine.LNX.4.44.0207311537490.3306-100000@freebird.stanley.cup>
In-Reply-To: <Pine.LNX.4.44.0207311537490.3306-100000@freebird.stanley.cup>
Cc: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200207311727.37366.jlt@wvinter.net>
X-Archive-Number: 200207/150
X-Sequence-Number: 2959

C. Maj, wanted me to know...
> On Wed, 31 Jul 2002, John L. Turner waxed:
>
> <snip>
>
> > > > P.S. Why didn't the original message just say permissions not set f=
or
> > > > X user ?
> > >
> > > I just sent a patch in, so that it gives a decent error message. Not
> > > sure if it will get applied or not...
>
> No, I just put some stuff in CVS to allow for import/export a la the
> psql \copy command, which is really COPY FROM stdin/stdout
> It's at pgaccess.org
>
> > Would like to see a simular corrected message when trying to Create a N=
EW
> > database with pgaccess:
> >
> > "Tcl error executing pg_exec create database mytestdb
> >
> > is not a valid postgresq connection"
> >
> > That type of message is not too helpful to newbies like me.
> >
> > Best regards for quick replies!
> > John Turner
>
> I didn't know you could make new databases with pgaccess.  Huh.  I tried
> it and it seems to work, but my pg_hba.conf is not permissive enough to
> let me connect to the new database.  Perhaps that is your problem?  Are
> you connecting as a user who has privilege enough to create databases?
>
> --Chris

Mine looks like this...

pg_hba.conf
# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARG=
UMENT

local      all                                          trust
host       all         127.0.0.1     255.255.255.255    trust
_________________________

I did not MAKE a new database in pgaccess.
I was able to ONLY add to an existing one,
created by user postgres as follows:
=20
postgres@X:~>psql mytestdb <  /usr/share/doc/packages/postgresql-tk/formdem=
o.sql

Question:
What user were you when you created a NEW pgaccess database ?
You maybe on to something here.


--=20
John