Jay <[EMAIL PROTECTED]> writes:
> i tried the following command but nothing seems to work
> psql -U root -d root
> psql: FATAL: IDENT authentication failed for user "root"
You basically cannot use the -U switch when using IDENT authorization;
that auth mode requires that your presented Postgres u
1)from root su postgres
2)createuser the username
3)exit
4)su the user
5)createdb
psql the database
Jay wrote:
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user "root"
any suggestions
thanks
jay
Oliver Elphick w
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user "root"
any suggestions
thanks
jay
Oliver Elphick wrote:
On Sun, 2004-06-27 at 00:36, Jay wrote:
Hi group,
I am trying to get pgsql working on my debian system
On Sun, 2004-06-27 at 00:36, Jay wrote:
> Hi group,
> I am trying to get pgsql working on my debian system. I installed pgsql
> using apt-get. but then i cant connect to it . i am using the following
> command
> psql -U jay -d jaydb
>
> earlier i used create su postgres 'createdb root' jaydb.
Hi group,
I am trying to get pgsql working on my debian system. I installed pgsql
using apt-get. but then i cant connect to it . i am using the following
command
psql -U jay -d jaydb
earlier i used create su postgres 'createdb root' jaydb.
but now i cannot access the db.
i get the follwing msgs
