Обсуждение: 1.2.0 on 8.0.0B3 on Win 2000
Hi,
I downloaded pgAdmin3 1.2.0 (latest as of today) and I can't connect to the postgreSQL 8.0.0beta3 instance I have running on my server. I've been using psql for a while without any problem, but I can't connect using pgAdmin. Is there an issue with pgB3 ? I wished instructions in the help file were just a little more verbose. PgAdmin shows me "Servers (1)" and shows the service "PostgreSQL Database Server 8.0-beta3-dev1" all right and it shows me the following properties :
hostname = localhost
description = PostgreSQL Database Server 8.0-beta3-dev1
Port = 5432
Initial database = template1 (I tried modiying this to "mtdb" using properties but it won't let me)
Username = postgres (now, I installed the service under a service account "postgres8b3", which is not the same as the DB superuser account "postgres")
Need passwd = Y
Connected = N
Running = Y
but the service is crossed with a red "X" so I try connecting to it and I have an error message (French system : "L'instruction à '0X6310eca2' emploie l'adresse mémoire '0x74736f6c'. La mémoire ne peut pas être written". There are a couple of other errors of this type in sequence and then pgAdmin3 aborts. Could it be a problem with my postgresQL installation (win32 binaries from http://www.webbased.co.uk/mca/ see link Win 32 beta3 installer) ?
I tried refreshing, I googled for problems with beta3 on windows and found no clue. I figured I didn't have to add a server since pgAdmin found the service. Do I need to delete it and re-add it? Stop/start the service? Any pointers would be greatly appreciated.
Thanx you.
Yves Moisan
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Yves Moisan
Sent: 02 December 2004 14:14
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] 1.2.0 on 8.0.0B3 on Win 2000Hi,I downloaded pgAdmin3 1.2.0 (latest as of today) and I can't connect to the postgreSQL 8.0.0beta3 instance I have running on my server. I've been using psql for a while without any problem, but I can't connect using pgAdmin. Is there an issue with pgB3 ? I wished instructions in the help file were just a little more verbose. PgAdmin shows me "Servers (1)" and shows the service "PostgreSQL Database Server 8.0-beta3-dev1" all right and it shows me the following properties :
Hi,
There have been some changes to the system catalogues since beta3 came out, so it's not surprising that it doesn't work. Please upgrade your PostgreSQL to beta5 (it's well worth doing for other updates anyway).
Thats the price you pay for running beta releases :-)
Regards, Dave.
Dave Page wrote: > > > ------------------------------------------------------------------------ > *From:* pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] *On Behalf Of *Yves Moisan > *Sent:* 02 December 2004 14:14 > *To:* pgadmin-support@postgresql.org > *Subject:* [pgadmin-support] 1.2.0 on 8.0.0B3 on Win 2000 > > Hi, > > I downloaded pgAdmin3 1.2.0 (latest as of today) and I can't connect > to the postgreSQL 8.0.0beta3 instance I have running on my server. > I've been using psql for a while without any problem, but I can't > connect using pgAdmin. Is there an issue with pgB3 ? I wished > instructions in the help file were just a little more verbose. > PgAdmin shows me "Servers (1)" and shows the service "PostgreSQL > Database Server 8.0-beta3-dev1" all right and it shows me the > following properties : > > > Hi, > > There have been some changes to the system catalogues since beta3 came > out, so it's not surprising that it doesn't work. Please upgrade your > PostgreSQL to beta5 (it's well worth doing for other updates anyway). Do that, but pgAdmin III V1.2 should work with beta1-4 also. Make sure that you allow local connections as well when reinstalling. We might have a problem if pga doesn't succeed to connect under some circumstances; I didn't have the time to investigate this further. Regards, Andreas