pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: MPaule Torre <torre@obs-vlfr.fr>
To: Robert Treat <xzilla@users.sourceforge.net>
To: Yiqun Lin <Yiqun.Lin@NAU.EDU>
Cc: pgsql-admin@postgresql.org
Subject: Re: adduser postgres
Date: Tue, 21 Sep 2004 09:28:06 +0200
Message-ID: <5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr> (raw)
In-Reply-To: <200409210233.39825.xzilla@users.sourceforge.net>
References: <6.1.1.1.2.20040914083249.01c894d8@mailbox.nau.edu>
	<6.1.1.1.2.20040914083249.01c894d8@mailbox.nau.edu>

Hye

I had a similar problem and I solved it by :
* deleting and re-creating the user with passwd
* Verify in pg_hba.conf the access and users (It is at this level I had 
problem  from fields -be carefull with the editor- and the "identuser"  / 
try to put trust in a first time)
* giving rights to this user to my db
* using  psql -U username -d dbname

I hope it helps

mp torre




view thread (3+ messages)

Message-ID: <5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr>
Permalink:  ../5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr/
Also on:    postgresql.org/message-id/5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: torre@obs-vlfr.fr, xzilla@users.sourceforge.net, Yiqun.Lin@NAU.EDU
  Subject: Re: adduser postgres
  In-Reply-To: <5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr>
  References: <6.1.1.1.2.20040914083249.01c894d8@mailbox.nau.edu> <5.0.2.1.2.20040921085017.00a7ba70@oceane.obs-vlfr.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox