BUG #2465: Installation

Started by pat hayesalmost 20 years ago5 messagesbugs
Jump to latest
#1pat hayes
pkhayeskp@hotmail.com

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.

#2Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: pat hayes (#1)
Re: BUG #2465: Installation

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

#3pat hayes
pkhayeskp@hotmail.com
In reply to: Jim Nasby (#2)
Re: BUG #2465: Installation

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

Show quoted text

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

#4Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: pat hayes (#3)
Re: BUG #2465: Installation

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

#5pat hayes
pkhayeskp@hotmail.com
In reply to: Jim Nasby (#4)
Re: BUG #2465: Installation

Jim,
Thank you for all your help.

Show quoted text

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