pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPGACCESS connection failure?
10+ messages / 4 participants
[nested] [flat]
* PGACCESS connection failure?
@ 2002-07-29 17:05 Preston Lord <webmaster@t2.net>
0 siblings, 1 reply; 10+ messages in thread
From: Preston Lord @ 2002-07-29 17:05 UTC (permalink / raw)
To: pgsql-interfaces
Hi List!
I love the look of the pgaccess gui BUT
upon trying to connect to my postgres server I get
the error:
Error trying to connect to database 'dbname' on host localhost
PostgreSQL error message. Connection to database failed.
could not connect to server: Connection refused
Is the server running on host localhost and accepting TCP/IP connections
on prt 5432?
I am also running unix odbc and DataManager for unixodbc without any
trouble. I run SuSE Linux 8 Pro ... any help is appreciated.
--
Regards
Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 21:53 C. Maj <cmaj@freedomcorpse.info>
parent: Preston Lord <webmaster@t2.net>
0 siblings, 0 replies; 10+ messages in thread
From: C. Maj @ 2002-07-29 21:53 UTC (permalink / raw)
To: Preston Lord <webmaster@t2.net>; +Cc: pgsql-interfaces
Preston--
I get this error when the database isn't running. There is a FAQ
available at www.pgaccess.org that may help point you in the right
direction. It is also kind of the 'new home' for pgaccess with mailing
lists, CVS, etc.
--Chris
On 29 Jul 2002, Preston Lord waxed:
> Hi List!
>
> I love the look of the pgaccess gui BUT
> upon trying to connect to my postgres server I get
> the error:
>
> Error trying to connect to database 'dbname' on host localhost
>
> PostgreSQL error message. Connection to database failed.
> could not connect to server: Connection refused
> Is the server running on host localhost and accepting TCP/IP connections
> on prt 5432?
>
>
> I am also running unix odbc and DataManager for unixodbc without any
> trouble. I run SuSE Linux 8 Pro ... any help is appreciated.
>
--
cmaj_at_freedomcorpse_dot_info
0xC0051F6A
5EB8 2035 F07B 3B09 5A31 7C09 196F 4126 C005 1F6A
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 22:38 William West <wwest@csc.com>
0 siblings, 2 replies; 10+ messages in thread
From: William West @ 2002-07-29 22:38 UTC (permalink / raw)
To: Preston Lord <webmaster@t2.net>; +Cc: pgsql-interfaces
Ran into similar symptoms, found that most utilities
(psql, for example) on the localhost use the Unix
Domain and work fine, but pgaccess uses TCP/IP.
My pg_hba.conf had a host statement to allow
TCP/IP, but postmaster did not have '-i' to enable
TCP/IP. I needed both to use pgaccess.
Preston Lord
<webmaster To: pgsql-interfaces@postgresql.org
@t2.net> cc:
Sent by: Subject: [INTERFACES] PGACCESS connection failure?
pgsql-interfa
ces-owner
07/29/2002
01:05 PM
Hi List!
I love the look of the pgaccess gui BUT
upon trying to connect to my postgres server I get
the error:
Error trying to connect to database 'dbname' on host localhost
PostgreSQL error message. Connection to database failed.
could not connect to server: Connection refused
Is the server running on host localhost and accepting TCP/IP connections
on prt 5432?
I am also running unix odbc and DataManager for unixodbc without any
trouble. I run SuSE Linux 8 Pro ... any help is appreciated.
--
Regards
Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 22:50 Iavor Raytchev <iavor.raytchev@verysmall.org>
parent: William West <wwest@csc.com>
1 sibling, 0 replies; 10+ messages in thread
From: Iavor Raytchev @ 2002-07-29 22:50 UTC (permalink / raw)
To: William West <wwest@csc.com>; +Cc: pgsql-interfaces; Preston Lord <webmaster@t2.net>; pgaccess - developers <developers@pgaccess.org>
Hm... What would that mean? You can't use the -i or you do not want to
use it for some reason?
> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of
> William West
> Sent: Dienstag, 30. Juli 2002 00:39
> To: Preston Lord
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] PGACCESS connection failure?
>
> Ran into similar symptoms, found that most utilities
> (psql, for example) on the localhost use the Unix
> Domain and work fine, but pgaccess uses TCP/IP.
>
> My pg_hba.conf had a host statement to allow
> TCP/IP, but postmaster did not have '-i' to enable
> TCP/IP. I needed both to use pgaccess.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 22:55 Preston Lord <webmaster@t2.net>
parent: William West <wwest@csc.com>
1 sibling, 0 replies; 10+ messages in thread
From: Preston Lord @ 2002-07-29 22:55 UTC (permalink / raw)
To: pgsql-interfaces
ok, all the help is appreciated, but how do I get
posmaster to run with -i by default or is there a way?
webmin simply sends a
/etc/init.d/postgresql start
to start postgres. I can do it manually, just want to know if there
is a solution to force postmaster to use -i always.
I checked the pg_hba.conf for help, but all I found was
# If you want to allow non-local connections, you will need to add more
# "host" records. Also, remember IP connections are only enabled if you
# start the postmaster with the -i option.
how?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 23:06 William West <wwest@csc.com>
0 siblings, 1 reply; 10+ messages in thread
From: William West @ 2002-07-29 23:06 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: pgsql-interfaces; Preston Lord <webmaster@t2.net>; pgaccess - developers <developers@pgaccess.org>
'-i' works fine for me. I did not use it at first because I did not know
that pgaccess needed it.
Was only trying to be helpful to Preston. I have no particular reason
to be disturbed by pgaccess needing TCP/IP ... I just figured that
my TCL/TK did not have any Unix Domain support, and find it
acceptable to enable TCP/IP when needing the services of
pgaccess.
It sounded like Preston's "BUT ..." could be the same thing I
ran into, needing to configure with '-i' when I did not expect to
need to do that, so I posted what I posted.
But since you asked ... IS there a way to configure pgaccess
to use Unix Domain sockets?.
"Iavor
Raytchev" To: William West/CIV/CSC@CSC
<iavor.raytch cc: <pgsql-interfaces@postgresql.org>, "Preston Lord" <webmaster@t2.net>, "pgaccess -
ev developers" <developers@pgaccess.org>
@verysmall.or Subject: Re: [INTERFACES] PGACCESS connection failure?
g>
Sent by:
pgsql-interfa
ces-owner
07/29/2002
06:50 PM
Hm... What would that mean? You can't use the -i or you do not want to
use it for some reason?
> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of
> William West
> Sent: Dienstag, 30. Juli 2002 00:39
> To: Preston Lord
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] PGACCESS connection failure?
>
> Ran into similar symptoms, found that most utilities
> (psql, for example) on the localhost use the Unix
> Domain and work fine, but pgaccess uses TCP/IP.
>
> My pg_hba.conf had a host statement to allow
> TCP/IP, but postmaster did not have '-i' to enable
> TCP/IP. I needed both to use pgaccess.
---------------------------(end of broadcast)---------------------------
TIP 3: 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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 23:26 Preston Lord <webmaster@t2.net>
0 siblings, 1 reply; 10+ messages in thread
From: Preston Lord @ 2002-07-29 23:26 UTC (permalink / raw)
To: pgsql-interfaces
cool, that will work!
Now, another Question..,. I have got pgaccess to run
but everytime I try to click "Design" on one of my tables I get an error
that says:
Note: (oid exists, I can see it fine in all other gui's etc) ideas?
ERROR: Attribute 'oid' not found
ERROR: Attribute 'oid' not found
while executing
"pg_select pgsql4 {select oid,indexrelid from pg_index where
(pg_class.relname='ebads') and (pg_class.oid=pg_index.indrelid)} rec {
lappend PgAcVar(t..."
("uplevel" body line 1)
invoked from within
"uplevel pg_select $args"
(procedure "wpg_select" line 3)
invoked from within
"wpg_select $CurrentDB "select oid,indexrelid from pg_index where
(pg_class.relname='$PgAcVar(tblinfo,tablename)') and
(pg_class.oid=pg_index.indrelid)..."
(procedure "refreshTableInformation" line 48)
invoked from within
"refreshTableInformation"
(procedure "Tables::design" line 5)
invoked from within
"Tables::design $objname"
("Tables" arm line 2)
invoked from within
"switch $PgAcVar(activetab) {
Tables {
Tables::design $objname
}
Schema {
Schema::open $objname
}
Queries {
Queries::design $objname
}
V..."
(procedure "Mainlib::cmd_Design" line 7)
invoked from within
"Mainlib::cmd_Design"
invoked from within
".pgaw:Main.btndesign invoke"
("uplevel" body line 1)
invoked from within
"uplevel #0 [list $w invoke]"
(procedure "tkButtonUp" line 7)
invoked from within
"tkButtonUp .pgaw:Main.btndesign
"
(command bound to event)
On Mon, 2002-07-29 at 17:12, William West wrote:
>
> Easiest way to make '-i' automatic is to put it into
> $PGDATA/postmaster.opts.default.
>
> That file does not automatically exist ... but if you create it,
> postmaster will use it every time it starts.
>
> You can also put it on postmaster's command line,
> or pass it in from pg_ctl's command line, depending
> on how you start the server.
>
--
Regards
Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 23:30 Iavor Raytchev <iavor.raytchev@verysmall.org>
parent: William West <wwest@csc.com>
0 siblings, 1 reply; 10+ messages in thread
From: Iavor Raytchev @ 2002-07-29 23:30 UTC (permalink / raw)
To: William West <wwest@csc.com>; +Cc: pgsql-interfaces; Preston Lord <webmaster@t2.net>; pgaccess - developers <developers@pgaccess.org>
Hello William,
I did not want to be impolite or something :) I am just hunting all
issues that prevent people form using pgaccess as what I notice is that
many people do not send bugs or requests simply because first of all
they can not make it run.
In this line it was important to know if you have anything against
running PostgreSQL with '-i'. Thank you very much for your reply - it
was very helpful and a good feedback.
I hope the Unix Domain sockets question will be answered soon.
All best,
Iavor
> -----Original Message-----
> From: William West [mailto:wwest@csc.com]
> Sent: Dienstag, 30. Juli 2002 01:06
> To: Iavor Raytchev
> Cc: pgsql-interfaces@postgresql.org; Preston Lord; pgaccess -
> developers
> Subject: Re: [INTERFACES] PGACCESS connection failure?
>
> '-i' works fine for me. I did not use it at first because I
> did not know
> that pgaccess needed it.
>
> Was only trying to be helpful to Preston. I have no particular reason
> to be disturbed by pgaccess needing TCP/IP ... I just figured that
> my TCL/TK did not have any Unix Domain support, and find it
> acceptable to enable TCP/IP when needing the services of
> pgaccess.
>
> It sounded like Preston's "BUT ..." could be the same thing I
> ran into, needing to configure with '-i' when I did not expect to
> need to do that, so I posted what I posted.
>
> But since you asked ... IS there a way to configure pgaccess
> to use Unix Domain sockets?.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-29 23:39 Iavor Raytchev <iavor.raytchev@verysmall.org>
parent: Preston Lord <webmaster@t2.net>
0 siblings, 0 replies; 10+ messages in thread
From: Iavor Raytchev @ 2002-07-29 23:39 UTC (permalink / raw)
To: pgaccess - developers <developers@pgaccess.org>; +Cc: Preston Lord <webmaster@t2.net>; pgsql-interfaces
Wasn't that thing with the OID fixed?
Preston,
Which pgaccess version do you run? If it is 0.98.7 - you can get 0.98.8
(release 1) form www.pgaccess.org - there the OID error should have been
fixed. This is a development, but very stable version. pgaccess 0.98.8
is planned to be released together with PostgreSQL 7.3
Which PostreSQL version do you use?
Iavor
> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of
> Preston Lord
> Sent: Dienstag, 30. Juli 2002 01:27
> To: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] PGACCESS connection failure?
>
>
> cool, that will work!
>
> Now, another Question..,. I have got pgaccess to run
> but everytime I try to click "Design" on one of my tables I
> get an error
> that says:
>
> Note: (oid exists, I can see it fine in all other gui's etc) ideas?
>
> ERROR: Attribute 'oid' not found
>
> ERROR: Attribute 'oid' not found
>
> while executing
> "pg_select pgsql4 {select oid,indexrelid from pg_index where
> (pg_class.relname='ebads') and (pg_class.oid=pg_index.indrelid)} rec {
> lappend PgAcVar(t..."
> ("uplevel" body line 1)
> invoked from within
> "uplevel pg_select $args"
> (procedure "wpg_select" line 3)
> invoked from within
> "wpg_select $CurrentDB "select oid,indexrelid from pg_index where
> (pg_class.relname='$PgAcVar(tblinfo,tablename)') and
> (pg_class.oid=pg_index.indrelid)..."
> (procedure "refreshTableInformation" line 48)
> invoked from within
> "refreshTableInformation"
> (procedure "Tables::design" line 5)
> invoked from within
> "Tables::design $objname"
> ("Tables" arm line 2)
> invoked from within
> "switch $PgAcVar(activetab) {
> Tables {
> Tables::design $objname
> }
> Schema {
> Schema::open $objname
> }
> Queries {
> Queries::design $objname
> }
> V..."
> (procedure "Mainlib::cmd_Design" line 7)
> invoked from within
> "Mainlib::cmd_Design"
> invoked from within
> ".pgaw:Main.btndesign invoke"
> ("uplevel" body line 1)
> invoked from within
> "uplevel #0 [list $w invoke]"
> (procedure "tkButtonUp" line 7)
> invoked from within
> "tkButtonUp .pgaw:Main.btndesign
> "
> (command bound to event)
>
>
> On Mon, 2002-07-29 at 17:12, William West wrote:
> >
> > Easiest way to make '-i' automatic is to put it into
> > $PGDATA/postmaster.opts.default.
> >
> > That file does not automatically exist ... but if you create it,
> > postmaster will use it every time it starts.
> >
> > You can also put it on postmaster's command line,
> > or pass it in from pg_ctl's command line, depending
> > on how you start the server.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PGACCESS connection failure?
@ 2002-07-30 02:14 C. Maj <cmaj@freedomcorpse.info>
parent: Iavor Raytchev <iavor.raytchev@verysmall.org>
0 siblings, 0 replies; 10+ messages in thread
From: C. Maj @ 2002-07-30 02:14 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: William West <wwest@csc.com>; pgsql-interfaces; Preston Lord <webmaster@t2.net>; pgaccess - developers <developers@pgaccess.org>
If you just want to connect over domain sockets, leave the "Host"
entry box blank in the "Open" database dialog. I wouldn't have tried
until Iavor put the question the way he did. Thanks!
--Chris
On Tue, 30 Jul 2002, Iavor Raytchev waxed:
> Hello William,
>
> I did not want to be impolite or something :) I am just hunting all
> issues that prevent people form using pgaccess as what I notice is that
> many people do not send bugs or requests simply because first of all
> they can not make it run.
>
> In this line it was important to know if you have anything against
> running PostgreSQL with '-i'. Thank you very much for your reply - it
> was very helpful and a good feedback.
>
> I hope the Unix Domain sockets question will be answered soon.
>
> All best,
>
> Iavor
>
> > -----Original Message-----
> > From: William West [mailto:wwest@csc.com]
> > Sent: Dienstag, 30. Juli 2002 01:06
> > To: Iavor Raytchev
> > Cc: pgsql-interfaces@postgresql.org; Preston Lord; pgaccess -
> > developers
> > Subject: Re: [INTERFACES] PGACCESS connection failure?
> >
> > '-i' works fine for me. I did not use it at first because I
> > did not know
> > that pgaccess needed it.
> >
> > Was only trying to be helpful to Preston. I have no particular reason
> > to be disturbed by pgaccess needing TCP/IP ... I just figured that
> > my TCL/TK did not have any Unix Domain support, and find it
> > acceptable to enable TCP/IP when needing the services of
> > pgaccess.
> >
> > It sounded like Preston's "BUT ..." could be the same thing I
> > ran into, needing to configure with '-i' when I did not expect to
> > need to do that, so I posted what I posted.
> >
> > But since you asked ... IS there a way to configure pgaccess
> > to use Unix Domain sockets?.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
cmaj_at_freedomcorpse_dot_info
0xC0051F6A
5EB8 2035 F07B 3B09 5A31 7C09 196F 4126 C005 1F6A
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2002-07-30 02:14 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-29 17:05 PGACCESS connection failure? Preston Lord <webmaster@t2.net>
2002-07-29 21:53 ` C. Maj <cmaj@freedomcorpse.info>
2002-07-29 22:38 Re: PGACCESS connection failure? William West <wwest@csc.com>
2002-07-29 22:50 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-29 22:55 ` Preston Lord <webmaster@t2.net>
2002-07-29 23:06 Re: PGACCESS connection failure? William West <wwest@csc.com>
2002-07-29 23:30 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-30 02:14 ` C. Maj <cmaj@freedomcorpse.info>
2002-07-29 23:26 Re: PGACCESS connection failure? Preston Lord <webmaster@t2.net>
2002-07-29 23:39 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox