PGAdmin

Started by Jillian Carrollalmost 24 years ago7 messagesgeneral

Jump to latest

Jillian Carroll

jillian@koskie.com

almost 24 years ago

Has anybody had any problems with PGAdmin II? Anything I should watch out
for?

--
Jillian

Devrim GUNDUZ

devrim@oper.metu.edu.tr

almost 24 years ago

In reply to: Jillian Carroll (#1)

Re: PGAdmin

hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:

Has anybody had any problems with PGAdmin II? Anything I should watch out
for?

Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime error... Could not
report it to the developers yet.

Best regards,

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

Ian Harding

ianh@tpchd.org

almost 24 years ago

In reply to: Devrim GUNDUZ (#2)

Re: PGAdmin

I installed it last night on XP and it worked great, but gave a harmless error when I clicked directly on the Tables node in the tree. I haven't reported it yet either... I was very impressed with it, though.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org

Devrim GUNDUZ <devrim@oper.metu.edu.tr> 04/10/02 09:40AM >>>

hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:

Has anybody had any problems with PGAdmin II? Anything I should watch out
for?

Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime error... Could not
report it to the developers yet.

Best regards,

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Import Notes

Resolved by subject fallback

Jillian Carroll

jillian@koskie.com

almost 24 years ago

In reply to: Ian Harding (#3)

Re: PGAdmin

I'm getting the error:

no pg_hba.conf entry for host (IP), user (user), database (db)

I'm new to this and not really sure where to begin with this file...

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Ian Harding
Sent: April 10, 2002 10:53 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PGAdmin

I installed it last night on XP and it worked great, but gave a harmless
error when I clicked directly on the Tables node in the tree. I haven't
reported it yet either... I was very impressed with it, though.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org

Devrim GUNDUZ <devrim@oper.metu.edu.tr> 04/10/02 09:40AM >>>

hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:

Has anybody had any problems with PGAdmin II? Anything I should watch out
for?

Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime error... Could not
report it to the developers yet.

Best regards,

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Ian Harding

ianh@tpchd.org

almost 24 years ago

In reply to: Jillian Carroll (#4)

Re: PGAdmin

That's easy. You need to add an entry to the pg_hba.conf file that looks something like

host all 192.168.100.0 255.255.255.0 trust

and restart the the postmaster. It says "There are hosts, who can connect to all databases, whose ip addresses are 192.168.100.x, with a netmask of 255.255.255.0, who I will trust to connect with no password or other authentication."

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org

"Jillian Carroll" <jillian@koskie.com> 04/10/02 09:53AM >>>

I'm getting the error:

no pg_hba.conf entry for host (IP), user (user), database (db)

I'm new to this and not really sure where to begin with this file...

I installed it last night on XP and it worked great, but gave a harmless
error when I clicked directly on the Tables node in the tree. I haven't
reported it yet either... I was very impressed with it, though.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org

Devrim GUNDUZ <devrim@oper.metu.edu.tr> 04/10/02 09:40AM >>>

hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:

Has anybody had any problems with PGAdmin II? Anything I should watch out
for?

Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime error... Could not
report it to the developers yet.

Best regards,

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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

Import Notes

Resolved by subject fallback

Devrim GUNDUZ

devrim@oper.metu.edu.tr

almost 24 years ago

In reply to: Jillian Carroll (#4)

Re: PGAdmin

Hi Jillian,

On Wed, 10 Apr 2002, Jillian Carroll wrote:

I'm getting the error:

no pg_hba.conf entry for host (IP), user (user), database (db)

I'm new to this and not really sure where to begin with this file...

As written in the error message, you must add your ip in pg_hba.conf
(PostGresql Host Based Authentication.CONFiguration file) .

Say your ip is : 333.333.333.333, and db_name impiles the name of your
db ;)

A typical line which would not ask for a password would be:

host db_name 333.333.333.333 255.255.255.255 trust

http://www.ca.postgresql.org/users-lounge/docs/7.2/admin-7.2-A4.pdf
Chapter 4 / Section 4.1 (as far as I remember)

This will help you.

Best regards,

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

Dave Page

dpage@pgadmin.org

almost 24 years ago

In reply to: Devrim GUNDUZ (#6)

Re: PGAdmin

-----Original Message-----
From: Devrim GUNDUZ [mailto:devrim@oper.metu.edu.tr]
Sent: 10 April 2002 17:40
To: Jillian Carroll
Cc: pgsql-general@postgresql.org; Dave Page
Subject: Re: [GENERAL] PGAdmin

hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:

Has anybody had any problems with PGAdmin II? Anything I

should watch

out for?

An honest list of known bugs/issues can be found here:
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=9

Your best bet is to try it out though and see if you like it. You can always
use a test database until you're happy that it works properly (and reliably)
and that you like using it. Of course, I'll tell you it works great, but
then I wrote it :-)

Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime
error... Could not
report it to the developers yet.

Hi Devrim, long time, no chat! Anyway, what error do you get? Anything odd
about your environment? Are you running a dev version?

Regards, Dave.

Import Notes

Resolved by subject fallback