pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux.
5+ messages / 3 participants
[nested] [flat]

* pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux.
@ 1999-05-11 16:06 Robert Carbonari <robertC@opmr.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Robert Carbonari @ 1999-05-11 16:06 UTC (permalink / raw)
  To: pgsql-interfaces

I downloaded the ODBC Driver version 6.3.250 (v06-30-0250) from
www.insightdist.com and installed it on my machine, which runs Windows
NT ver.4.  

I want to use a windows interface called pgAdmin which I downloaded from
<www.vale-it.demon.co.uk/freeware/pgadmin> and installed on my machine.

I've made a DSN entry on my machine which points to a Postgres (version
6.3) database which sits on a Linux server which is running RedHat v5.2.


When I launch pgAdmin and try to connect to the server database, pgAdmin
complains by saying that the datasource is not configured to use the
PostgreSQL version 6.4 communications protocol.  Then I have to cancel
the program.

What's missing?  What did I or my colleague who configured Postgres on
the Linux server do wrong?  Please help.



Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux.
@ 1999-05-11 17:30 Robert Carbonari <robertC@opmr.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Robert Carbonari @ 1999-05-11 17:30 UTC (permalink / raw)
  To: pgsql-interfaces

I downloaded the ODBC Driver version 6.3.250 (v06-30-0250) from
www.insightdist.com and installed it on my machine, which runs Windows
NT ver.4.  

I want to use a windows interface called pgAdmin which I downloaded from
<www.vale-it.demon.co.uk/freeware/pgadmin> and installed on my machine.

I've made a DSN entry on my machine which points to a Postgres (version
6.3) database which sits on a Linux server which is running RedHat v5.2.


When I launch pgAdmin and try to connect to the server database, pgAdmin
complains by saying that the datasource is not configured to use the
PostgreSQL version 6.4 communications protocol.  Then I have to cancel
the program.

What's missing?  What did I or my colleague who configured Postgres on
the Linux server do wrong?  Please help.



Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146





Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux.
@ 1999-05-11 18:24 Robert Carbonari <robertC@opmr.com>
  1999-05-11 18:44 ` Re: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux. Byron Nikolaidis <byronn@solipsys.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Robert Carbonari @ 1999-05-11 18:24 UTC (permalink / raw)
  To: pgsql-interfaces

I downloaded the ODBC Driver version 6.3.250 (v06-30-0250) from
www.insightdist.com and installed it on my machine, which runs Windows
NT ver.4.  

I want to use a windows interface called pgAdmin which I downloaded from
<www.vale-it.demon.co.uk/freeware/pgadmin> and installed on my machine.

I've made a DSN entry on my machine which points to a Postgres (version
6.3) database which sits on a Linux server which is running RedHat v5.2.


When I launch pgAdmin and try to connect to the server database, pgAdmin
complains by saying that the datasource is not configured to use the
PostgreSQL version 6.4 communications protocol.  Then I have to cancel
the program.

What's missing?  What did I or my colleague who configured Postgres on
the Linux server do wrong?  Please help.

Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146





Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone:  (514)738-8885 ext. 146





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux.
  1999-05-11 18:24 pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux. Robert Carbonari <robertC@opmr.com>
@ 1999-05-11 18:44 ` Byron Nikolaidis <byronn@solipsys.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Byron Nikolaidis @ 1999-05-11 18:44 UTC (permalink / raw)
  To: robertC@opmr.com; +Cc: pgsql-interfaces

Robert Carbonari wrote:

> I downloaded the ODBC Driver version 6.3.250 (v06-30-0250) from
> www.insightdist.com and installed it on my machine, which runs Windows
> NT ver.4.
>
> I want to use a windows interface called pgAdmin which I downloaded from
> <www.vale-it.demon.co.uk/freeware/pgadmin> and installed on my machine.
>
> I've made a DSN entry on my machine which points to a Postgres (version
> 6.3) database which sits on a Linux server which is running RedHat v5.2.
>
> When I launch pgAdmin and try to connect to the server database, pgAdmin
> complains by saying that the datasource is not configured to use the
> PostgreSQL version 6.4 communications protocol.  Then I have to cancel
> the program.
>
> What's missing?  What did I or my colleague who configured Postgres on
> the Linux server do wrong?  Please help.
>

Sounds like the version of pgAdmin you have needs to use the postgres 6.4
protocol.
The version of the odbc driver you have is only for 6.3 postgres.
(6-30-0250)

What protocol is your backend running?  i.e., what version of Postgres do
you have?

Byron





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* RE: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux.
@ 1999-05-12 17:41 Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 0 replies; 5+ messages in thread

From: Dave Page @ 1999-05-12 17:41 UTC (permalink / raw)
  To: pgsql-interfaces



> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Byron
> Nikolaidis
> Sent: 11 May 1999 18:45
> To: robertC@opmr.com
> Cc: pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] pgAdmin interface on Windows communicating
> with a PostgreSQL database on Linux.

<SNIP>

> Sounds like the version of pgAdmin you have needs to use the 
> postgres 6.4
> protocol.

The current version of pgAdmin *must* be used with v6.4.x PostgreSQL due
to the layout of the system tables. Unfortunately, due to a little
short-sightedness on my part, I do not have copies of previous versions
of pgAdmin. This will not be the case when 6.5 PostgreSQL is released.

Regards,

Dave.

--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!  



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~1999-05-12 17:41 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-11 16:06 pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux. Robert Carbonari <robertC@opmr.com>
1999-05-11 17:30 pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux. Robert Carbonari <robertC@opmr.com>
1999-05-11 18:24 pgAdmin interface on Windows communicating with a PostgreSQL data base on Linux. Robert Carbonari <robertC@opmr.com>
1999-05-11 18:44 ` Re: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux. Byron Nikolaidis <byronn@solipsys.com>
1999-05-12 17:41 RE: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux. Dave Page <dpage@vale-housing.co.uk>

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