The following bug has been logged online:

Bug reference: 2465
Logged by: Patrick Hayes
Email address: pkhayeskp@hotmail.com
PostgreSQL version: 8.1
Operating system: Window XP
Description: Installation
Details:

I have installed version 8.1. I am trying to access the console. This will
not allow me access. I know I am entering the correct password.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Fri, Jun 02, 2006 at 07:47:02PM +0000, Patrick Hayes wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2465
> Logged by: Patrick Hayes
> Email address: pkhayeskp@hotmail.com
> PostgreSQL version: 8.1
> Operating system: Window XP
> Description: Installation
> Details:
>
> I have installed version 8.1. I am trying to access the console. This will
> not allow me access. I know I am entering the correct password.

I'd bet that you're not.

I suggest going into pg_hba.conf and enabling trust access. Then connect
and change the password and change pg_hba.conf back. You'll need to
reload the config after each pg_hba.conf change.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jim,
Thank you for your help. I have two last questions. How do you get the
system to describe a table? How to you get the system to give a listing of
all the table that a user has in his scheme? Thanks again for all the help.

PAT


>From: "Jim C. Nasby" <jnasby@pervasive.com>
>To: Patrick Hayes <pkhayeskp@hotmail.com>
>CC: pgsql-bugs@postgresql.org
>Subject: Re: [BUGS] BUG #2465: Installation
>Date: Tue, 6 Jun 2006 17:40:39 -0500
>
>On Fri, Jun 02, 2006 at 07:47:02PM +0000, Patrick Hayes wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 2465
> > Logged by: Patrick Hayes
> > Email address: pkhayeskp@hotmail.com
> > PostgreSQL version: 8.1
> > Operating system: Window XP
> > Description: Installation
> > Details:
> >
> > I have installed version 8.1. I am trying to access the console. This
>will
> > not allow me access. I know I am entering the correct password.
>
>I'd bet that you're not.
>
>I suggest going into pg_hba.conf and enabling trust access. Then connect
>and change the password and change pg_hba.conf back. You'll need to
>reload the config after each pg_hba.conf change.
>--
>Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
>Pervasive Software http://pervasive.com work: 512-231-6117
>vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

See \? in psql. In particular, \d. Note that a plain '\d' won't show you
tables that aren't in your search_path.

On Wed, Jun 07, 2006 at 09:53:03AM -0500, pat hayes wrote:
> Jim,
> Thank you for your help. I have two last questions. How do you get the
> system to describe a table? How to you get the system to give a listing of
> all the table that a user has in his scheme? Thanks again for all the help.
>
> PAT
>
>
> >From: "Jim C. Nasby" <jnasby@pervasive.com>
> >To: Patrick Hayes <pkhayeskp@hotmail.com>
> >CC: pgsql-bugs@postgresql.org
> >Subject: Re: [BUGS] BUG #2465: Installation
> >Date: Tue, 6 Jun 2006 17:40:39 -0500
> >
> >On Fri, Jun 02, 2006 at 07:47:02PM +0000, Patrick Hayes wrote:
> >>
> >> The following bug has been logged online:
> >>
> >> Bug reference: 2465
> >> Logged by: Patrick Hayes
> >> Email address: pkhayeskp@hotmail.com
> >> PostgreSQL version: 8.1
> >> Operating system: Window XP
> >> Description: Installation
> >> Details:
> >>
> >> I have installed version 8.1. I am trying to access the console. This
> >will
> >> not allow me access. I know I am entering the correct password.
> >
> >I'd bet that you're not.
> >
> >I suggest going into pg_hba.conf and enabling trust access. Then connect
> >and change the password and change pg_hba.conf back. You'll need to
> >reload the config after each pg_hba.conf change.
> >--
> >Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> >Pervasive Software http://pervasive.com work: 512-231-6117
> >vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jim,
Thank you for all your help.



>From: "Jim C. Nasby" <jnasby@pervasive.com>
>To: pat hayes <pkhayeskp@hotmail.com>
>CC: pgsql-bugs@postgresql.org
>Subject: Re: [BUGS] BUG #2465: Installation
>Date: Thu, 8 Jun 2006 17:02:28 -0500
>
>See \? in psql. In particular, \d. Note that a plain '\d' won't show you
>tables that aren't in your search_path.
>
>On Wed, Jun 07, 2006 at 09:53:03AM -0500, pat hayes wrote:
> > Jim,
> > Thank you for your help. I have two last questions. How do you get
>the
> > system to describe a table? How to you get the system to give a listing
>of
> > all the table that a user has in his scheme? Thanks again for all the
>help.
> >
> > PAT
> >
> >
> > >From: "Jim C. Nasby" <jnasby@pervasive.com>
> > >To: Patrick Hayes <pkhayeskp@hotmail.com>
> > >CC: pgsql-bugs@postgresql.org
> > >Subject: Re: [BUGS] BUG #2465: Installation
> > >Date: Tue, 6 Jun 2006 17:40:39 -0500
> > >
> > >On Fri, Jun 02, 2006 at 07:47:02PM +0000, Patrick Hayes wrote:
> > >>
> > >> The following bug has been logged online:
> > >>
> > >> Bug reference: 2465
> > >> Logged by: Patrick Hayes
> > >> Email address: pkhayeskp@hotmail.com
> > >> PostgreSQL version: 8.1
> > >> Operating system: Window XP
> > >> Description: Installation
> > >> Details:
> > >>
> > >> I have installed version 8.1. I am trying to access the console.
>This
> > >will
> > >> not allow me access. I know I am entering the correct password.
> > >
> > >I'd bet that you're not.
> > >
> > >I suggest going into pg_hba.conf and enabling trust access. Then
>connect
> > >and change the password and change pg_hba.conf back. You'll need to
> > >reload the config after each pg_hba.conf change.
> > >--
> > >Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> > >Pervasive Software http://pervasive.com work: 512-231-6117
> > >vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
>
>--
>Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
>Pervasive Software http://pervasive.com work: 512-231-6117
>vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly