Обсуждение: BUG #2465: Installation
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.
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
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
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
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