On Mon, May 08, 2006 at 02:10:02PM -0700, robert wrote:
> 1) Isn't the user 'postgres' pre-configured? Running this seems to
> imply so: 'select datname from pg_database;'
> datname
> ---
> postgres
This demonstrates a *database* named postgres. Users are in the pg_user
table.
>
Bruno Wolff III escreveu:
> On Mon, May 08, 2006 at 23:10:31 +0900,
> kmh496 <[EMAIL PROTECTED]> wrote:
> > doesn't that user have to exist since you are using ident method? that
> > means unix username == postgres username.
> > do you have a user named maragato_test on the system?
> > did you
On Mon, May 08, 2006 at 23:10:31 +0900,
kmh496 <[EMAIL PROTECTED]> wrote:
> doesn't that user have to exist since you are using ident method? that
> means unix username == postgres username.
> do you have a user named maragato_test on the system?
> did you create that user in postgres and on t
> > >
> > > # "local" is for Unix domain socket connections only
> > > local all all ident sameuser
> > > # IPv4 local connections:
> > > hostall all 127.0.0.1/32 md5
> > > # IPv6 local connections:
> > > hostall all
Thanks for the response, but changing to 127.0.0.1 didn't help.
Changing this line sets the db wide open:
hostall all 127.0.0.1/32 trust
>From there, another non-root login can access it with any user /
password.
What I really need is this command to work with a non
On 5 May 2006 02:22:32 -0700, robert <[EMAIL PROTECTED]> wrote:
Hi all, hope this is the right list.
I have postgres 8.1 running on linux. We have tests that mostly run on
windows. I want to run these tests on linux.
On these windows boxes, pg_hba.conf has just one line:
hostall al
Hi all, hope this is the right list.
I have postgres 8.1 running on linux. We have tests that mostly run on
windows. I want to run these tests on linux.
On these windows boxes, pg_hba.conf has just one line:
hostall all 127.0.0.1/32 md5
They use 'postgres' as the us
