Re: pgadmin3: can't locate server: what am I doing wrong?

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pgadmin3: can't locate server: what am I doing wrong?
Date: 2010-12-13 16:47:06
Message-ID: 4D05DD8A020000A700015202@gwia1.abag.ca.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you for your quick and accurate reply.
I logged in as root, picked the 'add a connection...' option you
suggested and voila! The server is now visible to pgadmin3/root user.

Thanks again, Fred

>>> Guillaume Lelarge <guillaume(at)lelarge(dot)info> 12/13/2010 8:32 AM >>>
Le 13/12/2010 17:20, Fred Parkinson a écrit :
> I am a longtime user of postgersql, using it as a backend and using
odbc to connect and it has been an amazingly stable and useful database
manager.
>
> Now, a longtime Windows user (disgruntled) I am trying to set up a
development platform on a local Suse Linux box which includes a local
install of postgresql.
> Last week I successfully installed postgersql and created a database,
but today pgadmin3 doesn't seem to find it!
> Using the unix ps command I see there are postgre processes running,
so the server is up.
>
> Logged in as user postgre and invoking pgadmin3, 'Server Groups' is
empty.
> logged in as user root and 'server groups' is empty.
> logged in as fredrated and the server is there.
>
> Can someone explain what this means? Why is the server only visible
to this user?
>

Because only this user has configured access to this server. pgAdmin
can
sometimes auto-detect local servers, but you shouldn't rely on this.
Usually, you should add them yourself to pgAdmin (first button on the
toolbar).

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fred Parkinson 2010-12-13 17:28:28 adminpack installed?
Previous Message paulo matadr 2010-12-13 16:46:13 Res: Cluster with LATIN1 and UTF-8